Creating Calculated Inventory Counts
Create inventory counts based on calculations performed by NetSuite WMS to determine items due for an inventory count. These calculations depend on values in the inventory count fields that you set on an item record. For more information about these fields, see Creating Items for NetSuite WMS.
To create a calculated inventory count:
-
Using the Warehouse role, go to Inventory > Cycle Counting > Create Cycle Count.
-
On the Create Inventory Count page, select values in the following fields:
-
Subsidiary - Select the subsidiary to which the warehouse location belongs.
-
Location - Select the warehouse location to which the item belongs.
The item sublist displays valid items due for an inventory count from the warehouse location. Items associated with open inventory counts do not appear in the list.
-
Account - Select the account to which you want to post variances, typically, an expense account.
By default, the account you set in the Default Inventory Count Account field on the Accounting Preferences page appears in this field. See Setting Up Inventory Count.
-
-
(Optional) In one or more of the following fields, enter or select your criteria to search for items you want to include in the count:
-
Count Start Date - Enter or select the start date of the count for an item.
This filter shows only items that require a count on or after the start date.
-
Count End Date - Enter or select the end date of the count for an item.
This filter shows only items that require a count on or before the end date.
-
Classification - Select the classification for an item.
The item sublist automatically adds or removes items based on your criteria.
-
-
(Optional) If you use bins for the warehouse location, check the box for the setting you want to apply to your inventory count:
-
Count Bin Rows With Zero Quantity - Includes items with an on-hand count of zero.
-
Sort Rows by Bin - Sorts items by bin number, instead of the default sorting by item name or number. Apply this setting to count all items in a specific area of a warehouse.
-
-
In the item sublist, in the Select column, check the box next to each item you want to count.
-
Click Submit.
NetSuite WMS sets the new inventory count to Open status. For warehouse locations that use bins, the Bin column appears next to the Item column on the Item subtab. It displays bins that contain the items you want to count.
To initiate the inventory count, see Starting Inventory Counts.