Creating Calculated Inventory Counts
After the count date and interval are recorded for an item, NetSuite uses them to calculate when a count is required. When a new count is due to be recorded, it shows in the list on the Create Inventory Count page.
To create calculated inventory counts:
-
Go to Transactions > Inventory > Create Inventory Count.
-
Select a location.
-
Enter or select a Count Start Date.
This filters the list to show only items that require a count on or after the date entered in this field.
-
Enter or select a Count End Date.
This filters the list to show only items that require a count on or before the date entered in this field.
-
Optionally choose a Item classification to filter the list.
-
Check the Count Bin Rows With Zero Quantity box to include in the list items with an on-hand count of zero.
-
Check the Sort Rows by Bin box to sort the item list by bin number instead of by item number. This can be useful to count all items in a specific area of a warehouse.
-
Select an account to post variances to. This is typically an expense account.
You can choose an account to show in this field by default. For details, read Setting Up Inventory Count
-
Check the box in the Select column next to each item you want to count.
Note:If you use bin management, an item does not appear in the list if it uses bins and has no prior transaction history.
-
Click Submit. When you click Submit, the inventory count transaction is recorded, but not started.
After an inventory count is on record, it has an Open status and is a non-posting transaction.
To edit an inventory count:
-
Go to Transactions > Inventory > Enter Inventory Count > List.
-
Click Edit next to the count you want to change.
-
Make necessary edits to the record.
-
Click Save.
Starting an Inventory Count
Read more about starting an inventory count in the topic Working with an Inventory Count.