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 from a supplier, manufacturer or internal warehouse: “IN” = Internal (use if the item is transferred to this location) “EX” = External (use for purchasing or manufacturing)
10. Supply Code	Char	Preferred	Depending on the Supply Type above: For EX, provide the vendor code of the preferred supplier / manufacturer 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 which demand is included in the replenishment calculation: S = Stocked The item should be held in stock and replenished to calculated min/max levels N = Non-stocked The item should not be held in stock but orders should still be placed to cover any shortfall in firm demand within the supplier lead time Z = Zero Policy Similar to non-stocked but used for make-to-order items where the sales forecast needs to pass through to raw materials to ensure enough raw material stock is available O = Obsolete The item should not be held in stock or 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