Menu

Product

Releated Topics.

Filter Extracted Data
Training on Static Data
Product Category
Bill of Materials
Price Lists

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
..u.

Sage 50:Extract/Amend/Import Products

PostTrans imports Products, which could be manually entered with the assistance of in-cell searching, using copy and paste, imported from CSV file or extracted from Sage 50 using the Extract button.

Page Contents

Stock Import in Sage 200

Related Pages

Import Product Features in Sage 50

Simply add new lines to the spreadsheet from row 30 on-wards. Then press Import button, on the PostTrans Toolbar, to import single or multiple Products (Examples shown below).

Advantages

  • Highlighted Validation of codes and data
  • Search for Related Account, Stock, Project, Nominal, using our In-Cell Searching
  • Add formula, vba or macros to manipulate the imported data
  • Press Extract to populate the sheet with existing data, amend and Import
  • Easy importation from CSV file

Examples of importing Sage 50 Products

Product Import template for importing into Sage 50

Product Import template for importing into Sage 50

Demonstration Video

 
 
   Sage Line 50 - Import Product/Stock Data, also Extract and Edit
  0:00 Video Introduction
  1:00 Create Product/Stock Template
  3:30 Extract Product/Stock data from Sage Line 50
  5:00 Copy stock items
  7:00 Alter Template to edit Product Web Information
  8:00 Import Product/Stock back into Sage Line 50
  10:35 How to find more information and Training
 
 

To use the template, with Sage 50, 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.

Template Structure for Static Data

The template must have tag ‘Sage50prod’ in cell A1 to instruct PostTrans that we are interested in Sage 50 Products, and that the sheet is a PostTrans Template.  Pressing Import or Extract on a blank sheet will either open an existing example or create basic template for you to customise.

Row 1 contains a series of tags, which denote to PostTrans the data to be read/written in each column. These tags, and data columns can be rearranged to suit your needs, and the tags are added using the Tags button. See on-line Training   Deleting the Tag name, in the cell, from this row removes the Sage 50 mapping.   Table of Products Tags

Hovering over these tags, in row 1, will show a comment which explains the tags purpose, data type and any other useful details.

Common Features

In-Cell Searching

Any Tag ending with ^ with have a in-cell search facility to look up associated values.  Use SPACE + TAB to see all values, or SPACE and TEXT to perform a text search on description. These are returned to the cell as "CODE, DESCRIPTION".  PostTrans only uses the CODE and ignores the comma and anything after it, thus data from a field would only need the CODE part of the data if from an external imported file.  

In-cell Searching can be turned off by removing the ^ from the end of the tag name, or name in first line of comment (Header cells) to disable in-cell searching for a single column, or header cell.  All in-cell searching can be turned off in SetupIn-cell searching.

Extracting the Data

The data extracted using the Extract button can be filtered, by entering criteria in row 2. Hover over cell A2 for instructions. Extracting Data

Amending Products Data

Having extracted data, the user can now simply edit the Products in Microsoft Excel, before re-importing it back into Sage 50. 

PostTrans uses the tagged column PrCRC to detect changes in rows.  Therefore, only records/rows which have changed since extraction are updated.  If you add or delete a tagged column, PostTrans will treat ALL rows as having changed, and thus ALL records will be updated on next Import.

Importing the Data

Simply press the Import button to validate and import the data into Sage 50.  PostTrans will read the Header cells and then process the rows of data until PrCode column contains no data. The Sage Company imported into can be set in the Setup window.

PostTrans ONLY edits those fields listed on the sheet when importing, thus any existing values, on a record, are unaffected.   New records may have default values for certain fields.

File Import Button

This can be enabled in Setup to easily import cvs, or fixed length files, into sheet for importation.   Formula can also be added, or macros/VBA to manipulate this data before importation.   Import from CSV file.

Validation

Any values and associated codes will be invalid during import.   The cursor will be moved to highlight any problems in data.

Evaluation and License

This functionality will work with Sage Demo data without a license. A license is required to import into any other Sage Company.  Pricing

What else can I do?

Other Sage 50 Extract/Import types

Frequently Asked Questions?

Got another question? It may well be covered on our Frequently Asked Questions page.

Other Useful Topics

Clear Transaction and copy down formula

PostTrans Tags which map to Sage 50

Not all these tags/columns are needed. The table below lists the required and recommended:

Tag Name

Data Type

Description

Important Fields:

Sage50prod

Text Req

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

PrCRC

Text Req

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

PrDelete

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

PrSearch^

Text 30

Search for record by entering code or pasting list, at top of column, and pressing Extract button
    In Cell Searching values in table ProdCode

