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

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 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

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

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.

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

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

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

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

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

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

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