PostTrans aids Sage 50 Stock Take. Requires Pro version. Simply Extract current IN Stock figures to template sheet. Edit figures, if different, on Laptop or Tablet computer out in the Warehouse.
Bring back to office. Open in Excel with PostTrans loaded. Use the Import button to processes any figures which are different to current Stock Level. Posting Stock Adjustments to alter stock levels.
Simply extract current IN Stock figures using PostTrans. Save Sheet. Amend In stock figures on Tablet or Laptop. Then process new figures using PostTrans, by pressing Import button, on the PostTrans Toolbar.
The template must have tag ‘Sage50prod’ in cell A1 to instruct PostTrans that we are interested in
Sage 50 Stock Take, 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 Stock Take Tags
Hovering over these tags, in row 1, will show a comment which explains the tags purpose, data type and any other useful details.
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 Setup. In-cell
searching.
Having extracted data, the user can now simply edit the Stock Take 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.
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.
Any values and associated codes will be invalid during import.
The cursor will be moved to highlight any problems in data.
This functionality will work with Sage Demo data without a license. A license is required to import into any other Sage Company.
Pricing
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 XML
|
Stock Code
|
PrType^
|
Text 1 XML
|
Item Type In Cell Searching values:Stock Type 0, Stock 1, NonStock 2, Service
|
PrDesc
|
Text 60 XML
|
Description (120 chars in 2023 onwards)
|
PrCategory^
|
Integer XML
|
Stock Category Number In Cell Searching values in table ProdCatCode
|
Product Details:
|
PrCountryOrigin^
|
Text 2 XML
|
Country code of origin. Irish data sets only. Sage V21 2015 onwards In Cell Searching values in table CountryCode
|
PrComCodeDesc
|
Text 30 XML
|
Com. Code Description Sage V21 2015 onwards
|
PrIntrastatComCode
|
Text 8 XML
|
Intrastat Commodity Code Sage V20 2014 onwards
|
PrIntrastatImportDutyCode
|
Text 8 XML
|
Intrastat Import Duty code Sage V20 2014 onwards
|
PrSuppUnitQty
|
Double XML
|
Supplementary Unit Quantity Sage V20 2014 onwards
|
PrWeight
|
Double XML
|
Unit of Weight
|
PrBarCode
|
Text 60 XML
|
BarCode
|
PrInactive
|
Yes/No- XML
|
Inactive Flag - yes/No Sage V21 2015 onwards
|
PrLocation
|
Text 16 XML
|
Location
|
Defaults:
|
PrSalesNom^
|
Text 8 XML
|
Nominal Code In Cell Searching values in table NomCode
|
PrTaxCode^
|
Integer XML
|
Tax Code (0 to 99) In Cell Searching values in table TaxCode
|
PrPurchaseNom^
|
Text 8 XML
|
Purchase Nominal Code In Cell Searching values in table NomCode
|
PrPartNo
|
Text 16 XML
|
Supplier`s Part Number
|
PrSuppAccount^
|
Text 8 XML
|
Supplier`s Account Reference In Cell Searching values in table SupplierCode
|
PrDept^
|
Integer XML
|
Department No In Cell Searching values in table DeptCode
|
Ordering:
|
PrLastPurPrice
|
Currency XML
|
Last Purchase Price
|
PrLastCostDisc
|
Currency XML
|
Last Cost Discounted Price
|
PrLastCost
|
Currency XML
|
Last Cost Price
|
PrLastOrdQty
|
Double Read
|
Last Order Quantity
|
PrLastOrdDate
|
Date Read
|
Last Purchase Date
|
Sales Price:
|
PrSalesPrice
|
Currency XML
|
Sale Price
|
PrUnitOfSale
|
Text 8 XML
|
Unit of Sale
|
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 XML
|
Web Description
|
PrWebLongDesc
|
Text 1023 XML
|
Web Long Description
|
PrWebPublish
|
Yes/No- XML
|
Web Publish Flag
|
PrWebSpecialOffer
|
Yes/No- XML
|
Web Special Offer
|
PrWebImage
|
Text 60 XML
|
Web Image Filename of the image which should be copied to the \ACCDATA\IMAGES sub folder of your data
|
Custom Fields:
|
PrCust1
|
Text 60 XML
|
Custom Field 1
|
PrCust2
|
Text 60 XML
|
Custom Field 2
|
PrCust3
|
Text 60 XML
|
Custom Field 3
|
Memo:
|
PrMemo
|
Memo Chg XML
|
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
|
All Text fields are trimmed (spaces before) by default. Add ' to the end of the tag name to stop this.