PrCode

Text 30 EOF Req

Stock Code

PrType^

Text 1

Item Type
        In Cell Searching values:Stock Type
                  0, Stock
                  1, NonStock
                  2, Service

PrDesc

Text 60

Description

PrCategory^

Integer

Stock Category Number
    In Cell Searching values in table ProdCatCode

Product Details:

PrCountryOrigin^

Integer

Country code of origin. Irish data sets only.
    Sage V21 2015 onwards
    In Cell Searching values in table CountryCode

PrIntrastatComCode

Text 8

Intrastat Commodity Code
    Sage V20 2014 onwards

PrIntrastatImportDutyCode

Text 8

Intrastat Import Duty code
    Sage V20 2014 onwards

PrSuppUnitQty

Double

Supplementary Unit Quantity
    Sage V20 2014 onwards

PrWeight

Double

Unit of Weight

PrBarCode

Text 60

BarCode

PrInactive

Yes/No-

Inactive Flag - yes/No
    Sage V21 2015 onwards

PrLocation

Text 16

Location

Defaults:

PrSalesNom^

Text 8

Nominal Code
    In Cell Searching values in table NomCode

PrTaxCode^

Integer

Tax Code (0 to 99)
    In Cell Searching values in table TaxCode

PrPurchaseNom^

Text 8

Purchase Nominal Code
    In Cell Searching values in table NomCode

PrPartNo

Text 16

Supplier`s Part Number

PrSuppAccount^

Text 8

Supplier`s Account Reference
    In Cell Searching values in table SupplierCode

PrDept^

Integer

Department No
    In Cell Searching values in table DeptCode

Ordering:

PrLastPurPrice

Currency

Last Purchase Price

PrLastCostDisc

Currency

Last Cost Discounted Price

PrLastOrdQty

Double Read

Last Order Quantity

PrLastOrdDate

Date Read

Last Purchase Date

Sales Price:

PrSalesPrice

Currency

Sale Price

PrUnitOfSale

Text 8

Unit of Sale

PrLastCost

Currency

Last Cost Price

Status:

PrQtyInStoc

Double Read

Quantity In Stock

PrNewInStk

Text 20 Pro

New IN Stock figure. Used to perform a stock take, after updating Product Record adjust Qty IN to this value. Blanks ignored
How use this tag for Stock Take

PrQtyAlloc

Double Read

Quantity Allocated

PrFree

Double Read

Free Stock

PrQtyOnOrder

Double Read

Quantity On Order

PrQtyReorderLevel

Double

Reorder Level

PrQtyReorder

Double

Reorder Quantity

Stock Take:

PrStockTakeDate

Date

Stock Take Date

PrStockTakeQty

Double

Last Stock Take Quantity

Web:

PrWebDescription

Text 60

Web Description

PrWebLongDesc

Text 1023

Web Long Description

PrWebPublish

Yes/No-

Web Publish Flag

PrWebSpecialOffer

Yes/No-

Web Special Offer

PrWebImage

Text 60

Web Image Filename

Custom Fields:

PrCust1

Text 60

Custom Field 1

PrCust2

Text 60

Custom Field 2

PrCust3

Text 60

Custom Field 3

Memo:

PrMemo

Memo Chg

Stock Record Memo

Cost:

PrCostLA

Currency Read

Brought Forward Costs

PrCostMon1

Currency

Month 1 Costs

PrCostMon2

Currency

Month 2 Costs

PrCostMon3

Currency

Month 3 Costs

PrCostMon4

Currency

Month 4 Costs

PrCostMon5

Currency

Month 5 Costs

PrCostMon6

Currency

Month 6 Costs

PrCostMon7

Currency

Month 7 Costs

PrCostMon8

Currency

Month 8 Costs

PrCostMon9

Currency

Month 9 Costs

PrCostMon10

Currency

Month 10 Costs

PrCostMon11

Currency

Month 11 Costs

PrCostMon12

Currency

Month 12 Costs

PrCostMonFuture

Currency

Future Costs

Cost Previous Year:

PrPriYrCostLA

Currency

Prior Cost Brought Forward

PrPriYrCostMon1

Currency

Prior Year Month 1 Costs

PrPriYrCostMon2

Currency

Prior Year Month 2 Costs

PrPriYrCostMon3

Currency

Prior Year Month 3 Costs

PrPriYrCostMon4

Currency

Prior Year Month 4 Costs

PrPriYrCostMon5

Currency

Prior Year Month 5 Costs

PrPriYrCostMon6

Currency

Prior Year Month 6 Costs

PrPriYrCostMon7

Currency

Prior Year Month 7 Costs

