The Count Variance Report shows the following information:
Note: The information generated in the report depends on the type of report run and the options applied to the report.
Field/Column |
Description |
Count ID # |
Count control file ID for the inventory count. |
Count Date |
Date on which the count occurred. |
Control #s |
If the report was run for specific control numbers, the selected control numbers. |
Price Line |
If the report was run for specific price lines, the selected price lines. |
Variance Greater Than |
Selected minimum variance parameters assigned to the report. |
Sort by |
Selected sort by option assigned to the report. |
Valued at |
Selected global cost basis applied to the inventory count. |
Prc Date |
Price date applied to the inventory count. |
Ctrl # |
Control number assigned to each product selected for the report. |
Product Description |
Each product selected for the report. |
Prc Line |
Price line to which the associated product is assigned. |
Location |
Location in which the associated product was counted. |
UM |
Unit of measure in which the associated product was counted. |
Count |
Amount of the product counted in the location. |
Onhand |
System's on-hand quantity for the product in the location prior to the count. |
Diff |
Difference between the system's on-hand quantity and the actual count for the product in the location. |
Diff% |
Percentage difference between the system's on-hand quantity and the actual count for the product in the location. |
Unit$ |
Product's unit of value in dollars. |
Count$ |
Actual counted quantity in dollars. |
Onhand$ |
System's on-hand quantity in dollars. |
Difference$ |
Dollar amount difference between the system's on-hand quantity and the actual count for the product in the location. |
Grand Totals |
Totals for each column of information. |
Gross Qty Difference |
Total percentage difference between the system's on-hand quantity and the actual count. |
Gross Dollar Difference |
Total dollar difference between the system's on-hand quantity and the actual count. |
See Also:
Running Partial Count Variance Reports