Inventory Count Creation NetSuite settings
Before you can create an inventory count, certain data must be specified in NetSuite inventory records. This data can be added manually, or through the use of other inventory management apps. Regardless of the method used, the following data records must be specified for every inventory item that you want to include in an inventory count. Additionally, the expense account that you want to associate with the count must exist in NetSuite.
Inventory Item settings
Specify the following NetSuite settings in every applicable inventory item record. To edit inventory item settings, go to Lists > Accounting > Items and either create a new item or edit an existing item.
The following settings are located under Classification on the item record in NetSuite.
Location
Ensure that the item has recorded quantity in the desired location.
Required
Class
Ensure that the class is accurate for the inventory item.
Optional
Department
Ensure that the department is accurate for the inventory item.
Optional
Stock Unit
The unit of measure for the item. Verify that this setting is configured to the correct unit.
Required
Cost
The cost per unit of the item. This value is based on the Purchase UOM for the item. The app uses this value to calculate "Variance Amount."
Optional
The following setting is located on the Purchasing /Inventory tab on the item record in NetSuite, under Locations. To view this setting, you may need to scroll to the far right of the list.
Classification
Ensure that the ABC classification for the item is accurate at each location.
Optional
The following settings are located on the Inventory Detail tab on the item record in NetSuite.
Number
Ensure that the item name or number is accurate and does not contain unsupported characters.
Important:Ensure that the item number does not contain the " or ~ symbol.
Required
Bin Number
Ensure that the item has accurate bin numbers, if the item is bin-controlled.
Optional
Serial/Lot Number
Ensure that the item has accurate lot numbers and serial numbers, if the item is lot-controlled or serial-controlled.
Optional
Expense account settings
Specify the following setting for the expense account that you want to associate with the inventory count. To configure an expense account, go to Setup > Accounting > Chart of Accounts > New.
Type
Set this value to "Expense."
Loading...
There was a problem loading this topic