PrPriYrCostMon8

Currency

Prior Year Month 8 Costs

PrPriYrCostMon9

Currency

Prior Year Month 9 Costs

PrPriYrCostMon10

Currency

Prior Year Month 10 Costs

PrPriYrCostMon11

Currency

Prior Year Month 11 Costs

PrPriYrCostMon12

Currency

Prior Year Month 12 Costs

PrPriYrCostFuture

Currency

Prior Year Future Costs

Sales:

PrSalesLA

Currency Read

Sale brought Forward

PrSalesMon1

Currency

Month 1 Sales

PrSalesMon2

Currency

Month 2 Sales

PrSalesMon3

Currency

Month 3 Sales

PrSalesMon4

Currency

Month 4 Sales

PrSalesMon5

Currency

Month 5 Sales

PrSalesMon6

Currency

Month 6 Sales

PrSalesMon7

Currency

Month 7 Sales

PrSalesMon8

Currency

Month 8 Sales

PrSalesMon9

Currency

Month 9 Sales

PrSalesMon10

Currency

Month 10 Sales

PrSalesMon11

Currency

Month 11 Sales

PrSalesMon12

Currency

Month 12 Sales

PrSalesMonFuture

Currency

Future Sales

Budget Sales:

PrBudegtSalesLA

Currency Read

Brought Forward Budget Sales

PrBudegtSalesMon1

Currency

Month 1 Budget Sales

PrBudegtSalesMon2

Currency

Month 2 Budget Sales

PrBudegtSalesMon3

Currency

Month 3 Budget Sales

PrBudegtSalesMon4

Currency

Month 4 Budget Sales

PrBudegtSalesMon5

Currency

Month 5 Budget Sales

PrBudegtSalesMon6

Currency

Month 6 Budget Sales

PrBudegtSalesMon7

Currency

Month 7 Budget Sales

PrBudegtSalesMon8

Currency

Month 8 Budget Sales

PrBudegtSalesMon9

Currency

Month 9 Budget Sales

PrBudegtSalesMon10

Currency

Month 10 Budget Sales

PrBudegtSalesMon11

Currency

Month 11 Budget Sales

PrBudegtSalesMon12

Currency

Month 12 Budget Sales

PrBudegtSalesFuture

Currency

Future Budget Sales

Sales Privious Year:

PrPriYrSalesLA

Currency Read

Prior Year brought Forward

PrPriYrSalesMon1

Currency

Prior Year Month 1 Sales

PrPriYrSalesMon2

Currency

Prior Year Month 2 Sales

PrPriYrSalesMon3

Currency

Prior Year Month 3 Sales

PrPriYrSalesMon4

Currency

Prior Year Month 4 Sales

PrPriYrSalesMon5

Currency

Prior Year Month 5 Sales

PrPriYrSalesMon6

Currency

Prior Year Month 6 Sales

PrPriYrSalesMon7

Currency

Prior Year Month 7 Sales

PrPriYrSalesMon8

Currency

Prior Year Month 8 Sales

PrPriYrSalesMon9

Currency

Prior Year Month 9 Sales

PrPriYrSalesMon10

Currency

Prior Year Month 10 Sales

PrPriYrSalesMon11

Currency

Prior Year Month 11 Sales

PrPriYrSalesMon12

Currency

Prior Year Month 12 Sales

PrPriYrSalesFuture

Currency

Prior Year Future Sales

Qty Sold:

PrQtySoldLA

Double Read

Brought Forward Quantity Sold

PrQtySoldMon1

Double

Month 1 Quantity Sold

PrQtySoldMon2

Double

Month 2 Quantity Sold

PrQtySoldMon3

Double

Month 3 Quantity Sold

PrQtySoldMon4

Double

Month 4 Quantity Sold

PrQtySoldMon5

Double

Month 5 Quantity Sold

PrQtySoldMon6

Double

Month 6 Quantity Sold

PrQtySoldMon7

Double

Month 7 Quantity Sold

PrQtySoldMon8

Double

Month 8 Quantity Sold

PrQtySoldMon9

Double

Month 9 Quantity Sold

PrQtySoldMon10

Double

Month 10 Quantity Sold

PrQtySoldMon11

Double

Month 11 Quantity Sold

PrQtySoldMon12

Double

Month 12 Quantity Sold

PrQtySoldMonFuture

Double

Month 12 Quantity Sold

Budget Qty Sold:

PrBudgetQtySoldLA

Double Read

Brought Forward Budget Quantity Sold

PrBudgetQtySoldMon1

Double

Month 1 Budget Quantity Sold

PrBudgetQtySoldMon2

Double

