Running Partial Count Variance Reports

To identify discrepancies for the parts of an inventory count that have been completed and entered into the system, run partial Count Variance Reports. Running partial Count Variance Reports enables you to identify discrepancies as you complete your inventory count.

For example, you have counted a third of your inventory for a full inventory count, and you have entered the count results into the system. Instead of waiting until the full inventory count is completed to compare count results with inventory quantities in the system, run a partial Count Variance Report for that third of your inventory. Use the report results to identify discrepancies for that portion of the count.

After running and checking a partial Count Variance Report, re-count your inventory and re-enter the count results as necessary

Note: You must regenerate a partial Count Variance Report each time you change count results in the system.

For a description of the report, see What the Count Variance Report Shows.

To run a partial Count Variance Report:

From the Physical menu, select Count Variance Report to display the Count Variance Report window.

In the Count ID # field, enter the count control file ID of the inventory count on which to run the report. The system displays the following view-only information:

Field	Description
Title	Title assigned to the count control file.
Branch	Branch in which the count occurred.
Last Control #	Last control number assigned to product in the count control file.

In the Ctrl#/Prc Line field, select whether to run the report based on control numbers or price lines:

In the Sort By field, select the way in which to sort the report.

In the Cost Basis field, select the global cost basis to apply to your inventory and to use in making inventory adjustments in the general ledger.

Note: Use the same cost basis for all Count Variance Reports generated for a single count.

In the Price Date field, enter the date of the inventory count.

Note: The system uses this date to select the product price sheets in effect as of the count date so that the inventory is valued correctly.

In the Sum/Det/Var/Product Var field, select the level of detail to apply to the report. If you are running the report for recount purposes, select Recount Report to include a Recount line on the report.

In the Nulls = 0 field, select the check box to determine how null entries are being applied to the count:
Selected - Counts zero quantities for the inventory count.
Unselected - Does not count zero quantities for the inventory account.

If you leave this field deselected and sort by Descending Count, the products with no counts sort to the bottom of the report. By grouping the no counts at the bottom of the report, you can see all products that were not counted.

In the Tagged Locs (Incl/Excl/Only) field, select the location types to include in the report.

In the Show Post Dated Orders field, select the level of post dated order detail to include in the report.
In the Minimum Variance field, select the minimum variance parameters to indicate which products to include in the report.

Set options, if needed.
At the prompt asking whether you have picked all post dated orders, enter Y or N to indicate whether post dated orders have been picked.

The system generates the report.