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:

  1. From the Phys menu, select Count Variance Report to display the Count Variance Report screen.

  2. In the Count ID # field, enter the count control file ID of the inventory count on which to run the report.

Field

Description

Title

Title assigned to the count control file.

Br#

Branch in which the count occurred.

Last Control #

Last control number assigned to product in the count control file.

  1. In the Ctrl/Prc Line field, press F10 and select whether to run the report based on control numbers or price lines:

Option

Description

Ctrl#

Runs the report for a range of control numbers.

  • In the Start Control # field, enter the first control number in the range for which to run the report.

  • In the End Control # field, enter the last control number in the range for which to run the report.

Prc Line

Runs the report for an individual price line.

In the Line field, enter a price line for which to run the report. Use the Line hot key to enter multiple price lines for which to run the report.

  1. In the Sort field, press F10 and select the way in which to sort the report.

  1. In the Cost Basis field, press F10 and 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.

  1. 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.

  1. In the Sum/Det/Var/Product Var field, press F10 and select the level of detail to apply to the report.

  1. In the Nulls = 0 (Y/N) field, enter Y or N to indicate how null entries are being applied to the count.

If you set this field to N 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.

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

  1. In the Show Post Dated Orders field, press F10 and select the level of post dated order detail to include in the report.

  2. In the Min Variance field, select the minimum variance parameters to indicate which products to include in the report.

  1. Set options, if needed.

  2. 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.

See Also:

Count Variance Report Options

Running Full Count Variance Reports

What the Count Variance Report Shows

Count Variance Report Overview

Entering Inventory Counts