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:
|
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
|
4. Inventory Unit Cost | Decimal | Required | The cost used by the company to value inventory
Express in terms of the "Netstock unit of measure." |
5. Purchase Unit Cost | Decimal | Required | The cost by which to value purchase order recommendations
|
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/
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 can 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 measur.e" |
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 |