Month 2 Budget Quantity Sold

PrBudgetQtySoldMon3

Double

Month 3 Budget Quantity Sold

PrBudgetQtySoldMon4

Double

Month 4 Budget Quantity Sold

PrBudgetQtySoldMon5

Double

Month 5 Budget Quantity Sold

PrBudgetQtySoldMon6

Double

Month 6 Budget Quantity Sold

PrBudgetQtySoldMon7

Double

Month 7 Budget Quantity Sold

PrBudgetQtySoldMon8

Double

Month 8 Budget Quantity Sold

PrBudgetQtySoldMon9

Double

Month 9 Budget Quantity Sold

PrBudgetQtySoldMon10

Double

Month 10 Budget Quantity Sold

PrBudgetQtySoldMon11

Double

Month 11 Budget Quantity Sold

PrBudgetQtySoldMon12

Double

Month 12 Budget Quantity Sold

PrBudgetQtySoldMonFuture

Double

Future Budget Quantity Sold

Budget Qty Sold Previous Year:

PrPriYrQtySoldLA

Double Read

Prior Year Brought Forward

PrPriYrQtySoldMon1

Double

Prior Year Month 1 Quantity Sold

PrPriYrQtySoldMon2

Double

Prior Year Month 2 Quantity Sold

PrPriYrQtySoldMon3

Double

Prior Year Month 3 Quantity Sold

PrPriYrQtySoldMon4

Double

Prior Year Month 4 Quantity Sold

PrPriYrQtySoldMon5

Double

Prior Year Month 5 Quantity Sold

PrPriYrQtySoldMon6

Double

Prior Year Month 6 Quantity Sold

PrPriYrQtySoldMon7

Double

Prior Year Month 7 Quantity Sold

PrPriYrQtySoldMon8

Double

Prior Year Month 8 Quantity Sold

PrPriYrQtySoldMon9

Double

Prior Year Month 9 Quantity Sold

PrPriYrQtySoldMon10

Double

Prior Year Month 10 Quantity Sold

PrPriYrQtySoldMon11

Double

Prior Year Month 11 Quantity Sold

PrPriYrQtySoldMon12

Double

Prior Year Month 12 Quantity Sold

PrPriYrQtySoldMonFuture

Double

Prior Year Future Quantity Sold

Discount Qty Band A:

PrDiscA_1_qty

Double Pro

Discount Table A, Break Level 1, Quantity

PrDiscA_1_rate

Double Pro

Discount Table A, Break Level 1, Rate

PrDiscA_2_qty

Double Pro

Discount Table A, Break Level 2, Quantity

PrDiscA_2_rate

Double Pro

Discount Table A, Break Level 2, Rate

PrDiscA_3_qty

Double Pro

Discount Table A, Break Level 3, Quantity

PrDiscA_3_rate

Double Pro

Discount Table A, Break Level 3, Rate

PrDiscA_4_qty

Double Pro

Discount Table A, Break Level 4, Quantity

PrDiscA_4_rate

Double Pro

Discount Table A, Break Level 4, Rate

PrDiscA_5_qty

Double Pro

Discount Table A, Break Level 5, Quantity

PrDiscA_5_rate

Double Pro

Discount Table A, Break Level 5, Rate

PrDiscA_6_qty

Double Pro

Discount Table A, Break Level 6, Quantity

PrDiscA_6_rate

Double Pro

Discount Table A, Break Level 6, Rate

PrDiscA_7_qty

Double Pro

Discount Table A, Break Level 7, Quantity

PrDiscA_7_rate

Double Pro

Discount Table A, Break Level 7, Rate

PrDiscA_8_qty

Double Pro

Discount Table A, Break Level 8, Quantity

PrDiscA_8_rate

Double Pro

Discount Table A, Break Level 8, Rate

PrDiscA_9_qty

Double Pro

Discount Table A, Break Level 9, Quantity

PrDiscA_9_rate

Double Pro

Discount Table A, Break Level 9, Rate

PrDiscA_10_qty

Double Pro

Discount Table A, Break Level 10, Quantity

PrDiscA_10_rate

Double Pro

Discount Table A, Break Level 10, Rate

Discount Qty Band B:

PrDiscB_1_qty

Double Pro

Discount Table B, Break Level 1, Quantity

PrDiscB_1_rate

Double Pro

Discount Table B, Break Level 1, Rate

PrDiscB_2_qty

Double Pro

Discount Table B, Break Level 2, Quantity

PrDiscB_2_rate

Double Pro

Discount Table B, Break Level 2, Rate

PrDiscB_3_qty

Double Pro

Discount Table B, Break Level 3, Quantity

