Calculate and commit physical inventory count results

This topic describes how to calculate discrepancies between the count quantity and the expected quantity in the store database, initiate a recount, and how to commit changes to the store database.

You must enter or import the count results and, if necessary, merge results to create a master inventory count file, before you can use the calculate function to evaluate the inventory count results.

1. If the physical inventory count file is not open, double-click it to open it.

2. Click Calculate.

3. Click OK to proceed with the calculation.

4. Evaluate any differences between the count quantity and the expected quantity:

• Items where the count quantity and expected quantity are equal are filtered out of the results list by default. Click Discrepancy to remove or reapply the filter.

• If there is a variance between the count quantity and the expected quantity, the items and count quantities are highlighted in red by default. Click Highlights to remove or reapply the highlights.

• Determining whether a variance is normal or abnormal depends on factors that are unique to your store. It may be helpful to compare your current physical inventory count results to historic count results to determine if the variation is within normal parameters or not.

Starting with version 3.9.19, Store Manager automatically reconciles any item movement (such as sales, returns, exchanges, transfers in, or transfers out) that occurs between when a physical inventory count starts and when the count is calculated. This reconciliation of item movement is performed automatically in the database. No further action or inputs are required.

1. If there is an unusually variance that you want to investigate:

   1. Click Recount to discard the calculation.

   2. Confirm the original count. Revise the count results as required.

   3. Look for other reasons for the variance, such as item mislabeling, items in storage locations that were not counted, items displayed in parts of the store that were not counted, or items moved to offline inventory.

2. If you are satisfied with the count results, click Commit.

1. Click Yes to confirm that you want to commit the results.

Committing updates the store database with the counted item quantities and closes the physical inventory count file.