Sage 200 Stock Supplier Prices (Pro Version)
Tags StSuppCode1-5 can be specified, to extract/amend or import stock supplier information. When extracted tag StSuppCode1 contains the preferred supplier, and name. To delete a supplier from the supplier list, simply delete the code in StSuppCode1-5 cell, and press Import.
Demonstration Video
| Quick intro: How to Extract/Import Static Data: | |||
| 0:40 | What we are editing in Sage 200 stock record | ||
| 1:30 | 30 Extract Search values, edit import changes | ||
| 6:00 | How to find more information and Training | ||
Download Stock Supplier Prices Extract/Import Template
see 'Stock Suppliers' sheet
To use the template, with Sage 200, install PostTrans. Download
Trial with Sage demo company. Purchase a month subscription for Live Sage Company. Price
Watch the On-line Training course on how to use and customise the templates.
Tags of interest:
| Tag | Description |
| StSuppCode1-5 | Supplier code. Anything after comma is ignored. |
| StSuppP1-5 | Y will designate this supplier as preferred |
| StSuppLeadTime1-5 | Lead Time |
| StSuppLeadUnit1-5 | Lead Time Unit - 0,Days,1,Weeks,2,Months,3,Years |
| SuppOrderQty1-5 | Usual Order Qty |
| SuppOrderMinQty1-5 | Min Order Qty |
| StSuppListPrice1-5 | List Price |
| SuppListPrBs1-5 | List Price Base |
| SuppListPriceCur1-5 | List Price Currency |
| SuppListPriceExp1-5 | List Price Expires |
| SuppPriceSource1-5 | Price Source - 0,Last Buying Price,1,List Price |
| SuppCatPrice1-5 | Catalogue Price |
| SuppCatPrDate1-5 | Catalogue Price Date |
| SuppLastOrdDate1-5 | Last Order Price |
| SuppCuntOrg1-5 | Country of Origin |
| SuppStkCode1-5 | Supplier Stock Code |
Set StSuppP1-5 to YES to change the allocation of Preferred Supplier. When the data is extracted, StSuppP1 contains the preferred Supplier, thus the first column is the preferred Supplier.