PrDiscB_3_rate

Double Pro

Discount Table B, Break Level 3, Rate

PrDiscB_4_qty

Double Pro

Discount Table B, Break Level 4, Quantity

PrDiscB_4_rate

Double Pro

Discount Table B, Break Level 4, Rate

PrDiscB_5_qty

Double Pro

Discount Table B, Break Level 5, Quantity

PrDiscB_5_rate

Double Pro

Discount Table B, Break Level 5, Rate

PrDiscB_6_qty

Double Pro

Discount Table B, Break Level 6, Quantity

PrDiscB_6_rate

Double Pro

Discount Table B, Break Level 6, Rate

PrDiscB_7_qty

Double Pro

Discount Table B, Break Level 7, Quantity

PrDiscB_7_rate

Double Pro

Discount Table B, Break Level 7, Rate

PrDiscB_8_qty

Double Pro

Discount Table B, Break Level 8, Quantity

PrDiscB_8_rate

Double Pro

Discount Table B, Break Level 8, Rate

PrDiscB_9_qty

Double Pro

Discount Table B, Break Level 9, Quantity

PrDiscB_9_rate

Double Pro

Discount Table B, Break Level 9, Rate

PrDiscB_10_qty

Double Pro

Discount Table B, Break Level 10, Quantity

PrDiscB_10_rate

Double Pro

Discount Table B, Break Level 10, Rate

Discount Qty Band C:

PrDiscC_1_qty

Double Pro

Discount Table C, Break Level 1, Quantity

PrDiscC_1_rate

Double Pro

Discount Table C, Break Level 1, Rate

PrDiscC_2_qty

Double Pro

Discount Table C, Break Level 2, Quantity

PrDiscC_2_rate

Double Pro

Discount Table C, Break Level 2, Rate

PrDiscC_3_qty

Double Pro

Discount Table C, Break Level 3, Quantity

PrDiscC_3_rate

Double Pro

Discount Table C, Break Level 3, Rate

PrDiscC_4_qty

Double Pro

Discount Table C, Break Level 4, Quantity

PrDiscC_4_rate

Double Pro

Discount Table C, Break Level 4, Rate

PrDiscC_5_qty

Double Pro

Discount Table C, Break Level 5, Quantity

PrDiscC_5_rate

Double Pro

Discount Table C, Break Level 5, Rate

PrDiscC_6_qty

Double Pro

Discount Table C, Break Level 6, Quantity

PrDiscC_6_rate

Double Pro

Discount Table C, Break Level 6, Rate

PrDiscC_7_qty

Double Pro

Discount Table C, Break Level 7, Quantity

PrDiscC_7_rate

Double Pro

Discount Table C, Break Level 7, Rate

PrDiscC_8_qty

Double Pro

Discount Table C, Break Level 8, Quantity

PrDiscC_8_rate

Double Pro

Discount Table C, Break Level 8, Rate

PrDiscC_9_qty

Double Pro

Discount Table C, Break Level 9, Quantity

PrDiscC_9_rate

Double Pro

Discount Table C, Break Level 9, Rate

PrDiscC_10_qty

Double Pro

Discount Table C, Break Level 10, Quantity

PrDiscC_10_rate

Double Pro

Discount Table C, Break Level 10, Rate

Discount Qty Band D:

PrDiscD_1_qty

Double Pro

Discount Table D, Break Level 1, Quantity

PrDiscD_1_rate

Double Pro

Discount Table D, Break Level 1, Rate

PrDiscD_2_qty

Double Pro

Discount Table D, Break Level 2, Quantity

PrDiscD_2_rate

Double Pro

Discount Table D, Break Level 2, Rate

PrDiscD_3_qty

Double Pro

Discount Table D, Break Level 3, Quantity

PrDiscD_3_rate

Double Pro

Discount Table D, Break Level 3, Rate

PrDiscD_4_qty

Double Pro

Discount Table D, Break Level 4, Quantity

PrDiscD_4_rate

Double Pro

Discount Table D, Break Level 4, Rate

PrDiscD_5_qty

Double Pro

Discount Table D, Break Level 5, Quantity

PrDiscD_5_rate

Double Pro

Discount Table D, Break Level 5, Rate

PrDiscD_6_qty

Double Pro

Discount Table D, Break Level 6, Quantity

PrDiscD_6_rate

Double Pro

Discount Table D, Break Level 6, Rate

PrDiscD_7_qty

Double Pro

Discount Table D, Break Level 7, Quantity

PrDiscD_7_rate

Double Pro

Discount Table D, Break Level 7, Rate

PrDiscD_8_qty

Double Pro

Discount Table D, Break Level 8, Quantity

