Sage 200 Product Import/Update

..u.

Sage 200 : Extract/Amend/Import Stock Record Features

The Stock record in Sage 200 can be created/edited using PostTrans Stock template, denoted by tag Sage200stk in cell A1. A minimum of Stock code, Stock Group and Stock Description are required, to create a stock item, as default values are filled in automatically. When a record is updated, unmapped fields are left un touched.

Product Import in Sage 50

In addition, related Stock data can be edited/imported on each line, such as:

In order to create active stock Sage 200 requires a default stock location. This can be set in system setting under the “Stock” tab. Further Location related data can be accessed by using tags. Tags StCreateLoc,StCreateBin, StCreateMin, StCreateMax, StCreateReorder optionally allow the further location details to be defined at the point of stock record creation.

In addition to giving access to all stock fields on the Sage 200 Stock record, it also allows access to associated data, such as Suppliers, Price Bands, Alternative Stock codes, Location and Bin Records for easy creation or editing.

To read/write the additional data we add additional Tags, in the case of Alternative Stock items, we can access up to 5 records. Listed in columns:

Sage 200 Stock Prices

When extracted the additional records populate the columns. Any changes, or deletions are detected on import, and PostTrans makes the necessary changes to reflect the data in the PostTrans template.

Filter

The Stock data can be extracted, using the Extract button, and optionally filtered. see How to filter Sage 200 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

The video shows how to use PostTrans for Sage 200, to import, or amend stock records in Sage 200 from within Excel. First we simple copy a Sage 200 Stock item, and then using Excel Copy and Paste, we duplicate it, edit and import a new Sage 200 Stock item.

Then we move on and extract Sage 200 Stock items, edit the associated nominal codes using in-cell searching, and import the new Stock record into Sage 200.

Sage 200 Easily Import/Amend Stock Records from within Excel
	0:00	Video Introduction
	0:50	Extract Stock Records
	1:20	Copy and create new item with Locations and Bin
	3:00	Create new stock item
	3:50	Extract Stock items, edit and import changes

Download Stock Record Extract/Import Template

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

Stock Extract/Amend/Import Template

This PostTrans function allows the user to easily extract, amend, and import Sage 200 Stock records.

The cell A1 has a tag “Sage200stock” 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 Online Training for an explanation of this.

Product Required fields

Cell A1 must equal “Sage200stock”, Import/Extract the Product Lists

Restrictions

Tags for Stock Records, including Price bands (Module: Pro/Manufacturing)

