What the Count Variance Report Shows

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

Running Full Count Variance Reports

Count Variance Report Options

Count Variance Report Overview