PrDiscD_8_rate

Double Pro

Discount Table D, Break Level 8, Rate

PrDiscD_9_qty

Double Pro

Discount Table D, Break Level 9, Quantity

PrDiscD_9_rate

Double Pro

Discount Table D, Break Level 9, Rate

PrDiscD_10_qty

Double Pro

Discount Table D, Break Level 10, Quantity

PrDiscD_10_rate

Double Pro

Discount Table D, Break Level 10, Rate

Discount Qty Band E:

PrDiscE_1_qty

Double Pro

Discount Table E, Break Level 1, Qty

PrDiscE_1_rate

Double Pro

Discount Table E, Break Level 1, Rate

PrDiscE_2_qty

Double Pro

Discount Table E, Break Level 2, Quantity

PrDiscE_2_rate

Double Pro

Discount Table E, Break Level 2, Rate

PrDiscE_3_qty

Double Pro

Discount Table E, Break Level 3, Quantity

PrDiscE_3_rate

Double Pro

Discount Table E, Break Level 3, Rate

PrDiscE_4_qty

Double Pro

Discount Table E, Break Level 4, Quantity

PrDiscE_4_rate

Double Pro

Discount Table E, Break Level 4, Rate

PrDiscE_5_qty

Double Pro

Discount Table E, Break Level 5, Quantity

PrDiscE_5_rate

Double Pro

Discount Table E, Break Level 5, Rate

PrDiscE_6_qty

Double Pro

Discount Table E, Break Level 6, Quantity

PrDiscE_6_rate

Double Pro

Discount Table E, Break Level 6, Rate

PrDiscE_7_qty

Double Pro

Discount Table E, Break Level 7, Quantity

PrDiscE_7_rate

Double Pro

Discount Table E, Break Level 7, Rate

PrDiscE_8_qty

Double Pro

Discount Table E, Break Level 8, Quantity

PrDiscE_8_rate

Double Pro

Discount Table E, Break Level 8, Rate

PrDiscE_9_qty

Double Pro

Discount Table E, Break Level 9, Quantity

PrDiscE_9_rate

Double Pro

Discount Table E, Break Level 9, Rate

PrDiscE_10_rate

Double Pro

Discount Table E, Break Level 10, Rate

PrDiscE_10_qty

Double Pro

Discount Table E, Break Level 10, Quantity

Other:

PrLastSaleDate

Date

Last Sales Date

PrLastUpdated

Date

Last Updated Date

PrIgnStkLevel

Yes/No-

Ignore Stock Levels Flag

BOM:

PrAssLevel

Integer Read

Assembly Level: the number of levels of components and sub-assemblies below the product assembly

BOM Sub Components:

PrBOMcode1^

Text 30 Pro

Sub componenent 1
    In Cell Searching values in table ProdCode

PrBOMcodeQty1

Double Pro

Sub componenent qty 1

PrBOMcode2^

Text 30 Pro

Sub componenent 2
    In Cell Searching values in table ProdCode

PrBOMcodeQty2

Double Pro

Sub componenent qty 2

PrBOMcode3^

Text 30 Pro

Sub componenent 3
    In Cell Searching values in table ProdCode

PrBOMcodeQty3

Double Pro

Sub componenent qty 3

PrBOMcode4^

Text 30 Pro

Sub componenent 4
    In Cell Searching values in table ProdCode

PrBOMcodeQty4

Double Pro

Sub componenent qty 4

PrBOMcode5^

Text 30 Pro

Sub componenent 5
    In Cell Searching values in table ProdCode

PrBOMcodeQty5

Double Pro

Sub componenent qty 5

PrBOMcode6^

Text 30 Pro

Sub componenent 6
    In Cell Searching values in table ProdCode

PrBOMcodeQty6

Double Pro

Sub componenent qty 6

PrBOMcode7^

Text 30 Pro

Sub componenent 7
    In Cell Searching values in table ProdCode

PrBOMcodeQty7

Double Pro

Sub componenent qty 7

PrBOMcode8^

Text 30 Pro

Sub componenent 8
    In Cell Searching values in table ProdCode

PrBOMcodeQty8

Double Pro

Sub componenent qty 8

PrBOMcode9^

Text 30 Pro

Sub componenent 9
    In Cell Searching values in table ProdCode

PrBOMcodeQty9

Double Pro

Sub componenent qty 9

PrBOMcode10^

Text 30 Pro

Sub componenent 10
    In Cell Searching values in table ProdCode

PrBOMcodeQty10

Double Pro

Sub componenent qty 10

PrBOMcode11^

Text 30 Pro

