Supplier Prices

Releated Topics.

Filter Extracted Data
Training on Static Data

Save time updating

Sage 50

Stock/Product Creation
Customer/Supplier Prices
Bill of Material
Project Creation
Location Bins

Sage 200

Simply extract, edit and import


Import from Excel

50 Trans

Nominal Journals
Remote Orders
Product/Stock Adjustments
Sales Receipts
Quick OrderPad

200 Trans

Transaction from Manual Input

Image Alt TextImage Alt Text

Multiple Transactions from CSV file


Solve the Puzzle?

Sage 50

Help on every type of import
Demo Video of all functionality
Loads of Examples included
Online Training
We can help too…

Sage 200

Image Alt Text


Great Customer Satisfaction

Customer Comments

Full Trial with Demo Data
Low cost Subscription
Cancel anytime
From a £1 a day
Saving you hours

Simply extract, edit and import

Power of Excel

Sage 50

Quick Template Creation
Customise with:

Sage 200

To reach your goals quickly

Sage 200

Sage 200 Bins

Sage 200 Warehouse & Bins

Create Sage 200 Bins
Stock Take Bins
Move Bin Stock

Fast, cost effective, easy…

Image Alt TextImage Alt Text


200 Manufact.

Create BOM Stock Easily
Create Bill of Materials
Labour, Machine, Tools

Image Alt Text

Complex tasks quicker...

50 BOM

Project Accounting

200 Projects

Create Project Structure
Update Budgets
Simple Project Entry

Make life easier...

Image Alt Text50 Projects

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. 


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

Related Topics...

Line 50 Filter Extracted Data Line 50 Training on Static Data Line 50 Supplier

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.





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


Important Fields:


Text Req

Returns `POSTED` if Trans line has been posted and will be ignored if `POSTED` (required). Also reports errors/warnings in data row


Text Req

Contains CRC number to help PostTrans detect changes in current row.


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


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:


Text 39 EOF Req

Supplier Code
    In Cell Searching values in table SUPPLIERCODE


Text 30 Req

Stock Code
    In Cell Searching values in table ProdCode


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


Double Req

Value or Percentage - depending on discount type

Associated Product Values:


Double Read

Product Cost (from stock record)


Double Read

Product Sales Price (from stock record)




Rounding Direction (Default:Round up)
        In Cell Searching values:Rounding Direction
                  0, Round up to
                  1, Nearest
                  2, Round Down to



Rounding Method (Default:To)
        In Cell Searching values:Round Method
                  0, To
                  1, Multiples of



Rounding Adjustment



Rounding To Decimal Places




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.