NetSuite Data Mapping
The following is suggested mapping to pull data from Netsuite. Please use this in conjunction with the DemandCaster data table article.
It has most of the essential data requirements. What is not provided here is and customer specific custom requirements (i.e. not standard Netsuite). Any custom or alternate fields should be shared with your DemandCaster engineer via screenshots.
Item Detail
The item detail is located in the Item list view.
- Item Number: Either internal ID or Item Name/Number. Most use Name/Number
- Item Desc: Display Name/Code
- On Hand Quantity: Sum of all location On Hand if multi-location
- Reorder Level Quantity: Reorder Point
- Lead Time: Lead Time
- Min Order Quantity: Please define if available
- Vendor Code: Vendor Name/Code
- Unit Of Measure: Units Type
- Class Code: Class
- Cost: Define Cost. Typically use Average Cost
- Inventory or Non Inv.: Please define if available
- Make, Buy: If assembly or kit, its a make otherwise a buy
- Case pack quantity: Please define if available
- Case cube: Please define if available
- Safety Stock: Safety Stock Level
- Unit Price: Not required
- Ship By Days: Related to lot control. Please define if available
- Expiration Days: Related to lot control. Please define if available
- Order Lead Time days: Please define if available
- Yield: Please define if available
- Unit of Measure Normalization: Please define if available
Item Location
Netsuite does not include source and destination logic and transfer times typically. If available provide.
- Item/Product Code: See above item definition
- On Hand Quantity: Quantity on hand
- Location Code: Location
- Order Lead Time days: Please define if available
- Transfer Lead Time days: Please define if available
- Primary Source Location Code: Please define if available
- Inventory or Non Inv.: Please define if available
- Lead Time days: See above item definition
Locations
Locations should be nettable inventory locations. Locations may also be used to exclude non-available inventory locations. Please note that by default, an inventory item is automatically allocated to every location regardless if the inventory item is active in the location.
- ID: Internal ID
- Name: Name
Customer List
Customers should be defined by how you wish to forecast. For most, the detailed ship to location of the customer provided below is to granular and some other definition is required. This is normally handled via a custom field or some other record association in the customer view.
- ID: Internal ID
- Name: Name
Customer Detail View
Per above, companies may also be a department or some other custom list associated with the sales order customer. This is common when running S&OP, the list needs to be associated with the customer to tie out to sales and invoice history.
- Customer Number: Internal ID, Customer ID may also be used. Alternate, use custom list.
- Company Name: If Company use name, if individual concatenate first and last name. Alternate, use custom list.
Customer Orders
This is based on closed sales orders. In certain situations, invoices are used. If so, please define.
- Order Number: Order #
- Status: Status
- Order Date: Date
- Customer Code: Customer
- Item/Product Code: Item
- Order Quantity: Quantity
- Due Date: If available otherwise see shipping tab
- Due Date: ship date
- Date Shipped: Actual
- Quantity Shipped: See items tab Quantity
- Sales Price: Determine basis for calculating price
- Cost: From item
- Location: Location
Ship History for Sales Orders from Item Shipments
- Date Shipped: Date
- Quantity Shipped: Quantity
- Sales Order Reference to tie back to sales order
Vendor Orders
- Order Number: PO#
- Status: Status
- Order Date: Date
- Vendor Code: Vendor
- Item/Product Code: Item
- Order Quantity: Quantity
- Scheduled Delivery Date: Expected Receipt Date (default to Receipt Date when received)
- Actual Delivered Quantity: Received
- Actual Delivery Date: Actual Ship/Receipt Date (not shown)
- Location Code: Location
BOM
- Parent Item/Product Code: Item Name/Number
- Child Item/Product Code: Item
- Qty in Parent: Quantity
- Location Code: Location
Shop Order
- Shop Order Number: Order #
- Status: Status
- Order Date: Date
- Item/Product Code: Item
- Order Quantity: Quantity
- Scheduled Completion Date: 'enddate' (label is 'End Date') not shown
- Actual Completed Quantity: 'quantityshiprecv' (label is 'Quantity Shipped/Received') not shown
- Actual Completion Date: 'actualshipdate' (label is 'Actual Ship/Receipt Date') not shown
- Location Code: Location
0 Comments
Add your comment