Sub componenent 11
    In Cell Searching values in table ProdCode

PrBOMcodeQty11

Double Pro

Sub componenent qty 11

PrBOMcode12^

Text 30 Pro

Sub componenent 12
    In Cell Searching values in table ProdCode

PrBOMcodeQty12

Double Pro

Sub componenent qty 12

PrBOMcode13^

Text 30 Pro

Sub componenent 13
    In Cell Searching values in table ProdCode

PrBOMcodeQty13

Double Pro

Sub componenent qty 13

PrBOMcode14^

Text 30 Pro

Sub componenent 14
    In Cell Searching values in table ProdCode

PrBOMcodeQty14

Double Pro

Sub componenent qty 14

PrBOMcode15^

Text 30 Pro

Sub componenent 15
    In Cell Searching values in table ProdCode

PrBOMcodeQty15

Double Pro

Sub componenent qty 15

PrBOMcode16^

Text 30 Pro

Sub componenent 16
    In Cell Searching values in table ProdCode

PrBOMcodeQty16

Double Pro

Sub componenent qty 16

PrBOMcode17^

Text 30 Pro

Sub componenent 17
    In Cell Searching values in table ProdCode

PrBOMcodeQty17

Double Pro

Sub componenent qty 17

PrBOMcode18^

Text 30 Pro

Sub componenent 18
    In Cell Searching values in table ProdCode

PrBOMcodeQty18

Double Pro

Sub componenent qty 18

PrBOMcode19^

Text 30 Pro

Sub componenent 19
    In Cell Searching values in table ProdCode

PrBOMcodeQty19

Double Pro

Sub componenent qty 19

PrBOMcode20^

Text 30 Pro

Sub componenent 20
    In Cell Searching values in table ProdCode

PrBOMcodeQty20

Double Pro

Sub componenent qty 20

PrBOMcode21^

Text 30 Pro

Sub componenent 21
    In Cell Searching values in table ProdCode

PrBOMcodeQty21

Double Pro

Sub componenent qty 21

PrBOMcode22^

Text 30 Pro

Sub componenent 22
    In Cell Searching values in table ProdCode

PrBOMcodeQty22

Double Pro

Sub componenent qty 22

PrBOMcode23^

Text 30 Pro

Sub componenent 23
    In Cell Searching values in table ProdCode

PrBOMcodeQty23

Double Pro

Sub componenent qty 23

PrBOMcode24^

Text 30 Pro

Sub componenent 24
    In Cell Searching values in table ProdCode

PrBOMcodeQty24

Double Pro

Sub componenent qty 24

PrBOMcode25^

Text 30 Pro

Sub componenent 25
    In Cell Searching values in table ProdCode

PrBOMcodeQty25

Double Pro

Sub componenent qty 25

PrBOMcode26^

Text 30 Pro

Sub componenent 26
    In Cell Searching values in table ProdCode

PrBOMcodeQty26

Double Pro

Sub componenent qty 26

PrBOMcode27^

Text 30 Pro

Sub componenent 27
    In Cell Searching values in table ProdCode

PrBOMcodeQty27

Double Pro

Sub componenent qty 27

PrBOMcode28^

Text 30 Pro

Sub componenent 28
    In Cell Searching values in table ProdCode

PrBOMcodeQty28

Double Pro

Sub componenent qty 28

PrBOMcode29^

Text 30 Pro

Sub componenent 29
    In Cell Searching values in table ProdCode

PrBOMcodeQty29

Double Pro

Sub componenent qty 29

PrBOMcode30^

Text 30 Pro

Sub componenent 30
    In Cell Searching values in table ProdCode

PrBOMcodeQty30

Double Pro

Sub componenent qty 30

PrBOMcode31^

Text 30 Pro

Sub componenent 31
    In Cell Searching values in table ProdCode

PrBOMcodeQty31

Double Pro

Sub componenent qty 31

PrBOMcode32^

Text 30 Pro

Sub componenent 32
    In Cell Searching values in table ProdCode

PrBOMcodeQty32

Double Pro

Sub componenent qty 32

PrBOMcode33^

Text 30 Pro

Sub componenent 33
    In Cell Searching values in table ProdCode

PrBOMcodeQty33

Double Pro

Sub componenent qty 33

PrBOMcode34^

Text 30 Pro

Sub componenent 34
    In Cell Searching values in table ProdCode

PrBOMcodeQty34

Double Pro

Sub componenent qty 34

PrBOMcode35^

Text 30 Pro

Sub componenent 35
    In Cell Searching values in table ProdCode

PrBOMcodeQty35

Double Pro

Sub componenent qty 35

PrBOMcode36^

