Netstock Help Center

Data Interface Requirements - Stock by Location

Written by Judi Zietsman

Updated over 3 months ago

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 are true: • The item is stocked at the location • There is stock on hand • There is an outstanding transaction (PO, customer order, or transfer) • There is future forecast demand • The item belongs to an active supersession chain • 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	Approx. date when the product was first available at this location. If not available, can be calculated from first receipt date. Format: YYYY/MM/DD.
4	Inventory Unit Cost	Decimal	Required	Cost used to value inventory (typically average cost). If average cost is zero, use standard or last cost. Expressed in Netstock unit of measure.
5	Purchase Unit Cost	Decimal	Required	Cost used to value purchase order recommendations. Expressed in Netstock unit of measure.
6	Selling Price	Decimal	Preferred	Recommended selling price at this location. Expressed in Netstock unit of measure.
7	Stock On Hand	Integer	Required	Physical stock on hand (Netstock unit of measure).
8	Allocated Stock	Integer	Preferred	Allocated/committed stock not available for sale (Netstock unit of measure).
9	Supply Type	Char	Preferred	Indicates sourcing method: `IN` = Internal transfer, `EX` = External supplier/manufacturer.
10	Supply Code	Char	Preferred	If Supply Type = `EX`: vendor code of preferred supplier. If Supply Type = `IN`: supplying warehouse code.
11	Vendor Code	Char	Required	Vendor code of the preferred external supplier (always required, regardless of sourcing).
12	Purchase Unit of Measure	Char	If Applicable	Descriptive purchasing UOM (provide if orders should export in an alternate UOM).
13	Purchase Factor	Decimal	If Applicable	Conversion factor: number of Netstock units per purchase unit (provide if exporting in alternate UOM).
14	Purchase Currency Code	Char	If Applicable	ISO currency code of the purchase unit cost.
15	Lead Time	Integer	Preferred	Supplier lead-time in calendar days.
16	Stocking Indicator	Char	If Applicable	Determines replenishment treatment: `S` = Stocked (min/max levels maintained) `N` = Non-stocked (only firm demand ordered) `Z` = Zero Policy (make-to-order) `O` = Obsolete (not stocked or reordered). If omitted, Netstock determines stocking policy based on age and sales history.
17	Minimum Stock	Integer	If Applicable	Override for Netstock-calculated Safety Stock.
18	Minimum Order Quantity	Integer	Preferred	Minimum order quantity (Netstock unit of measure).
19	Order Multiple	Integer	Preferred	Order multiples (Netstock unit of measure).
20	Group 1	Char	If Applicable	Custom reporting field (e.g., product group).
21	Group n	Char	If Applicable	Additional custom reporting fields. Each must be paired with a code & description in group.csv.

Forget about these 👇 😞 😐 😃 Have your say here!

Related Articles

Data Interface Requirements - Sales History

Data Interface Requirements - Outstanding Purchase Orders

Data Interface Requirements - Outstanding Customer Orders

Data Interface Requirements - Outstanding Transfers

Data Interface Requirements - Completed Purchase Orders