Sage 50 Supplier Prices Import/Update

Releated Topics.

Filter Extracted Data
Training on Static Data
Supplier

Sage 50 : Import Supplier Prices Record (Pro Version)

To extract Supplier Price List data simply press Extract button, on the PostTrans Toolbar, this will allow you to extract Supplier Price List data from Sage 50. You can also add filtering criteria in row 2. See more about filtering

Amending Price List Data

Having extracted supplier special prices, the user can now simply edit the Sage Supplier Special Price data in Microsoft Excel, before re-importing it back to Sage 50. Note only changed records will be updated in Sage.

Importing Price List Data

Simply add new lines to the spreadsheet from row 4 on-wards. Then press Import button, on the PostTrans Toolbar, to import new Sage Supplier Price List records.

Filter

The customer data can be extracted, using the Extract button, and optionally filtered. see How to filter Sage 50 extracted data.

In Cell Search

The user can search for Nominal, Price List, Department codes by entering the start of the code. Or any part of name, see Code Search for more information.

Demonstration Video

Sage Line 50 - Import Supplier Price List/Special Prices
	0:00	Video Introduction
	0:50	Creating Special Prices Template
	2:00	Adding new Supplier Price List
	4:00	Extracting Supplier Special Prices
	5:30	Import new Supplier Prices
	6:00	Delete Supplier Prices
	6:30	Using a filter when extracting Supplier Prices
	7:00	How to find more information and Training

Download Customer Price List Extract/Import Template

Download Supplier Price List Extract/Import Template

Related Example Sheets

You can easily access the example sheets by pressing Help button, on the PostTrans Toolbar to access these related examples.

	Supplier Records	Allow Extract/Amend/Import of Supplier records More info Supplier records Import
	Supplier Price Lists	Extract, Add and Amend the Price List at top level More info Supplier Price List Update
	Supplier Prices	Extract, Add and Amend Supplier Special Prices More info Supplier Price List Update

Sage Line 50 : Supplier Prices Import/Update

This PostTrans function allows the user to easily extract, amend, and import Supplier Special Prices data. A Price list should be defined in the price list table, with code matching the Sage 50 supplier account code, before importing supplier special prices. This also enables you to define the currency of the supplier special prices.

The cell A1 has a tag “Sage50suppPrice" to designate the type of import. It uses a series of tags, placed in row 1, to identify the data to be processed.

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

Cell A1 must equal “Sage50suppPrice”, Import/Extract the List of Supplier Price Lists.

Please watch the above video for a complete explanation.

Restrictions

None

Tags for Price List:Supplier Prices

The following PostTrans tags can be used to extract/import Sage 50 Product Supplier Price Records .

See Online Training for Static templates for a full explanation of tags, and how PostTrans reads them to define the Extract/Import template.

Tag Name	Data Type	Description
Important Fields:
Sage50suppPrice	Text Req	Returns `POSTED` if Trans line has been posted and will be ignored if `POSTED` (required). Also reports errors/warnings in data row
PsCRC	Text Req	Contains CRC number to help PostTrans detect changes in current row.
PsDelete	Text 1	This cell is very important, as it allows PostTrans to let you know of any errors or warnings while importing. If data is extracted out of the system, then it will contain a number. This number is calculated so PostTrans can work out if you have changed
PsSearch^	Text 8	Search for Price record by entering supplier code or pasting list, at top of column, and pressing `Extract` button In Cell Searching values in table SUPPLIERCODE
Pricing Data:
PsPriceList^	Text 39 EOF Req	Supplier Code In Cell Searching values in table SUPPLIERCODE
PsProductCode^	Text 30 Req	Stock Code In Cell Searching values in table ProdCode
PsDiscType^	Integer Req	Price List Calculation Type (Default:Fixed) In Cell Searching values:Price Calc Method 0, Fixed Price 1, STD Sales Price 2, Disc% 3, DiscVal 4, Markup%Cost 5, MarkupValCost 6, PrecOnSTDSales
PsValue	Double Req	Value or Percentage - depending on discount type
Associated Product Values:
PrProdCost	Double Read	Product Cost (from stock record)
PrProdSale	Double Read	Product Sales Price (from stock record)
Rounding:
PsRndDir^	Integer	Rounding Direction (Default:Round up) In Cell Searching values:Rounding Direction 0, Round up to 1, Nearest 2, Round Down to
PsRndMeth^	Integer	Rounding Method (Default:To) In Cell Searching values:Round Method 0, To 1, Multiples of
PsMultiPlus	Double	Rounding Adjustment
PsRndTo/Of	Double	Rounding To Decimal Places
Other:
PsStoredPrice	Double	Price stored for manually recalculated price lists

Req = Field is required EOF = End of file, Stop when no more values

With data type Yes/No fields, if cell starts with 'y' or 'Y' is taken as TRUE

Where ^ denotes a In Cell Code Search, delete ^ at end of tag, to turn off code search

All Text fields are trimmed (spaces before) by default. Add ' to the end of the tag name to stop this.