Follow

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.

  1. Item Number: Either internal ID or Item Name/Number. Most use Name/Number
  2. Item Desc: Display Name/Code
  3. On Hand Quantity: Sum of all location On Hand if multi-location
  4. Reorder Level Quantity: Reorder Point
  5. Lead Time: Lead Time
  6. Min Order Quantity: Please define if available
  7. Vendor Code: Vendor Name/Code
  8. Unit Of Measure: Units Type
  9. Class Code: Class
  10. Cost: Define Cost. Typically use Average Cost
  11. Inventory or Non Inv.: Please define if available
  12. Make, Buy: If assembly or kit, its a make otherwise a buy
  13. Case pack quantity: Please define if available
  14. Case cube: Please define if available
  15. Safety Stock: Safety Stock Level
  16. Unit Price: Not required
  17. Ship By Days: Related to lot control. Please define if available
  18. Expiration Days: Related to lot control. Please define if available
  19. Order Lead Time days: Please define if available
  20. Yield: Please define if available
  21. 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.

  1. Item/Product Code: See above item definition
  2. On Hand Quantity: Quantity on hand
  3. Location Code: Location
  4. Order Lead Time days: Please define if available
  5. Transfer Lead Time days: Please define if available
  6. Primary Source Location Code: Please define if available
  7. Inventory or Non Inv.: Please define if available
  8. 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.

  1. ID: Internal ID
  2. 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.

  1. ID: Internal ID
  2. 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.

  1. Customer Number: Internal ID, Customer ID may also be used. Alternate, use custom list.
  2. 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.

  1. Order Number: Order #
  2. Status: Status
  3. Order Date: Date
  4. Customer Code: Customer
  5. Item/Product Code: Item
  6. Order Quantity: Quantity
  7. Due Date: If available otherwise see shipping tab
  1. Due Date: ship date
  2. Date Shipped: Actual
  3. Quantity Shipped: See items tab Quantity
  4. Sales Price: Determine basis for calculating price
  5. Cost: From item
  6. Location: Location

Ship History for Sales Orders from Item Shipments

  1. Date Shipped: Date
  2. Quantity Shipped: Quantity
  3. Sales Order Reference to tie back to sales order

Classes

  1. Class Code: Internal ID
  2. Class Name: Name

Vendors

  1. Vendor Code: Internal ID
  2. Vendor Name: Name

Vendor Orders

  1. Order Number: PO#
  2. Status: Status
  3. Order Date: Date
  4. Vendor Code: Vendor
  5. Item/Product Code: Item
  6. Order Quantity: Quantity
  7. Scheduled Delivery Date: Expected Receipt Date (default to Receipt Date when received)
  8. Actual Delivered Quantity: Received
  9. Actual Delivery Date: Actual Ship/Receipt Date (not shown)
  10. Location Code: Location

BOM

  1. Parent Item/Product Code: Item Name/Number
  2. Child Item/Product Code: Item
  3. Qty in Parent: Quantity
  4. Location Code: Location

Shop Order

  1. Shop Order Number: Order #
  2. Status: Status
  3. Order Date: Date
  4. Item/Product Code: Item
  5. Order Quantity: Quantity
  6. Scheduled Completion Date: 'enddate' (label is 'End Date') not shown
  7. Actual Completed Quantity: 'quantityshiprecv' (label is 'Quantity Shipped/Received') not shown
  8. Actual Completion Date: 'actualshipdate' (label is 'Actual Ship/Receipt Date') not shown
  9. Location Code: Location

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk