Data interface requirements > Stock by location

Stock by location

File name stock.csv
Importance Required
Description The current stock position by location
Criteria A record should be provided if any of the following criteria is true:
  • The item is stocked at the location, or
  • There is stock on hand, or
  • There is an outstanding transaction (purchase order, customer order or transfer), or
  • There is future forecast demand, or
  • The item belongs to an active supersession chain, or
  • The item belongs to an active bill of materials
 

Columns

Pos Name Type Importance Description
1 Item Code Char Required Product / SKU code
2 Location Char Required Warehouse / branch code
3 Date Added Date If Applicable Approximate date when the product was first available to sell at this location.
If it is unavailable as an existing field, it can be calculated by determining the first receipt date (for example).
YYYY/MM/DD FORMAT
4 Inventory Unit Cost Decimal Required The cost used by the company to value inventory.
Typically provide the average cost here. In cases where the average cost is zero, consider providing either a standard cost or last cost.
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"
5 Purchase Unit Cost Decimal Required The cost by which to value purchase order recommendations
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"
6 Selling Price Decimal Preferred Recommended selling price at this location
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"
7 Stock On Hand Integer Required Physical stock on hand
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"
8 Allocated Stock Integer Preferred Allocated / committed stock that is not available for sale
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"
9 Supply Type Char Preferred Indicates whether the item is sourced externally or internally at this location:
  • EX = External Vendor
  • IN = Internal Warehouse
10 Supply Code Char Preferred Depending on the Supply Type above:
  • For EX, provide the vendor code of the preferred external supplier
  • For IN, provide the location code of the supplying warehouse
11 Vendor Code Char Required Vendor code of the preferred external supplier (regardless of how the item is sourced)
12 Purchase Unit of Measure Char If Applicable Descriptive unit of measure used for purchasing.
PROVIDE THIS IF RECOMMENDED ORDERS SHOULD BE EXPORTED IN AN ALTERNATE UNIT OF MEASURE
13 Purchase Factor Decimal If Applicable The number of NETSTOCK units to each purchase unit.
PROVIDE THIS IF RECOMMENDED ORDERS SHOULD BE EXPORTED IN AN ALTERNATE UNIT OF MEASURE
14 Purchase Currency Code Char If Applicable The ISO currency code that the purchase unit cost is in.
15 Lead Time Integer Preferred Lead-time in calendar days (time from placing an order to receiving goods)
16 Stocking Indicator Char If Applicable The stocking indicator determines whether NETSTOCK generates min/max levels and purchase orders:
  • S = Stocked
    NETSTOCK will generate min/max levels that drive purchase order recommendations
  • N = Non-stocked
    NETSTOCK will not generate min/max levels; the item will only be reordered when customer orders exceed stock on hand plus on-order
  • O = Obsolete
    NETSTOCK will not generate min/max levels; the item will never be reordered
If not provided, NETSTOCK has the ability to determine which items should be stocked based on their age and sales history.
17 Minimum Stock Integer If Applicable The minimum quantity of stock to keep
ONLY PROVIDE TO OVERRIDE NETSTOCK’S SAFETY STOCK
18 Minimum Order Quantity Integer Preferred The minimum quantity that can be ordered
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"
19 Order Multiple Integer Preferred The multiples in which the item can be ordered
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"
20 Group 1 Char If Applicable Custom data for reporting (e.g. product group)
21 Group n Char If Applicable Custom data for reporting.As many custom fields as required can be added to the end of the file.
FOR EACH GROUP, PROVIDE CODE & DESCRIPTION PAIRS IN THE CUSTOM GROUPS FILE