Menu

Supplier Prices

Releated Topics.

Filter Extracted Data
Training on Static Data
Supplier

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

Xero

Import from Excel

50 Trans

Nominal Journals
Quotes/Invoices/Orders
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

Xero

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

Xero

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:
    Formula
    Macros
    VBA

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

Manufacturing

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. 

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
 
 

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.

 

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.