Creating Calculated Inventory Counts
Published on
June 30, 2023 at 8:56:21 AM PDT June 30, 2023 at 8:56:21 AM PDTth, June 30, 2023 at 8:56:21 AM PDT
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 toTransactions > Inventory > Create Inventory Count.
- Select a location.
- Enter or select aCount 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 aCount 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 theCount Bin Rows With Zero Quantitybox to include in the list items with an on-hand count of zero.
- Check theSort Rows by Binbox 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, readSetting Up Inventory Count
- Check the box in theSelectcolumn next to each item you want to count. NoteIf you use bin management, an item does not appear in the list if it uses bins and has no prior transaction history.
- ClickSubmit. When you clickSubmit, 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.