Creating Calculated Inventory Counts

1. Go to Transactions > Inventory > Create Inventory Count.

2.Select a location.

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

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

5.Optionally choose an Item classification to filter the list.

6.Check the Count Bin Rows with Zero Quantity box to include in the list items with an on-hand count of zero.

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

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

9.Check the box in the Select column next to each item you want to count.

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

Edit an inventory count:

1.Go to Transactions > Inventory > Enter Inventory Count > List.

2.Click Edit next to the count you want to change.

3.Make necessary edits to the record.

4.Click Save.

After an inventory count is recorded, you must complete these steps:

1.Start the count to begin the process of recording count data.

2.Edit the count record to enter count numbers for items.

3.Complete the count to record the final number counted for each item on the count.

4.Approve or reject the final count.

To start an inventory count:

1.Go to Transactions > Inventory > Enter Inventory Count > List.

2.Click View next to the count you want to start.

3.Click Start Count.

When you click Start on an Open status inventory count, NetSuite takes a snapshot of the on-hand count of the items to be counted by bin and serial number. This data is recorded on the count.

An inventory count with a status of Started can be reviewed and edited by the warehouse manager. Data in quantity fields can be edited, but items cannot be added to or deleted from the count.

To edit the count record:

1.Go to Transactions > Inventory > Enter Inventory Count > List.

2.Click Edit next to the count you want to work with.

3.Based on the physical count numbers taken in your warehouse, record the number actually counted in the Count Quantity field. Repeat this for each item you count.

4. After entering data on a started count, click Save to come back and complete the count later.

To complete an inventory count:

1. Go to Transactions > Inventory > Enter Inventory Count > List.

2. Click View next to the count you want to complete.

3. Click Complete Count.

Until an inventory count is completed, you cannot start a new inventory count for that item.

Two inventory adjustment transactions are created for the count:

• One positive inventory adjustment (more on hand)

• One negative adjustment (less on hand)

When you return to the item record of an item you have completed a count for, the Inventory subtab shows the following:

• Last Count Date – Date when the last count occurred

• Next Count Date – System calculated next date to enter an item count

• Count Interval – Preset count interval

After a count transition to the Complete/Pending Approval status, a supervisor can approve or reject it.

To approve or reject an inventory count

1. Go to Transactions > Inventory > Enter Inventory Count > List.

2. Click View next to the count you want to complete.

3. Do one of the following:

o Click Reject – The count status returns to Started and the warehouse manager must conduct another count.

o Click Approve – The count is final and the status becomes Approved.

Leave a comment

Your email address will not be published. Required fields are marked *