Text 30 Pro

Sub componenent 36
    In Cell Searching values in table ProdCode

PrBOMcodeQty36

Double Pro

Sub componenent qty 36

PrBOMcode37^

Text 30 Pro

Sub componenent 37
    In Cell Searching values in table ProdCode

PrBOMcodeQty37

Double Pro

Sub componenent qty 37

PrBOMcode38^

Text 30 Pro

Sub componenent 38
    In Cell Searching values in table ProdCode

PrBOMcodeQty38

Double Pro

Sub componenent qty 38

PrBOMcode39^

Text 30 Pro

Sub componenent 39
    In Cell Searching values in table ProdCode

PrBOMcodeQty39

Double Pro

Sub componenent qty 39

PrBOMcode40^

Text 30 Pro

Sub componenent 40
    In Cell Searching values in table ProdCode

PrBOMcodeQty40

Double Pro

Sub componenent qty 40

PrBOMcode41^

Text 30 Pro

Sub componenent 41
    In Cell Searching values in table ProdCode

PrBOMcodeQty41

Double Pro

Sub componenent qty 41

PrBOMcode42^

Text 30 Pro

Sub componenent 42
    In Cell Searching values in table ProdCode

PrBOMcodeQty42

Double Pro

Sub componenent qty 42

PrBOMcode43^

Text 30 Pro

Sub componenent 43
    In Cell Searching values in table ProdCode

PrBOMcodeQty43

Double Pro

Sub componenent qty 43

PrBOMcode44^

Text 30 Pro

Sub componenent 44
    In Cell Searching values in table ProdCode

PrBOMcodeQty44

Double Pro

Sub componenent qty 44

PrBOMcode45^

Text 30 Pro

Sub componenent 45
    In Cell Searching values in table ProdCode

PrBOMcodeQty45

Double Pro

Sub componenent qty 45

PrBOMcode46^

Text 30 Pro

Sub componenent 46
    In Cell Searching values in table ProdCode

PrBOMcodeQty46

Double Pro

Sub componenent qty 46

PrBOMcode47^

Text 30 Pro

Sub componenent 47
    In Cell Searching values in table ProdCode

PrBOMcodeQty47

Double Pro

Sub componenent qty 47

PrBOMcode48^

Text 30 Pro

Sub componenent 48
    In Cell Searching values in table ProdCode

PrBOMcodeQty48

Double Pro

Sub componenent qty 48

PrBOMcode49^

Text 30 Pro

Sub componenent 49
    In Cell Searching values in table ProdCode

PrBOMcodeQty49

Double Pro

Sub componenent qty 49

PrBOMcode50^

Text 30 Pro

Sub componenent 50
    In Cell Searching values in table ProdCode

PrBOMcodeQty50

Double Pro

Sub componenent qty 50


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

Pro = PostTrans Pro version needed to use this field    Read = Read Only

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.


Related Example Sheets

You can easily access the example sheets by pressing Help button, on the PostTrans Toolbar to access these related examples, or downloading them from the links below.

To use the template, with Sage 50, 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.

 

Product Customer Price Structure

Sheet:'Customer Prices Structure'
Extract, Add and Amend Customer Prices
   Main page for Customer Prices Update
   Help article for Customer Prices Update

 

Product Customer Special Prices

Sheet:'Special Prices'
Extract, Add and Amend Customer Special Prices
   Main page for Customer Prices Update

Static Data - Product:

 

Product Records (all Fields)

Sheet:'Product Rec ALL'
Allow Extract/Amend/Import of Product records
   Main page for Product records Import

 

Stock Take Product Records

Sheet:'Stock Take'
Allow Extract Current IN Stock figure, then adjust at later date to give Stock Take functionality
   Main page for Stock Take Product records Import

 

Product Records

Sheet:'Product Rec'
Allow Extract/Amend/Import of Product records
   Main page for Product records Import
   Help article for Product records Import

 

Product Qty Breaks

Sheet:'Product Qty Breaks'
Allow Extract/Amend/Import of Product Qty Breaks Records
   Main page for Product records Import Discounts
   Help article for Product records Import Discounts

 

Product Budgets

Sheet:'Product Budget'
Allow Extract/Amend/Import of Product Budgets
   Main page for Product records Import Budgets
   Help article for Product records Import Budgets

 

Bill of Materials (Pro Version)

Sheet:'BOM'
Extract, Add and Amend Bill of Material
   Main page for Bill of Material Update
   Help article for Bill of Material Update

 

Product Category

Sheet:'Product Cat'
Allow Extract/Amend/Import of Product Category records
   Main page for Product Category records Import
   Help article for Product Category records Import