Customer Price List Extract/Amend/Import
This PostTrans function allows the user to easily extract, amend, and import Sage 50 Product Price List data.
The cell A1 has a tag "Sage50priceList", “Sage50priceListPrice” to designate the type of import. In this case Price List actual list, and Price List entries within the price list. It uses a series of tags, placed in row 1, to identify the data to be processed, see below for list.
These tags, listed in table below, can be easily added to a spreadsheet using the Tags button. See Training for an explanation of this.
Price List Required fields
To Import/Extract/Amend SageLine50 Price List Data, the following Tags/Fields must be specified:
Cell A1 must equal "Sage50priceList" or “Sage50priceListPrice”
CuCode is used to detect end of spreadsheet. PostTrans will stop Importing/Amending, from row 4 on-wards, when this field is empty.