The following PostTrans tags can be used to extract/import Stock Item Records into Sage 200 .

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 Field:
Sage200stk	Text	Returns `POSTED` if Trans line has been posted and will be ignored if `POSTED` (required). Also reports errors/warnings in data row
StCRC	Text Req	Contains CRC number to help PostTrans detect changes in current row.
StDelete	Text 1	Delete record if "X"
StSearch^	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 Stock
Stock Item:
StCode	Text 30 EOF Req	Code
StName	Text 60 Req	Description
Item Classification:
StProdGroup^	Text 20	Product Group In Cell Searching values in table StockGroup
StProdType^	Integer	Product Type In Cell Searching values:Product Type 0, Stock 1, Misc 2, Service & Labour 3, Undefined 4, SOP Item Despatched 5, SOP Item Not Despatched
Item Status:
StInactive^	Yes/NoTF	Current Status In Cell Searching values:Status 0, Active 1, InActive
StInActiveDate	Date Read	Inactive Date
Create Location:
StCreateListLOC1,Loc2	Text 2000 Head	A list of locations to add 'Unspecified' bins. E.g. FACTORY,TEST1,SHOWROOM,HOME,WAREHOUSE, How PostTrans Handles Locations/Bim
StCreateLoc^	Text 20 Head	When create Stock, create this location, else default Location in setup How PostTrans Handles Locations/Bim In Cell Searching values in table Loc
StCreateLocBin	Text 20 Head	When create Stock, create this bin, else 'Unspecified' How PostTrans Handles Locations/Bim
StCreateLocMin	Double Head	When create Stock, create this bin min level How PostTrans Handles Locations/Bim
StCreateLocMax	Double Head	When create Stock, create this bin max level How PostTrans Handles Locations/Bim
StCreateLocReorder	Double Head	When create Stock, create this bin reorder level How PostTrans Handles Locations/Bim
StCreateLocBinPri	Integer Head	When create Stock, create this bin priority How PostTrans Handles Locations/Bim
Create Location 2:
StCreateLoc2^	Text 20 Head	When create Stock, create this location, else default Location in setup How PostTrans Handles Locations/Bim In Cell Searching values in table Loc
StCreateLocBin2	Text 20 Head	When create Stock, create this bin, else `Unspecified` How PostTrans Handles Locations/Bim
StCreateLocMin2	Double Head	When create Stock, create this bin min level How PostTrans Handles Locations/Bim
StCreateLocMax2	Double Head	When create Stock, create this bin max level How PostTrans Handles Locations/Bim
StCreateLocReorder2	Double Head	When create Stock, create this bin reorder level How PostTrans Handles Locations/Bim
StCreateLocBinPri2	Integer Head	When create Stock, create this bin priority How PostTrans Handles Locations/Bim
Create Location 3:
StCreateLoc3^	Text 20 Head	When create Stock, create this location, else default Location in setup How PostTrans Handles Locations/Bim In Cell Searching values in table Loc
StCreateLocBin3	Text 20 Head	When create Stock, create this bin, else `Unspecified` How PostTrans Handles Locations/Bim
StCreateLocMin3	Double Head	When create Stock, create this bin min level How PostTrans Handles Locations/Bim
StCreateLocMax3	Double Head	When create Stock, create this bin max level How PostTrans Handles Locations/Bim
StCreateLocReorder3	Double Head	When create Stock, create this bin reorder level How PostTrans Handles Locations/Bim
StCreateLocBinPri3	Integer Head	When create Stock, create this bin priority How PostTrans Handles Locations/Bim
Create Location 4:
StCreateLoc4^	Text 20 Head	When create Stock, create this location, else default Location in setup How PostTrans Handles Locations/Bim In Cell Searching values in table Loc
StCreateLocBin4	Text 20 Head	When create Stock, create this bin, else `Unspecified` How PostTrans Handles Locations/Bim
StCreateLocMin4	Double Head	When create Stock, create this bin min level How PostTrans Handles Locations/Bim
StCreateLocMax4	Double Head	When create Stock, create this bin max level How PostTrans Handles Locations/Bim
StCreateLocReorder4	Double Head	When create Stock, create this bin reorder level How PostTrans Handles Locations/Bim
StCreateLocBinPri4	Integer Head	When create Stock, create this bin priority How PostTrans Handles Locations/Bim
Create Location 5:
StCreateLoc5^	Text 20 Head	When create Stock, create this location, else default Location in setup How PostTrans Handles Locations/Bim In Cell Searching values in table Loc
StCreateLocBin5	Text 20 Head	When create Stock, create this bin, else `Unspecified` How PostTrans Handles Locations/Bim
StCreateLocMin5	Double Head	When create Stock, create this bin min level How PostTrans Handles Locations/Bim
StCreateLocMax5	Double Head	When create Stock, create this bin max level How PostTrans Handles Locations/Bim
StCreateLocReorder5	Double Head	When create Stock, create this bin reorder level How PostTrans Handles Locations/Bim
StCreateLocBinPri5	Integer Head	When create Stock, create this bin priority How PostTrans Handles Locations/Bim
Trading Settings:
StStockUnit^	Text 20	Stock Unit In Cell Searching values in table UOM
StTaxRate^	Integer	Tax Code In Cell Searching values in table Tax
Manufacture Details:
StManufacturer	Text 40	Manufacturer
StPartNo	Text 40	Part Number
Label Options:
StLabelOption^	Integer	Label Printing Option Type In Cell Searching values:Label Printing 0, Not Required 1, Per Item 2, Per Batch
Sales Order:
StAllowSOP	Yes/NoTF	Allow Sales Order
Costing Method:
StCostMethod^	Integer Read	Costing Method. This is set on by Stock Group, hence is Read only In Cell Searching values:Costing Method 0, FIFO 1, Average 2, Standard 3, Actual
StAvCost	Double Read	Average Buying Price
StSdCost	Double	Standard Cost
Desc:
StDesc	Memo	Description
StDescOnSale	Yes/NoTF	Use Description on Order and Invoice Docs
BOM Details:
StBOMtype^	Integer	BOM type In Cell Searching values:BOM Type 0, Component 1, Built 2, Phantom 3, BuiltBought
StBought^	Yes/NoTF	BOM Built or Bought type to Bought In Cell Searching values in table Loc
Manufacturing - Warehouse:
StManDefWare^	Text 20	Default Manufacturing Warehouse for BOM. Wharehouse location is created if does not exist. To extract this data is quite complex, so if not needed remove. In Cell Searching values in table Loc
Analysis - Nominal Codes:
StStock^	Text 16	Stock Nom How Nom/CC/Dep are specified In Cell Searching values in table NOM
StRev^	Text 16	Revenue Nom How Nom/CC/Dep are specified In Cell Searching values in table NOM
StAccRecpt^	Text 16	Accrued Nom How Nom/CC/Dep are specified In Cell Searching values in table NOM
StIssue^	Text 16	Issues Nom How Nom/CC/Dep are specified In Cell Searching values in table NOM
Analysis - Nominal Cost Center:
StStockCC^	Text 3	Stock Nom CC. Only use for setting with formula How Nom/CC/Dep are specified In Cell Searching values in table CC
StRevCC^	Text 3	Revenue Nom CC. Only use for setting with formula How Nom/CC/Dep are specified In Cell Searching values in table CC
StAccRecptCC^	Text 3	Accrued Nom CC. Only use for setting with formula How Nom/CC/Dep are specified In Cell Searching values in table CC
StIssueCC^	Text 3	Issues Nom CC. Only use for setting with formula How Nom/CC/Dep are specified In Cell Searching values in table CC
Analysis - Nominal Department:
StStockDep^	Text 3	Stock Nom Dep. Only use for setting with formula How Nom/CC/Dep are specified In Cell Searching values in table DEP
StRevDep^	Text 3	Revenue Nom Dep. Only use for setting with formula How Nom/CC/Dep are specified In Cell Searching values in table DEP
StAccRecptDep^	Text 3	Accrued Nom Dep. Only use for setting with formula How Nom/CC/Dep are specified In Cell Searching values in table DEP
StIssueDep^	Text 3	Issues Nom Dep. Only use for setting with formula How Nom/CC/Dep are specified In Cell Searching values in table DEP
Comment:
StComPickList	Text 160	Picking List Comment
StComDesp	Text 160	Despatch Comment
Landed Costs:
StLandedCostType^	Integer	Landed Cost Type In Cell Searching values:Landed Cost Type 0, N/A 1, Percent Based 2, Value Based
StLandPerc	Double	Landed Percent
StLandValue	Double	Landed Value
Level:
StFreeStock	Double Read	Free Stock Level
Other:
StBarcode	Text 30	Bar code
StIsComplete	Yes/NoTF Read	Is Complete Item
Serial/Batch:
StTraceableType^	Integer	Traceable Type In Cell Searching values:Traceatrable Type 0, None 1, Serial 2, Serial Allow Dups 3, Batch 4, Batch Allow Dups
StOrdFilmMeth^	Integer	SOP Order Fulfilment Method In Cell Searching values:Order Fulfilment Method 0, From Stock 1, From Supplier Via Warehouse 2, Direct To Customer
StAllowOutDate	Yes/NoTF	Allow Out Of Date
StAutoGenPrefix	Text 20	Auto Generate Prefix
StNosCountSheet	Yes/NoTF	Include Nos On Count Sheets
StSaleSingBat	Yes/NoTF	Sale From Single Batch
StShelfLife	Integer	Shelf Life of Batch
StShelfLifeType^	Integer	Batch Shelf Life Type In Cell Searching values:Shelf Life Type 0, Day 1, Week 2, Month 3, Year
Spare:
StSpareBit1	Yes/NoTF	SpareBit1
StSpareBit2	Yes/NoTF	SpareBit2
StSpareBit3	Yes/NoTF	SpareBit3
StSpareDate1	Date	SpareDate1
StSpareDate2	Date	SpareDate2
StSpareDate3	Date	SpareDate3
StSpareNumber1	Double	SpareNumber1
StSpareNumber2	Double	SpareNumber2
StSpareNumber3	Double	SpareNumber3
StSpareText1	Text 100	SpareText1
StSpareText2	Text 100	SpareText2
StSpareText3	Text 100	SpareText3
Analysis - Legislative Info:
StComodCode	Text 10	Commodity Code
StCountryOfOrigin^	Text 2	Country Of Origin In Cell Searching values in table CountryCode
StWeight	Double	Weight
StSupNetMass	Yes/NoTF	Suppress Net Mass
StIsWEEEItem	Yes/NoTF	Is WEEE Item
StUseSuppUnit	Yes/NoTF	Uses Supplementary Unit
StSuppStockUnits	Double	Supplementary Stock Units
StUseRCVAT	Yes/NoTF	Use Reverse Charge VAT
StStkTakeEvery	Integer	Stock Take Every
BOM Rec Details:
SbChangeRef	Text 255	BOM Change Reference
SbQualStd	Text 255	BOM Quality Standard
BOM Version/Status:
SbVersion	Text 50 Read	BOM Revision
SbReason^	Text 60	BOM Reason In Cell Searching values in table ManBOMReason
SbIsOnHold	Yes/NoTF	BOM Is on hold
BOM Dates:
SbEffFrom	Date	BOM Effective From
SbEffTo	Date	BOM Effective To
BOM Analysis:
SbAnal1^	Text 60	BOM Anaysis Code 1 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok01
SbAnal2^	Text 60	BOM Anaysis Code 2 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok02
SbAnal3^	Text 60	BOM Anaysis Code 3 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok03
SbAnal4^	Text 60	BOM Anaysis Code 4 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok04
SbAnal5^	Text 60	BOM Anaysis Code 5 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok05
SbAnal6^	Text 60	BOM Anaysis Code 6 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok06
SbAnal7^	Text 60	BOM Anaysis Code 7 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok07
SbAnal8^	Text 60	BOM Anaysis Code 8 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok08
SbAnal9^	Text 60	BOM Anaysis Code 9 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok09
SbAnal10^	Text 60	BOM Anaysis Code 10 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok10
SbAnal11^	Text 60	BOM Anaysis Code 11 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok11
SbAnal12^	Text 60	BOM Anaysis Code 12 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok12
SbAnal13^	Text 60	BOM Anaysis Code 13 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok13
SbAnal14^	Text 60	BOM Anaysis Code 14 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok14
SbAnal15^	Text 60	BOM Anaysis Code 15 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok15
SbAnal16^	Text 60	BOM Anaysis Code 16 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok16
SbAnal17^	Text 60	BOM Anaysis Code 17 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok17
SbAnal18^	Text 60	BOM Anaysis Code 18 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok18
SbAnal19^	Text 60	BOM Anaysis Code 19 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok19
SbAnal20^	Text 60	BOM Anaysis Code 20 - `Setup` View >> Analaysis code menu option will list mapping numbers and values In Cell Searching values in table AnalStok20
Selling Price:
StCostPrice	Double Read	Cost Price
StStdSellPrice	Double Head	Standard Price Price Band
StSellPrice1	Text 25 Head Pro	Sell Price 1, or X for Standard price. Press `Extract` and set bands under Bands Tab Price Band
StSellPrice2	Text 25 Head Pro	Sell Price 2, or X for Standard price. Press `Extract` and set bands under Bands Tab Price Band
StSellPrice3	Text 25 Head Pro	Sell Price 3, or X for Standard price. Press `Extract` and set bands under Bands Tab Price Band
StSellPrice4	Text 25 Head Pro	Sell Price 4, or X for Standard price. Press `Extract` and set bands under Bands Tab Price Band
StSellPrice5	Text 25 Head Chg Pro	Sell Price 5, or X for Standard price. Press `Extract` and set bands under Bands Tab Price Band
StSellPrice6	Text 25 Head Pro	Sell Price 6, or X for Standard price. Press `Extract` and set bands under Bands Tab Price Band
StSellPrice7	Text 25 Head Pro	Sell Price 7, or X for Standard price. Press `Extract` and set bands under Bands Tab Price Band
StSellPrice8	Text 25 Head Pro	Sell Price 8, or X for Standard price. Press `Extract` and set bands under Bands Tab Price Band
StSellPrice9	Text 25 Head Pro	Sell Price 9, or X for Standard price Price Band
StSellPrice10	Text 25 Head Pro	Sell Price 10, or X for Standard price Price Band
StSellPrice11	Text 25 Head Pro	Sell Price 11, or X for Standard price. Set in row 3 Price Band
StSellPrice12	Text 25 Head Pro	Sell Price 12, or X for Standard price. Set in row 3 Price Band
StSellPrice13	Text 25 Head Pro	Sell Price 13, or X for Standard price. Set in row 3 Price Band
StSellPrice14	Text 25 Head Pro	Sell Price 14, or X for Standard price. Set in row 3 Price Band
StSellPrice15	Text 25 Head Chg Pro	Sell Price 15, or X for Standard price. Set in row 3 Price Band
StSellPrice16	Text 25 Head Pro	Sell Price 16, or X for Standard price. Set in row 3 Price Band
StSellPrice17	Text 25 Head Pro	Sell Price 17, or X for Standard price. Set in row 3 Price Band
StSellPrice18	Text 25 Head Pro	Sell Price 18, or X for Standard price. Set in row 3 Price Band
StSellPrice19	Text 25 Head Pro	Sell Price 19, or X for Standard price. Set in row 3 Price Band
StSellPrice20	Text 25 Head Pro	Sell Price 20, or X for Standard price. Set in row 3 Price Band
Alternatives:
StAltCode1^	Text 20 Head Pro	Alt Stock 1, preferred code.. Alternative Stock Item In Cell Searching values in table Stock
StAltP1	Yes/NoTF Head Pro	Alt Preferred Flag. Last YES read is taken as Preferred.. Alternative Stock Item
StAltCode2^	Text 20 Head Pro	Alt Stock 2. Alternative Stock Item In Cell Searching values in table Stock
StAltP2	Yes/NoTF Head Pro	Alt Preferred Flag. Last YES read is taken as Preferred.. Alternative Stock Item
StAltCode3^	Text 20 Head Pro	Alt Stock 3. Alternative Stock Item In Cell Searching values in table Stock
StAltP3	Yes/NoTF Head Pro	Alt Preferred Flag. Last YES read is taken as Preferred.. Alternative Stock Item
StAltCode4^	Text 20 Head Pro	Alt Stock 4. Alternative Stock Item In Cell Searching values in table Stock
StAltP4	Yes/NoTF Head Pro	Alt Preferred Flag. Last YES read is taken as Preferred.. Alternative Stock Item
StAltCode5^	Text 20 Head Pro	Alt Stock 5. Alternative Stock Item In Cell Searching values in table Stock
StAltP5	Yes/NoTF Head Pro	Alt Preferred Flag. Last YES read is taken as Preferred.. Alternative Stock Item
Stock Analysis:
StAnal1^	Text 60 Pro	Stock Analysis Value 1 In Cell Searching values in table AnalStok01
StAnal2^	Text 60 Pro	Stock Analysis Value 2 In Cell Searching values in table AnalStok02
StAnal3^	Text 60 Pro	Stock Analysis Value 3 In Cell Searching values in table AnalStok03
StAnal4^	Text 60 Pro	Stock Analysis Value 4 In Cell Searching values in table AnalStok04
StAnal5^	Text 60 Pro	Stock Analysis Value 5 In Cell Searching values in table AnalStok05
StAnal6^	Text 60 Pro	Stock Analysis Value 6 In Cell Searching values in table AnalStok06
StAnal7^	Text 60 Pro	Stock Analysis Value 7 In Cell Searching values in table AnalStok07
StAnal8^	Text 60 Pro	Stock Analysis Value 8 In Cell Searching values in table AnalStok08
StAnal9^	Text 60 Pro	Stock Analysis Value 9 In Cell Searching values in table AnalStok09
StAnal10^	Text 60 Pro	Stock Analysis Value 10 In Cell Searching values in table AnalStok10
StAnal11^	Text 60 Pro	Stock Analysis Value 11 In Cell Searching values in table AnalStok11
StAnal12^	Text 60 Pro	Stock Analysis Value 12 In Cell Searching values in table AnalStok12
StAnal13^	Text 60 Pro	Stock Analysis Value 13 In Cell Searching values in table AnalStok13
StAnal14^	Text 60 Pro	Stock Analysis Value 14 In Cell Searching values in table AnalStok14
StAnal15^	Text 60 Pro	Stock Analysis Value 15 In Cell Searching values in table AnalStok15
StAnal16^	Text 60 Pro	Stock Analysis Value 16 In Cell Searching values in table AnalStok16
StAnal17^	Text 60 Pro	Stock Analysis Value 17 In Cell Searching values in table AnalStok17
StAnal18^	Text 60 Pro	Stock Analysis Value 18 In Cell Searching values in table AnalStok18
StAnal19^	Text 60 Pro	Stock Analysis Value 19 In Cell Searching values in table AnalStok19
StAnal20^	Text 60 Pro	Stock Analysis Value 20 In Cell Searching values in table AnalStok20
Supplier 1:
StSuppP1	Yes/NoTF Head	Alt Preferred Flag. Last YES read is taken as Preferred.. Stock Supplier
StSuppCode1^	Text 8 Head	Supplier 1, preferred Supplier. Stock Supplier In Cell Searching values in table Supp
StSuppLeadTime1	Integer Head	Supplier Lead Time 1 Stock Supplier
StSuppLeadUnit1^	Integer Head	Supplier Lead Time Unit 1 Stock Supplier In Cell Searching values:Lead Time Unit 0, Days 1, Weeks 2, Months 3, Years
StSuppOrderQty1	Double Head	Supplier Usual Order Qty 1 Stock Supplier
StSuppOrderMinQty1	Double Head	Supplier Min Order Qty 1 Stock Supplier
StSuppListPrice1	Double Head	Supplier List Price 1 Stock Supplier
StSuppListPrBs1	Double Head	Supplier List Price Base 1 Stock Supplier
StSuppListPriceExp1	DateBlank Head	Supplier List Price Expires 1 Stock Supplier
StSuppPriceSource1^	Integer Head	Supplier Price Source 1 Stock Supplier In Cell Searching values:Price Source 0, Last Buying Price 1, List Price
StSuppCatPrice1	Double Head	Supplier Catalogue Price 1 Stock Supplier
StSuppCatPrDate1	DateBlank Head	Supplier Catalogue Price Date 1 Stock Supplier
StSuppLastOrdDate1	DateBlank Head Read	Supplier Last Order Price 1 Stock Supplier
StSuppCuntOrg1^	Text 8 Head	Supplier Country of Origin 1 Stock Supplier In Cell Searching values in table Country
StSuppStkCode1	Text 40 Head	Supplier Stock Code 1 Stock Supplier
Suppliers 2:
StSuppP2	Yes/NoTF Head	Alt Preferred Flag. Last YES read is taken as Preferred.. Stock Supplier
StSuppCode2^	Text 8 Head	Supplier 2. Stock Supplier In Cell Searching values in table Supp
StSuppLeadTime2	Integer Head	Supplier Lead Time 2 Stock Supplier
StSuppLeadUnit2^	Integer Head	Supplier Lead Time Unit 2 Stock Supplier In Cell Searching values:Lead Time Unit 0, Days 1, Weeks 2, Months 3, Years
StSuppOrderQty2	Double Head	Supplier Usual Order Qty 2 Stock Supplier
StSuppOrderMinQty2	Double Head	Supplier Min Order Qty 2 Stock Supplier
StSuppListPrice2	Double Head	Supplier List Price 2 Stock Supplier
StSuppListPrBs2	Double Head	Supplier List Price Base 2 Stock Supplier
StSuppListPriceExp2	DateBlank Head	Supplier List Price Expires 2 Stock Supplier
StSuppPriceSource2^	Integer Head	Supplier Price Source 2 Stock Supplier In Cell Searching values:Price Source 0, Last Buying Price 1, List Price
StSuppCatPrice2	Double Head	Supplier Catalogue Price 2 Stock Supplier
StSuppCatPrDate2	DateBlank Head	Supplier Catalogue Price Date 2 Stock Supplier
StSuppLastOrdDate2	DateBlank Head Read	Supplier Last Order Price 2 Stock Supplier
StSuppCuntOrg2^	Text 8 Head	Supplier Country of Origin 2 Stock Supplier In Cell Searching values in table Country
StSuppStkCode2	Text 40 Head	Supplier Stock Code 2 Stock Supplier
Suppliers 3:
StSuppP3	Yes/NoTF Head	Alt Preferred Flag. Last YES read is taken as Preferred.. Stock Supplier
StSuppCode3^	Text 8 Head	Supplier 3. Stock Supplier In Cell Searching values in table Supp
StSuppLeadTime3	Integer Head	Supplier Lead Time 3 Stock Supplier
StSuppLeadUnit3^	Integer Head	Supplier Lead Time Unit 3 Stock Supplier In Cell Searching values:Lead Time Unit 0, Days 1, Weeks 2, Months 3, Years
StSuppOrderQty3	Double Head	Supplier Usual Order Qty 3 Stock Supplier
StSuppOrderMinQty3	Double Head	Supplier Min Order Qty 3 Stock Supplier
StSuppListPrice3	Double Head	Supplier List Price 3 Stock Supplier
StSuppListPrBs3	Double Head	Supplier List Price Base 3 Stock Supplier
StSuppListPriceExp3	DateBlank Head	Supplier List Price Expires 3 Stock Supplier
StSuppPriceSource3^	Integer Head	Supplier Price Source 3 Stock Supplier In Cell Searching values:Price Source 0, Last Buying Price 1, List Price
StSuppCatPrice3	Double Head	Supplier Catalogue Price 3 Stock Supplier
StSuppCatPrDate3	DateBlank Head	Supplier Catalogue Price Date 3 Stock Supplier
StSuppLastOrdDate3	DateBlank Head Read	Supplier Last Order Price 3 Stock Supplier
StSuppCuntOrg3^	Text 8 Head	Supplier Country of Origin 3 Stock Supplier In Cell Searching values in table Country
StSuppStkCode3	Text 40 Head	Supplier Stock Code 3 Stock Supplier
Suppliers 4:
StSuppP4	Yes/NoTF Head	Alt Preferred Flag. Last YES read is taken as Preferred.. Stock Supplier
StSuppCode4^	Text 8 Head	Supplier 4. Stock Supplier In Cell Searching values in table Supp
StSuppLeadTime4	Integer Head	Supplier Lead Time 4 Stock Supplier
StSuppLeadUnit4^	Integer Head	Supplier Lead Time Unit 4 Stock Supplier In Cell Searching values:Lead Time Unit 0, Days 1, Weeks 2, Months 3, Years
StSuppOrderQty4	Double Head	Supplier Usual Order Qty 4 Stock Supplier
StSuppOrderMinQty4	Double Head	Supplier Min Order Qty 4 Stock Supplier
StSuppListPrice4	Double Head	Supplier List Price 4 Stock Supplier
StSuppListPrBs4	Double Head	Supplier List Price Base 4 Stock Supplier
StSuppListPriceExp4	DateBlank Head	Supplier List Price Expires 4 Stock Supplier
StSuppPriceSource4^	Integer Head	Supplier Price Source 4 Stock Supplier In Cell Searching values:Price Source 0, Last Buying Price 1, List Price
StSuppCatPrice4	Double Head	Supplier Catalogue Price 4 Stock Supplier
StSuppCatPrDate4	DateBlank Head	Supplier Catalogue Price Date 4 Stock Supplier
StSuppLastOrdDate4	DateBlank Head Read	Supplier Last Order Price 4 Stock Supplier
StSuppCuntOrg4^	Text 8 Head	Supplier Country of Origin 4 Stock Supplier In Cell Searching values in table Country
StSuppStkCode4	Text 40 Head	Supplier Stock Code 4 Stock Supplier
Suppliers 5:
StSuppP5	Yes/NoTF Head	Alt Preferred Flag. Last YES read is taken as Preferred..
StSuppCode5^	Text 8 Head	Supplier 5. In Cell Searching values in table Supp
StSuppLeadTime5	Integer Head	Supplier Lead Time 5
StSuppLeadUnit5^	Integer Head	Supplier Lead Time Unit 5 In Cell Searching values:Lead Time Unit 0, Days 1, Weeks 2, Months 3, Years
StSuppOrderQty5	Double Head	Supplier Usual Order Qty 5
StSuppOrderMinQty5	Double Head	Supplier Min Order Qty 5
StSuppListPrice5	Double Head	Supplier List Price 5
StSuppListPrBs5	Double Head	Supplier List Price Base 5
StSuppListPriceExp5	DateBlank Head	Supplier List Price Expires 5
StSuppPriceSource5^	Integer Head	Supplier Price Source 5 In Cell Searching values:Price Source 0, Last Buying Price 1, List Price
StSuppCatPrice5	Double Head	Supplier Catalogue Price 5
StSuppCatPrDate5	DateBlank Head	Supplier Catalogue Price Date 5
StSuppLastOrdDate5	DateBlank Head Read	Supplier Last Order Price 5
StSuppCuntOrg5^	Text 8 Head	Supplier Country of Origin 5 In Cell Searching values in table Country
StSuppStkCode5	Text 40 Head	Supplier Stock Code 5
Search Category 1:
StSearch1^	Text 20 Head Pro	Stock Analysis Category 1 Analysis Codes Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal1^	Text 40 Head Pro	Stock Analysis Value 1 Analysis Codes In Cell Searching values in table AnalValue
Search Category 2:
StSearch2^	Text 20 Head Pro	Stock Analysis Category 2 Analysis Codes Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal2^	Text 40 Head Pro	Stock Analysis Value 2 Analysis Codes In Cell Searching values in table AnalValue
Search Category 3:
StSearch3^	Text 20 Head Pro	Stock Analysis Category 3 Analysis Codes Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal3^	Text 40 Head Pro	Stock Analysis Value 3 Analysis Codes In Cell Searching values in table AnalValue
Search Category 4:
StSearch4^	Text 20 Head Pro	Stock Analysis Category 4 Analysis Codes Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal4^	Text 40 Head Pro	Stock Analysis Value 4 Analysis Codes In Cell Searching values in table AnalValue
Search Category 5:
StSearch5^	Text 20 Head Pro	Stock Analysis Category 5 Analysis Codes Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal5^	Text 40 Head Pro	Stock Analysis Value 5 Analysis Codes In Cell Searching values in table AnalValue
Search Category 6:
StSearch6^	Text 20 Head Pro	Stock Analysis Category 6 Analysis Codes Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal6^	Text 40 Head Pro	Stock Analysis Value 6 Analysis Codes In Cell Searching values in table AnalValue
Search Category 7:
StSearch7^	Text 20 Head Pro	Stock Analysis Category 7 Analysis Codes Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal7^	Text 40 Head Pro	Stock Analysis Value 7 Analysis Codes In Cell Searching values in table AnalValue
Search Category 8:
StSearch8^	Text 20 Head Pro	Stock Analysis Category 8 Analysis Codes Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal8^	Text 40 Head Pro	Stock Analysis Value 8 Analysis Codes In Cell Searching values in table AnalValue
Search Category 9:
StSearch9^	Text 20 Head Pro	Stock Analysis Category 9 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal9^	Text 40 Head Pro	Stock Analysis Value 9 In Cell Searching values in table AnalValue
Search Category 10:
StSearch10^	Text 20 Head Pro	Stock Analysis Category 10 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal10^	Text 40 Head Pro	Stock Analysis Value 10 In Cell Searching values in table AnalValue
Search Category 11:
StSearch11^	Text 20 Head Pro	Stock Analysis Category 11 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal11^	Text 40 Head Pro	Stock Analysis Value 11 In Cell Searching values in table AnalValue
Search Category 12:
StSearch12^	Text 20 Head Pro	Stock Analysis Category 12 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal12^	Text 40 Head Pro	Stock Analysis Value 12 In Cell Searching values in table AnalValue
Search Category 13:
StSearch13^	Text 20 Head Pro	Stock Analysis Category 13 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal13^	Text 40 Head Pro	Stock Analysis Value 13 In Cell Searching values in table AnalValue
Search Category 14:
StSearch14^	Text 20 Head Pro	Stock Analysis Category 14 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal14^	Text 40 Head Pro	Stock Analysis Value 14 In Cell Searching values in table AnalValue
Search Category 15:
StSearch15^	Text 20 Head Pro	Stock Analysis Category 15 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal15^	Text 40 Head Pro	Stock Analysis Value 15 In Cell Searching values in table AnalValue
Search Category 16:
StSearch16^	Text 20 Head Pro	Stock Analysis Category 16 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal16^	Text 40 Head Pro	Stock Analysis Value 16 In Cell Searching values in table AnalValue
Search Category 17:
StSearch17^	Text 20 Head Pro	Stock Analysis Category 17 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal17^	Text 40 Head Pro	Stock Analysis Value 17 In Cell Searching values in table AnalValue
Search Category 18:
StSearch18^	Text 20 Head Pro	Stock Analysis Category 18 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal18^	Text 40 Head Pro	Stock Analysis Value 18 In Cell Searching values in table AnalValue
Search Category 19:
StSearch19^	Text 20 Head Pro	Stock Analysis Category 19 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal19^	Text 40 Head Pro	Stock Analysis Value 19 In Cell Searching values in table AnalValue
Search Category 20:
StSearch20^	Text 20 Head Pro	Stock Analysis Category 20 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal20^	Text 40 Head Pro	Stock Analysis Value 20 In Cell Searching values in table AnalValue
Search Category 21:
StSearch21^	Text 20 Head Pro	Stock Analysis Category 21 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal21^	Text 40 Head Pro	Stock Analysis Value 21 In Cell Searching values in table AnalValue
Search Category 22:
StSearch22^	Text 20 Head Pro	Stock Analysis Category 22 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal22^	Text 40 Head Pro	Stock Analysis Value 22 In Cell Searching values in table AnalValue
Search Category 23:
StSearch23^	Text 20 Head Pro	Stock Analysis Category 23 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal23^	Text 40 Head Pro	Stock Analysis Value 23 In Cell Searching values in table AnalValue
Search Category 24:
StSearch24^	Text 20 Head Pro	Stock Analysis Category 24 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal24^	Text 40 Head Pro	Stock Analysis Value 24 In Cell Searching values in table AnalValue
Search Category 25:
StSearch25^	Text 20 Head Pro	Stock Analysis Category 25 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal25^	Text 40 Head Pro	Stock Analysis Value 25 In Cell Searching values in table AnalValue
Search Category 26:
StSearch26^	Text 20 Head Pro	Stock Analysis Category 26 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal26^	Text 40 Head Pro	Stock Analysis Value 26 In Cell Searching values in table AnalValue
Search Category 27:
StSearch27^	Text 20 Head Pro	Stock Analysis Category 27 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal27^	Text 40 Head Pro	Stock Analysis Value 27 In Cell Searching values in table AnalValue
Search Category 28:
StSearch28^	Text 20 Head Pro	Stock Analysis Category 28 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal28^	Text 40 Head Pro	Stock Analysis Value 28 In Cell Searching values in table AnalValue
Search Category 29:
StSearch29^	Text 20 Head Pro	Stock Analysis Category 29 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal29^	Text 40 Head Pro	Stock Analysis Value 29 In Cell Searching values in table AnalValue
Search Category 30:
StSearch30^	Text 20 Head Pro	Stock Analysis Category 30 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal30^	Text 40 Head Pro	Stock Analysis Value 30 In Cell Searching values in table AnalValue
Search Category 31:
StSearch31^	Text 20 Head Pro	Stock Analysis Category 31 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal31^	Text 40 Head Pro	Stock Analysis Value 31 In Cell Searching values in table AnalValue
Search Category 32:
StSearch32^	Text 20 Head Pro	Stock Analysis Category 32 Sage V2015 onwards In Cell Searching values in table AnalCategory
StSearVal32^	Text 40 Head Pro	Stock Analysis Value 32 In Cell Searching values in table AnalValue
Location 1:
StLoc1Min	Double Head	Location Min Level 1. Bold for Default Manufacturing. Press `Extract` and set location under 'Defaine Locations' Tab How PostTrans Handles Locations/Bim
StLoc1Max	Double Head	Location Max Level 1 How PostTrans Handles Locations/Bim
StLoc1Reorder	Double Head	Location Reorder 1 How PostTrans Handles Locations/Bim
StLoc1InStk	Double Head Read	Bin In Stock for Location 1 How PostTrans Handles Locations/Bim
Location 1 Bins:
StLoc1BinID	Text 100 Head	This is used to store ID data relating to the Bins within a location. It must be included for each location. How PostTrans Handles Locations/Bim
StLoc1Bin1	Text 20 Head	Bin 1 for Location 1. Bold set preferred bin. Name must be set to create location How PostTrans Handles Locations/Bim
StLoc1Bin1Pri	Text 1 Head	Bin 1 Priority for Location 1 How PostTrans Handles Locations/Bim
StLoc1Bin1InStk	Double Head	Bin 1 Stock Level for Location 1 How PostTrans Handles Locations/Bim
StLoc1Bin2	Text 20 Head Pro	Bin 2 for Location 1. Bold set preferred bin. How PostTrans Handles Locations/Bim
StLoc1Bin2Pri	Text 1 Head Pro	Bin 2 Priority for Location 1 How PostTrans Handles Locations/Bim
StLoc1Bin2InStk	Double Head Pro	Bin 2 Stock Level for Location 1 How PostTrans Handles Locations/Bim
StLoc1Bin3	Text 20 Head Pro	Bin 3 for Location 1. Bold set preferred bin. How PostTrans Handles Locations/Bim
StLoc1Bin3Pri	Text 1 Head Pro	Bin 3 Priority for Location 1 How PostTrans Handles Locations/Bim
StLoc1Bin3InStk	Double Head Pro	Bin 3 Stock Level for Location 1 How PostTrans Handles Locations/Bim
StLoc1Bin4	Text 20 Head Pro	Bin 4 for Location 1. Bold set preferred bin. How PostTrans Handles Locations/Bim
StLoc1Bin4Pri	Text 1 Head Pro	Bin 4 Priority for Location 1 How PostTrans Handles Locations/Bim
StLoc1Bin4InStk	Double Head Pro	Bin 4 Stock Level for Location 1 How PostTrans Handles Locations/Bim
StLoc1Bin5	Text 20 Head Pro	Bin 5 for Location 1. Bold set preferred bin. How PostTrans Handles Locations/Bim
StLoc1Bin5Pri	Text 1 Head Pro	Bin 5 Priority for Location 1 How PostTrans Handles Locations/Bim
StLoc1Bin5InStk	Double Head Pro	Bin 5 Stock Level for Location 1 How PostTrans Handles Locations/Bim
StLoc1Bin6	Text 20 Head Pro	Bin 6 for Location 1. Bold set preferred bin. How PostTrans Handles Locations/Bim
StLoc1Bin6Pri	Text 1 Head Pro	Bin 6 Priority for Location 1 How PostTrans Handles Locations/Bim
StLoc1Bin6InStk	Double Head Pro	Bin 6 Stock Level for Location 1 How PostTrans Handles Locations/Bim
StLoc1Bin7	Text 20 Head Pro	Bin 7 for Location 1. Bold set preferred bin. How PostTrans Handles Locations/Bim
StLoc1Bin7Pri	Text 1 Head Pro	Bin 7 Priority for Location 1 How PostTrans Handles Locations/Bim
StLoc1Bin7InStk	Double Head Pro	Bin 7 Stock Level for Location 1 How PostTrans Handles Locations/Bim
StLoc1Bin8	Text 20 Head Pro	Bin 8 for Location 1. Bold set preferred bin. How PostTrans Handles Locations/Bim
StLoc1Bin8Pri	Text 1 Head Pro	Bin 8 Priority for Location 1 How PostTrans Handles Locations/Bim
StLoc1Bin8InStk	Double Head Pro	Bin 8 Stock Level for Location 1 How PostTrans Handles Locations/Bim
StLoc1Bin9	Text 20 Head Pro	Bin 9 for Location 1. Bold set preferred bin. How PostTrans Handles Locations/Bim
StLoc1Bin9Pri	Text 1 Head Pro	Bin 9 Priority for Location 1 How PostTrans Handles Locations/Bim
StLoc1Bin9InStk	Double Head Pro	Bin 9 Stock Level for Location 1 How PostTrans Handles Locations/Bim
StLoc1Bin10	Text 20 Head Pro	Bin 10 for Location 1. Bold set preferred bin. How PostTrans Handles Locations/Bim
StLoc1Bin10Pri	Text 1 Head Pro	Bin 10 Priority for Location 1 How PostTrans Handles Locations/Bim
StLoc1Bin10InStk	Double Head Pro	Bin 10 Stock Level for Location 1 How PostTrans Handles Locations/Bim
Location 2:
StLoc2Min	Double Head Pro	Location Min Level 2. Bold for Default Manufacturing. Press `Extract` and set location under 'Defaine Locations' Tab How PostTrans Handles Locations/Bim
StLoc2Max	Double Head Pro	Location Max Level 2 How PostTrans Handles Locations/Bim
StLoc2Reorder	Double Head Pro	Location Reorder 2 How PostTrans Handles Locations/Bim
StLoc2InStk	Double Head Read Pro	Bin In Stock for Location 2 How PostTrans Handles Locations/Bim
Location 2 Bins:
StLoc2BinID	Text 100 Head Pro	This is used to store ID data relating to the Bins within a location. It must be included for each location. How PostTrans Handles Locations/Bim
StLoc2Bin1	Text 20 Head Pro	Bin 1 for Location 2. Bold set preferred bin How PostTrans Handles Locations/Bim
StLoc2Bin1Pri	Text 1 Head Pro	Bin 1 Priority for Location 2 How PostTrans Handles Locations/Bim
StLoc2Bin1InStk	Double Head Pro	Bin 1 Stock Level for Location 2 How PostTrans Handles Locations/Bim
StLoc2Bin2	Text 20 Head Pro	Bin 2 for Location 2. Bold set preferred bin How PostTrans Handles Locations/Bim
StLoc2Bin2Pri	Text 1 Head Pro	Bin 2 Priority for Location 2 How PostTrans Handles Locations/Bim
StLoc2Bin2InStk	Double Head Pro	Bin 2 Stock Level for Location 2 How PostTrans Handles Locations/Bim
StLoc2Bin3	Text 20 Head Pro	Bin 3 for Location 2. Bold set preferred bin How PostTrans Handles Locations/Bim
StLoc2Bin3Pri	Text 1 Head Pro	Bin 3 Priority for Location 2
StLoc2Bin3InStk	Double Head Pro	Bin 3 Stock Level for Location 2
StLoc2Bin4	Text 20 Head Pro	Bin 4 for Location 2. Bold set preferred bin
StLoc2Bin4Pri	Text 1 Head Pro	Bin 4 Priority for Location 2
StLoc2Bin4InStk	Double Head Pro	Bin 4 Stock Level for Location 2
StLoc2Bin5	Text 20 Head Pro	Bin 5 for Location 2. Bold set preferred bin
StLoc2Bin5Pri	Text 1 Head Pro	Bin 5 Priority for Location 2
StLoc2Bin5InStk	Double Head Pro	Bin 5 Stock Level for Location 2
StLoc2Bin6	Text 20 Head Pro	Bin 6 for Location 2. Bold set preferred bin
StLoc2Bin6Pri	Text 1 Head Pro	Bin 6 Priority for Location 2
StLoc2Bin6InStk	Double Head Pro	Bin 6 Stock Level for Location 2
StLoc2Bin7	Text 20 Head Pro	Bin 7 for Location 2. Bold set preferred bin
StLoc2Bin7Pri	Text 1 Head Pro	Bin 7 Priority for Location 2
StLoc2Bin7InStk	Double Head Pro	Bin 7 Stock Level for Location 2
StLoc2Bin8	Text 20 Head Pro	Bin 8 for Location 2. Bold set preferred bin
StLoc2Bin8Pri	Text 1 Head Pro	Bin 8 Priority for Location 2
StLoc2Bin8InStk	Double Head Pro	Bin 8 Stock Level for Location 2
StLoc2Bin9	Text 20 Head Pro	Bin 9 for Location 2. Bold set preferred bin
StLoc2Bin9Pri	Text 1 Head Pro	Bin 9 Priority for Location 2
StLoc2Bin9InStk	Double Head Pro	Bin 9 Stock Level for Location 2
StLoc2Bin10	Text 20 Head Pro	Bin 10 for Location 2. Bold set preferred bin
StLoc2Bin10Pri	Text 1 Head Pro	Bin 10 Priority for Location 2
StLoc2Bin10InStk	Double Head Pro	Bin 10 Stock Level for Location 2
Location 3:
StLoc3Min	Double Head Pro	Location Min Level 3. Bold for Default Manufacturing. Press `Extract` and set location under 'Defaine Locations' Tab How PostTrans Handles Locations/Bim
StLoc3Max	Double Head Pro	Location Max Level 3 How PostTrans Handles Locations/Bim
StLoc3Reorder	Double Head Pro	Location Reorder 3 How PostTrans Handles Locations/Bim
StLoc3InStk	Double Head Read Pro	Bin In Stock for Location 3 How PostTrans Handles Locations/Bim
Location 3 Bins:
StLoc3BinID	Text 100 Head Pro	This is used to store ID data relating to the Bins within a location. It must be included for each location. How PostTrans Handles Locations/Bim
StLoc3Bin1	Text 20 Head Pro	Bin 1 for Location 3. Bold set preferred bin How PostTrans Handles Locations/Bim
StLoc3Bin1Pri	Text 1 Head Pro	Bin 1 Priority for Location 3 How PostTrans Handles Locations/Bim
StLoc3Bin1InStk	Double Head Pro	Bin 1 Stock Level for Location 3 How PostTrans Handles Locations/Bim
StLoc3Bin2	Text 20 Head Pro	Bin 2 for Location 3. Bold set preferred bin How PostTrans Handles Locations/Bim
StLoc3Bin2Pri	Text 1 Head Pro	Bin 2 Priority for Location 3 How PostTrans Handles Locations/Bim
StLoc3Bin2InStk	Double Head Pro	Bin 2 Stock Level for Location 3 How PostTrans Handles Locations/Bim
StLoc3Bin3	Text 20 Head Pro	Bin 3 for Location 3. Bold set preferred bin
StLoc3Bin3Pri	Text 1 Head Pro	Bin 3 Priority for Location 3
StLoc3Bin3InStk	Double Head Pro	Bin 3 Stock Level for Location 3
StLoc3Bin4	Text 20 Head Pro	Bin 4 for Location 3. Bold set preferred bin
StLoc3Bin4Pri	Text 1 Head Pro	Bin 4 Priority for Location 3
StLoc3Bin4InStk	Double Head Pro	Bin 4 Stock Level for Location 3
StLoc3Bin5	Text 20 Head Pro	Bin 5 for Location 3. Bold set preferred bin
StLoc3Bin5Pri	Text 1 Head Pro	Bin 5 Priority for Location 3
StLoc3Bin5InStk	Double Head Pro	Bin 5 Stock Level for Location 3
StLoc3Bin6	Text 20 Head Pro	Bin 6 for Location 3. Bold set preferred bin
StLoc3Bin6Pri	Text 1 Head Pro	Bin 6 Priority for Location 3
StLoc3Bin6InStk	Double Head Pro	Bin 6 Stock Level for Location 3
StLoc3Bin7	Text 20 Head Pro	Bin 7 for Location 3. Bold set preferred bin
StLoc3Bin7Pri	Text 1 Head Pro	Bin 7 Priority for Location 3
StLoc3Bin7InStk	Double Head Pro	Bin 7 Stock Level for Location 3
StLoc3Bin8	Text 20 Head Pro	Bin 8 for Location 3. Bold set preferred bin
StLoc3Bin8Pri	Text 1 Head Pro	Bin 8 Priority for Location 3
StLoc3Bin8InStk	Double Head Pro	Bin 8 Stock Level for Location 3
StLoc3Bin9	Text 20 Head Pro	Bin 9 for Location 3. Bold set preferred bin
StLoc3Bin9Pri	Text 1 Head Pro	Bin 9 Priority for Location 3
StLoc3Bin9InStk	Double Head Pro	Bin 9 Stock Level for Location 3
StLoc3Bin10	Text 20 Head Pro	Bin 10 for Location 3. Bold set preferred bin
StLoc3Bin10Pri	Text 1 Head Pro	Bin 10 Priority for Location 3
StLoc3Bin10InStk	Double Head Pro	Bin 10 Stock Level for Location 3
Location 4:
StLoc4Min	Double Head Pro	Location Min Level 4. Bold for Default Manufacturing. Press `Extract` and set location under 'Defaine Locations' Tab
StLoc4Max	Double Head Pro	Location Max Level 4
StLoc4Reorder	Double Head Pro	Location Reorder 4
StLoc4InStk	Double Head Read Pro	Bin In Stock for Location 4
Location 4 Bins:
StLoc4BinID	Text 100 Head Pro	This is used to store ID data relating to the Bins within a location. It must be included for each location.
StLoc4Bin1	Text 20 Head Pro	Bin 1 for Location 4. Bold set preferred bin
StLoc4Bin1Pri	Text 1 Head Pro	Bin 1 Priority for Location 4
StLoc4Bin1InStk	Double Head Pro	Bin 1 Stock Level for Location 4
StLoc4Bin2	Text 20 Head Pro	Bin 2 for Location 4. Bold set preferred bin
StLoc4Bin2Pri	Text 1 Head Pro	Bin 2 Priority for Location 4
StLoc4Bin2InStk	Double Head Pro	Bin 2 Stock Level for Location 4
StLoc4Bin3	Text 20 Head Pro	Bin 3 for Location 4. Bold set preferred bin
StLoc4Bin3Pri	Text 1 Head Pro	Bin 3 Priority for Location 4
StLoc4Bin3InStk	Double Head Pro	Bin 3 Stock Level for Location 4
StLoc4Bin4	Text 20 Head Pro	Bin 4 for Location 4. Bold set preferred bin
StLoc4Bin4Pri	Text 1 Head Pro	Bin 4 Priority for Location 4
StLoc4Bin4InStk	Double Head Pro	Bin 4 Stock Level for Location 4
StLoc4Bin5	Text 20 Head Pro	Bin 5 for Location 4. Bold set preferred bin
StLoc4Bin5Pri	Text 1 Head Pro	Bin 5 Priority for Location 4
StLoc4Bin5InStk	Double Head Pro	Bin 5 Stock Level for Location 4
StLoc4Bin6	Text 20 Head Pro	Bin 6 for Location 4. Bold set preferred bin
StLoc4Bin6Pri	Text 1 Head Pro	Bin 6 Priority for Location 4
StLoc4Bin6InStk	Double Head Pro	Bin 6 Stock Level for Location 4
StLoc4Bin7	Text 20 Head Pro	Bin 7 for Location 4. Bold set preferred bin
StLoc4Bin7Pri	Text 1 Head Pro	Bin 7 Priority for Location 4
StLoc4Bin7InStk	Double Head Pro	Bin 7 Stock Level for Location 4
StLoc4Bin8	Text 20 Head Pro	Bin 8 for Location 4. Bold set preferred bin
StLoc4Bin8Pri	Text 1 Head Pro	Bin 8 Priority for Location 4
StLoc4Bin8InStk	Double Head Pro	Bin 8 Stock Level for Location 4
StLoc4Bin9	Text 20 Head Pro	Bin 9 for Location 4. Bold set preferred bin
StLoc4Bin9Pri	Text 1 Head Pro	Bin 9 Priority for Location 4
StLoc4Bin9InStk	Double Head Pro	Bin 9 Stock Level for Location 4
StLoc4Bin10	Text 20 Head Pro	Bin 10 for Location 4. Bold set preferred bin
StLoc4Bin10Pri	Text 1 Head Pro	Bin 10 Priority for Location 4
StLoc4Bin10InStk	Double Head Pro	Bin 10 Stock Level for Location 4
Location 5:
StLoc5Min	Double Head Pro	Location Min Level 5. Bold for Default Manufacturing
StLoc5Max	Double Head Pro	Location Max Level 5
StLoc5Reorder	Double Head Pro	Location Reorder 5
StLoc5InStk	Double Head Read Pro	Bin In Stock for Location 5
Location 5 Bins:
StLoc5BinID	Text 100 Head Pro	This is used to store ID data relating to the Bins within a location. It must be included for each location.
StLoc5Bin1	Text 20 Head Pro	Bin 1 for Location 5. Bold set preferred bin
StLoc5Bin1Pri	Text 1 Head Pro	Bin 1 Priority for Location 5
StLoc5Bin1InStk	Double Head Pro	Bin 1 Stock Level for Location 5
StLoc5Bin2	Text 20 Head Pro	Bin 2 for Location 5. Bold set preferred bin
StLoc5Bin2Pri	Text 1 Head Pro	Bin 2 Priority for Location 5
StLoc5Bin2InStk	Double Head Pro	Bin 2 Stock Level for Location 5
StLoc5Bin3	Text 20 Head Pro	Bin 3 for Location 5. Bold set preferred bin
StLoc5Bin3Pri	Text 1 Head Pro	Bin 3 Priority for Location 5
StLoc5Bin3InStk	Double Head Pro	Bin 3 Stock Level for Location 5
StLoc5Bin4	Text 20 Head Pro	Bin 4 for Location 5. Bold set preferred bin
StLoc5Bin4Pri	Text 1 Head Pro	Bin 4 Priority for Location 5
StLoc5Bin4InStk	Double Head Pro	Bin 4 Stock Level for Location 5
StLoc5Bin5	Text 20 Head Pro	Bin 5 for Location 5. Bold set preferred bin
StLoc5Bin5Pri	Text 1 Head Pro	Bin 5 Priority for Location 5
StLoc5Bin5InStk	Double Head Pro	Bin 5 Stock Level for Location 5
StLoc5Bin6	Text 20 Head Pro	Bin 6 for Location 5. Bold set preferred bin
StLoc5Bin6Pri	Text 1 Head Pro	Bin 6 Priority for Location 5
StLoc5Bin6InStk	Double Head Pro	Bin 6 Stock Level for Location 5
StLoc5Bin7	Text 20 Head Pro	Bin 7 for Location 5. Bold set preferred bin
StLoc5Bin7Pri	Text 1 Head Pro	Bin 7 Priority for Location 5
StLoc5Bin7InStk	Double Head Pro	Bin 7 Stock Level for Location 5
StLoc5Bin8	Text 20 Head Pro	Bin 8 for Location 5. Bold set preferred bin
StLoc5Bin8Pri	Text 1 Head Pro	Bin 8 Priority for Location 5
StLoc5Bin8InStk	Double Head Pro	Bin 8 Stock Level for Location 5
StLoc5Bin9	Text 20 Head Pro	Bin 9 for Location 5. Bold set preferred bin
StLoc5Bin9Pri	Text 1 Head Pro	Bin 9 Priority for Location 5
StLoc5Bin9InStk	Double Head Pro	Bin 9 Stock Level for Location 5
StLoc5Bin10	Text 20 Head Pro	Bin 10 for Location 5. Bold set preferred bin
StLoc5Bin10Pri	Text 1 Head Pro	Bin 10 Priority for Location 5
StLoc5Bin10InStk	Double Head Pro	Bin 10 Stock Level for Location 5
Location 6:
StLoc6Min	Double Head Pro	Location Min Level 6. Bold for Default Manufacturing
StLoc6Max	Double Head Pro	Location Max Level 6
StLoc6Reorder	Double Head Pro	Location Reorder 6
StLoc6InStk	Double Head Read Pro	Bin In Stock for Location 6
Location 6 Bins:
StLoc6BinID	Text 100 Head Pro	This is used to store ID data relating to the Bins within a location. It must be included for each location.
StLoc6Bin1	Text 20 Head Pro	Bin 1 for Location 6. Bold set preferred bin
StLoc6Bin1Pri	Text 1 Head Pro	Bin 1 Priority for Location 6
StLoc6Bin1InStk	Double Head Pro	Bin 1 Stock Level for Location 6
StLoc6Bin2	Text 20 Head Pro	Bin 2 for Location 6. Bold set preferred bin
StLoc6Bin2Pri	Text 1 Head Pro	Bin 2 Priority for Location 6
StLoc6Bin2InStk	Double Head Pro	Bin 2 Stock Level for Location 6
StLoc6Bin3	Text 20 Head Pro	Bin 3 for Location 6. Bold set preferred bin
StLoc6Bin3Pri	Text 1 Head Pro	Bin 3 Priority for Location 6
StLoc6Bin3InStk	Double Head Pro	Bin 3 Stock Level for Location 6
StLoc6Bin4	Text 20 Head Pro	Bin 4 for Location 6. Bold set preferred bin
StLoc6Bin4Pri	Text 1 Head Pro	Bin 4 Priority for Location 6
StLoc6Bin4InStk	Double Head Pro	Bin 4 Stock Level for Location 6
StLoc6Bin5	Text 20 Head Pro	Bin 5 for Location 6. Bold set preferred bin
StLoc6Bin5Pri	Text 1 Head Pro	Bin 5 Priority for Location 6
StLoc6Bin5InStk	Double Head Pro	Bin 5 Stock Level for Location 6
StLoc6Bin6	Text 20 Head Pro	Bin 6 for Location 6. Bold set preferred bin
StLoc6Bin6Pri	Text 1 Head Pro	Bin 6 Priority for Location 6
StLoc6Bin6InStk	Double Head Pro	Bin 6 Stock Level for Location 6
StLoc6Bin7	Text 20 Head Pro	Bin 7 for Location 6. Bold set preferred bin
StLoc6Bin7Pri	Text 1 Head Pro	Bin 7 Priority for Location 6
StLoc6Bin7InStk	Double Head Pro	Bin 7 Stock Level for Location 6
StLoc6Bin8	Text 20 Head Pro	Bin 8 for Location 6. Bold set preferred bin
StLoc6Bin8Pri	Text 1 Head Pro	Bin 8 Priority for Location 6
StLoc6Bin8InStk	Double Head Pro	Bin 8 Stock Level for Location 6
StLoc6Bin9	Text 20 Head Pro	Bin 9 for Location 6. Bold set preferred bin
StLoc6Bin9Pri	Text 1 Head Pro	Bin 9 Priority for Location 6
StLoc6Bin9InStk	Double Head Pro	Bin 9 Stock Level for Location 6
StLoc6Bin10	Text 20 Head Pro	Bin 10 for Location 6. Bold set preferred bin
StLoc6Bin10Pri	Text 1 Head Pro	Bin 10 Priority for Location 6
StLoc6Bin10InStk	Double Head Pro	Bin 10 Stock Level for Location 6
Location 7:
StLoc7Min	Double Head Pro	Location Min Level 7. Bold for Default Manufacturing
StLoc7Max	Double Head Pro	Location Max Level 7
StLoc7Reorder	Double Head Pro	Location Reorder 7
StLoc7InStk	Double Head Read Pro	Bin In Stock for Location 7
Location 7 Bins:
StLoc7BinID	Text 100 Head Pro	This is used to store ID data relating to the Bins within a location. It must be included for each location.
StLoc7Bin1	Text 20 Head Pro	Bin 1 for Location 7. Bold set preferred bin
StLoc7Bin1Pri	Text 1 Head Pro	Bin 1 Priority for Location 7
StLoc7Bin1InStk	Double Head Pro	Bin 1 Stock Level for Location 7
StLoc7Bin2	Text 20 Head Pro	Bin 2 for Location 7. Bold set preferred bin
StLoc7Bin2Pri	Text 1 Head Pro	Bin 2 Priority for Location 7
StLoc7Bin2InStk	Double Head Pro	Bin 2 Stock Level for Location 7
StLoc7Bin3	Text 20 Head Pro	Bin 3 for Location 7. Bold set preferred bin
StLoc7Bin3Pri	Text 1 Head Pro	Bin 3 Priority for Location 7
StLoc7Bin3InStk	Double Head Pro	Bin 3 Stock Level for Location 7
StLoc7Bin4	Text 20 Head Pro	Bin 4 for Location 7. Bold set preferred bin
StLoc7Bin4Pri	Text 1 Head Pro	Bin 4 Priority for Location 7
StLoc7Bin4InStk	Double Head Pro	Bin 4 Stock Level for Location 7
StLoc7Bin5	Text 20 Head Pro	Bin 5 for Location 7. Bold set preferred bin
StLoc7Bin5Pri	Text 1 Head Pro	Bin 5 Priority for Location 7
StLoc7Bin5InStk	Double Head Pro	Bin 5 Stock Level for Location 7
StLoc7Bin6	Text 20 Head Pro	Bin 6 for Location 7. Bold set preferred bin
StLoc7Bin6Pri	Text 1 Head Pro	Bin 6 Priority for Location 7
StLoc7Bin6InStk	Double Head Pro	Bin 6 Stock Level for Location 7
StLoc7Bin7	Text 20 Head Pro	Bin 7 for Location 7. Bold set preferred bin
StLoc7Bin7Pri	Text 1 Head Pro	Bin 7 Priority for Location 7
StLoc7Bin7InStk	Double Head Pro	Bin 7 Stock Level for Location 7
StLoc7Bin8	Text 20 Head Pro	Bin 8 for Location 7. Bold set preferred bin
StLoc7Bin8Pri	Text 1 Head Pro	Bin 8 Priority for Location 7
StLoc7Bin8InStk	Double Head Pro	Bin 8 Stock Level for Location 7
StLoc7Bin9	Text 20 Head Pro	Bin 9 for Location 7. Bold set preferred bin
StLoc7Bin9Pri	Text 1 Head Pro	Bin 9 Priority for Location 7
StLoc7Bin9InStk	Double Head Pro	Bin 9 Stock Level for Location 7
StLoc7Bin10	Text 20 Head Pro	Bin 10 for Location 7. Bold set preferred bin
StLoc7Bin10Pri	Text 1 Head Pro	Bin 10 Priority for Location 7
StLoc7Bin10InStk	Double Head Pro	Bin 10 Stock Level for Location 7
Location 8:
StLoc8Min	Double Head Pro	Location Min Level 8. Bold for Default Manufacturing
StLoc8Max	Double Head Pro	Location Max Level 8
StLoc8Reorder	Double Head Pro	Location Reorder 8
StLoc8InStk	Double Head Read Pro	Bin In Stock for Location 8
Location 8 Bins:
StLoc8BinID	Text 100 Head Pro	This is used to store ID data relating to the Bins within a location. It must be included for each location.
StLoc8Bin1	Text 20 Head Pro	Bin 1 for Location 8. Bold set preferred bin
StLoc8Bin1Pri	Text 1 Head Pro	Bin 1 Priority for Location 8
StLoc8Bin1InStk	Double Head Pro	Bin 1 Stock Level for Location 8
StLoc8Bin2	Text 20 Head Pro	Bin 2 for Location 8. Bold set preferred bin
StLoc8Bin2Pri	Text 1 Head Pro	Bin 2 Priority for Location 8
StLoc8Bin2InStk	Double Head Pro	Bin 2 Stock Level for Location 8
StLoc8Bin3	Text 20 Head Pro	Bin 3 for Location 8. Bold set preferred bin
StLoc8Bin3Pri	Text 1 Head Pro	Bin 3 Priority for Location 8
StLoc8Bin3InStk	Double Head Pro	Bin 3 Stock Level for Location 8
StLoc8Bin4	Text 20 Head Pro	Bin 4 for Location 8. Bold set preferred bin
StLoc8Bin4Pri	Text 1 Head Pro	Bin 4 Priority for Location 8
StLoc8Bin4InStk	Double Head Pro	Bin 4 Stock Level for Location 8
StLoc8Bin5	Text 20 Head Pro	Bin 5 for Location 8. Bold set preferred bin
StLoc8Bin5Pri	Text 1 Head Pro	Bin 5 Priority for Location 8
StLoc8Bin5InStk	Double Head Pro	Bin 5 Stock Level for Location 8
StLoc8Bin6	Text 20 Head Pro	Bin 6 for Location 8. Bold set preferred bin
StLoc8Bin6Pri	Text 1 Head Pro	Bin 6 Priority for Location 8
StLoc8Bin6InStk	Double Head Pro	Bin 6 Stock Level for Location 8
StLoc8Bin7	Text 20 Head Pro	Bin 7 for Location 8. Bold set preferred bin
StLoc8Bin7Pri	Text 1 Head Pro	Bin 7 Priority for Location 8
StLoc8Bin7InStk	Double Head Pro	Bin 7 Stock Level for Location 8
StLoc8Bin8	Text 20 Head Pro	Bin 8 for Location 8. Bold set preferred bin
StLoc8Bin8Pri	Text 1 Head Pro	Bin 8 Priority for Location 8
StLoc8Bin8InStk	Double Head Pro	Bin 8 Stock Level for Location 8
StLoc8Bin9	Text 20 Head Pro	Bin 9 for Location 8. Bold set preferred bin
StLoc8Bin9Pri	Text 1 Head Pro	Bin 9 Priority for Location 8
StLoc8Bin9InStk	Double Head Pro	Bin 9 Stock Level for Location 8
StLoc8Bin10	Text 20 Head Pro	Bin 10 for Location 8. Bold set preferred bin
StLoc8Bin10Pri	Text 1 Head Pro	Bin 10 Priority for Location 8
StLoc8Bin10InStk	Double Head Pro	Bin 10 Stock Level for Location 8
Location 9:
StLoc9Min	Double Head Pro	Location Min Level 9. Bold for Default Manufacturing
StLoc9Max	Double Head Pro	Location Max Level 9
StLoc9Reorder	Double Head Pro	Location Reorder 9
StLoc9InStk	Double Head Read Pro	Bin In Stock for Location 9
Location 9 Bins:
StLoc9BinID	Text 100 Head Pro	This is used to store ID data relating to the Bins within a location. It must be included for each location.
StLoc9Bin1	Text 20 Head Pro	Bin 1 for Location 9. Bold set preferred bin
StLoc9Bin1Pri	Text 1 Head Pro	Bin 1 Priority for Location 9
StLoc9Bin1InStk	Double Head Pro	Bin 1 Stock Level for Location 9
StLoc9Bin2	Text 20 Head Pro	Bin 2 for Location 9. Bold set preferred bin
StLoc9Bin2Pri	Text 1 Head Pro	Bin 2 Priority for Location 9
StLoc9Bin2InStk	Double Head Pro	Bin 2 Stock Level for Location 9
StLoc9Bin3	Text 20 Head Pro	Bin 3 for Location 9. Bold set preferred bin
StLoc9Bin3Pri	Text 1 Head Pro	Bin 3 Priority for Location 9
StLoc9Bin3InStk	Double Head Pro	Bin 3 Stock Level for Location 9
StLoc9Bin4	Text 20 Head Pro	Bin 4 for Location 9. Bold set preferred bin
StLoc9Bin4Pri	Text 1 Head Pro	Bin 4 Priority for Location 9
StLoc9Bin4InStk	Double Head Pro	Bin 4 Stock Level for Location 9
StLoc9Bin5	Text 20 Head Pro	Bin 5 for Location 9. Bold set preferred bin
StLoc9Bin5Pri	Text 1 Head Pro	Bin 5 Priority for Location 9
StLoc9Bin5InStk	Double Head Pro	Bin 5 Stock Level for Location 9
StLoc9Bin6	Text 20 Head Pro	Bin 6 for Location 9. Bold set preferred bin
StLoc9Bin6Pri	Text 1 Head Pro	Bin 6 Priority for Location 9
StLoc9Bin6InStk	Double Head Pro	Bin 6 Stock Level for Location 9
StLoc9Bin7	Text 20 Head Pro	Bin 7 for Location 9. Bold set preferred bin
StLoc9Bin7Pri	Text 1 Head Pro	Bin 7 Priority for Location 9
StLoc9Bin7InStk	Double Head Pro	Bin 7 Stock Level for Location 9
StLoc9Bin8	Text 20 Head Pro	Bin 8 for Location 9. Bold set preferred bin
StLoc9Bin8Pri	Text 1 Head Pro	Bin 8 Priority for Location 9
StLoc9Bin8InStk	Double Head Pro	Bin 8 Stock Level for Location 9
StLoc9Bin9	Text 20 Head Pro	Bin 9 for Location 9. Bold set preferred bin
StLoc9Bin9Pri	Text 1 Head Pro	Bin 9 Priority for Location 9
StLoc9Bin9InStk	Double Head Pro	Bin 9 Stock Level for Location 9
StLoc9Bin10	Text 20 Head Pro	Bin 10 for Location 9. Bold set preferred bin
StLoc9Bin10Pri	Text 1 Head Pro	Bin 10 Priority for Location 9
StLoc9Bin10InStk	Double Head Pro	Bin 10 Stock Level for Location 9
Location 10:
StLoc10Min	Double Head Pro	Location Min Level 10. Bold for Default Manufacturing
StLoc10Max	Double Head Pro	Location Max Level 10
StLoc10Reorder	Double Head Pro	Location Reorder 10
StLoc10InStk	Double Head Read Pro	Bin In Stock for Location 10
Location 10 Bins:
StLoc10BinID	Text 100 Head Pro	This is used to store ID data relating to the Bins within a location. It must be included for each location.
StLoc10Bin1	Text 20 Head Pro	Bin 1 for Location 10. Bold set preferred bin
StLoc10Bin1Pri	Text 1 Head Pro	Bin 1 Priority for Location 10
StLoc10Bin1InStk	Double Head Pro	Bin 1 Stock Level for Location 10
StLoc10Bin2	Text 20 Head Pro	Bin 2 for Location 10. Bold set preferred bin
StLoc10Bin2Pri	Text 1 Head Pro	Bin 2 Priority for Location 10
StLoc10Bin2InStk	Double Head Pro	Bin 2 Stock Level for Location 10
StLoc10Bin3	Text 20 Head Pro	Bin 3 for Location 10. Bold set preferred bin
StLoc10Bin3Pri	Text 1 Head Pro	Bin 3 Priority for Location 10
StLoc10Bin3InStk	Double Head Pro	Bin 3 Stock Level for Location 10
StLoc10Bin4	Text 20 Head Pro	Bin 4 for Location 10. Bold set preferred bin
StLoc10Bin4Pri	Text 1 Head Pro	Bin 4 Priority for Location 10
StLoc10Bin4InStk	Double Head Pro	Bin 4 Stock Level for Location 10
StLoc10Bin5	Text 20 Head Pro	Bin 5 for Location 10. Bold set preferred bin
StLoc10Bin5Pri	Text 1 Head Pro	Bin 5 Priority for Location 10
StLoc10Bin5InStk	Double Head Pro	Bin 5 Stock Level for Location 10
StLoc10Bin6	Text 20 Head Pro	Bin 6 for Location 10. Bold set preferred bin
StLoc10Bin6Pri	Text 1 Head Pro	Bin 6 Priority for Location 10
StLoc10Bin6InStk	Double Head Pro	Bin 6 Stock Level for Location 10
StLoc10Bin7	Text 20 Head Pro	Bin 7 for Location 10. Bold set preferred bin
StLoc10Bin7Pri	Text 1 Head Pro	Bin 7 Priority for Location 10
StLoc10Bin7InStk	Double Head Pro	Bin 7 Stock Level for Location 10
StLoc10Bin8	Text 20 Head Pro	Bin 8 for Location 10. Bold set preferred bin
StLoc10Bin8Pri	Text 1 Head Pro	Bin 8 Priority for Location 10
StLoc10Bin8InStk	Double Head Pro	Bin 8 Stock Level for Location 10
StLoc10Bin9	Text 20 Head Pro	Bin 9 for Location 10. Bold set preferred bin
StLoc10Bin9Pri	Text 1 Head Pro	Bin 9 Priority for Location 10
StLoc10Bin9InStk	Double Head Pro	Bin 9 Stock Level for Location 10
StLoc10Bin10	Text 20 Head Pro	Bin 10 for Location 10. Bold set preferred bin
StLoc10Bin10Pri	Text 1 Head Pro	Bin 10 Priority for Location 10
StLoc10Bin10InStk	Double Head Pro	Bin 10 Stock Level for Location 10
Stk ObjectStore Mappings:
StUser1	Text 30	10 user defined fields which can be mapped to Sage ObjectStore Builder customisations How to map Sage ObjectStore Builder customisations
StUser2	Text 30	User2
StUser3	Text 30	User3
StUser4	Text 30	User4
StUser5	Text 30	User5
StUser6	Text 30	User6
StUser7	Text 30	User7
StUser8	Text 30	User8
StUser9	Text 30	User9
StUser10	Text 30	User10

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

Head A header tag can be used in header section, before row 30, of the transaction template. Or in the rows data of data, below row 30, of the template like a traditional CSV importer.

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.