Running Full Count Variance Reports

For full physical inventory counts, Eclipse Support requires that you run a full Count Variance Report before updating your on-hand quantities. Support requires this report to aid you in resolving any inventory-related problems that might occur at your site following the count. Running the Update Physical On Hand program deletes the data the system uses to create Count Variance Reports, and so it is imperative that you correctly run this report before updating your on-hands.

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

To run a full 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.

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

  3. 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 Detail as the level of detail option to apply to the report.

  2. In the Nulls = 0 (Y/N) field, enter Y to indicate that null entries equate to zero quantities for the inventory 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.

Note: You must enter Y in this field when running a full Count Variance Report.

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

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

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

  2. Set options, if needed.

  3. 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 Partial Count Variance Reports

What the Count Variance Report Shows

Count Variance Report Overview

Entering Inventory Counts