Skip to content

Physical Inventory Variance

Physical Inventory Variance Switchboard: Main->Inventory->Physical Inventory->Update Inventory and Main->Housekeeping->Inventory Setup->Physical Inventory->Update Inventory

Menu: Setup->Retail Physical Inventory->Exceptions Report

Action: RP_VARIANCE

This report shows the variances from the date selected. Each time a Physical Update is ran the system will store the current date to all inventory SCW items that are being counted. It also memorizes the QOH of each SCW prior to the physical. Once the physical is applied via the Update function the system can see if the prior QOH is the same or different from the resulting current QOH. A difference translates into a variance. This report will list those items where an variance exists.

The report will show the quantity prior to applying the physical and the quantity after applying the count. ​

Criteria

Physical run on...Select the date of the physical to use. The Date of the Physical is the method used by ProfitSystem to identify a specific physical. The date is set when the Update Inventory function is ran.