Menu

Stock Records

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

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:

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

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 8

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

SbAnal2

Text 60

BOM Anaysis Code 2

SbAnal3

Text 60

BOM Anaysis Code 3

SbAnal4

Text 60

BOM Anaysis Code 4

SbAnal5

Text 60

BOM Anaysis Code 5

SbAnal6

Text 60

BOM Anaysis Code 6

SbAnal7

Text 60

BOM Anaysis Code 7

SbAnal8

Text 60

BOM Anaysis Code 8

SbAnal9

Text 60

BOM Anaysis Code 9

SbAnal10

Text 60

BOM Anaysis Code 10

SbAnal11

Text 60

BOM Anaysis Code 11

SbAnal12

Text 60

BOM Anaysis Code 12

SbAnal13

Text 60

BOM Anaysis Code 13

SbAnal14

Text 60

BOM Anaysis Code 14

SbAnal15

Text 60

BOM Anaysis Code 15

SbAnal16

Text 60

BOM Anaysis Code 16

SbAnal17

Text 60

BOM Anaysis Code 17

SbAnal18

Text 60

BOM Anaysis Code 18

SbAnal19

Text 60

BOM Anaysis Code 19

SbAnal20

Text 60

BOM Anaysis Code 20

Selling Price:

StCostPrice

Double Head Read

Cost Price

StStdSellPrice

Double Head

Std Price
Price Band

StSellPrice1

Text 25 Head Pro

Sell Price 1, or X for Standard price
Price Band

StSellPrice2

Text 25 Head Pro

Sell Price 2, or X for Standard price
Price Band

StSellPrice3

Text 25 Head Pro

Sell Price 3, or X for Standard price
Price Band

StSellPrice4

Text 25 Head Pro

Sell Price 4, or X for Standard price
Price Band

StSellPrice5

Text 25 Head Chg Pro

Sell Price 5, or X for Standard price
Price Band

StSellPrice6

Text 25 Head Pro

Sell Price 6, or X for Standard price
Price Band

StSellPrice7

Text 25 Head Pro

Sell Price 7, or X for Standard price
Price Band

StSellPrice8

Text 25 Head Pro

Sell Price 8, or X for Standard price
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

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

StAnal2

Text 60 Pro

Stock Analysis Value 2

StAnal3

Text 60 Pro

Stock Analysis Value 3

StAnal4

Text 60 Pro

Stock Analysis Value 4

StAnal5

Text 60 Pro

Stock Analysis Value 5

StAnal6

Text 60 Pro

Stock Analysis Value 6

StAnal7

Text 60 Pro

Stock Analysis Value 7

StAnal8

Text 60 Pro

Stock Analysis Value 8

StAnal9

Text 60 Pro

Stock Analysis Value 9

StAnal10

Text 60 Pro

Stock Analysis Value 10

StAnal11

Text 60 Pro

Stock Analysis Value 11

StAnal12

Text 60 Pro

Stock Analysis Value 12

StAnal13

Text 60 Pro

Stock Analysis Value 13

StAnal14

Text 60 Pro

Stock Analysis Value 14

StAnal15

Text 60 Pro

Stock Analysis Value 15

StAnal16

Text 60 Pro

Stock Analysis Value 16

StAnal17

Text 60 Pro

Stock Analysis Value 17

StAnal18

Text 60 Pro

Stock Analysis Value 18

StAnal19

Text 60 Pro

Stock Analysis Value 19

StAnal20

Text 60 Pro

Stock Analysis Value 20

Supplier 1:

StSuppCode1^

Text 8 Head

Supplier 1, preferred Supplier.
Stock Supplier
    In Cell Searching values in table Supp

StSuppP1

Yes/NoTF Head

Alt Preferred Flag. Last YES read is taken as Preferred..
Stock Supplier

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:

StSuppCode2^

Text 8 Head

Supplier 2.
Stock Supplier
    In Cell Searching values in table Supp

StSuppP2

Yes/NoTF Head

Alt Preferred Flag. Last YES read is taken as Preferred..
Stock Supplier

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:

StSuppCode3^

Text 8 Head

Supplier 3.
Stock Supplier
    In Cell Searching values in table Supp

StSuppP3

Yes/NoTF Head

Alt Preferred Flag. Last YES read is taken as Preferred..
Stock Supplier

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:

StSuppCode4^

Text 8 Head

Supplier 4.
Stock Supplier
    In Cell Searching values in table Supp

StSuppP4

Yes/NoTF Head

Alt Preferred Flag. Last YES read is taken as Preferred..
Stock Supplier

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:

StSuppCode5^

Text 8 Head

Supplier 5.
    In Cell Searching values in table Supp

StSuppP5

Yes/NoTF Head

Alt Preferred Flag. Last YES read is taken as Preferred..

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

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.