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 Physical menu, select Count Variance Report to display the Count Variance Report window.

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

3. In the Ctrl/#Prc Line field, 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.
   Price 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.

    

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

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

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

7. In the Sum/Det/Var/Product Var field, select Detail as the level of detail option 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.

8. In the Nulls = 0 field, select the check box to indicate that null entries equate to zero quantities for the inventory count.

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.

Note: You must select the check box for this field when running a full Count Variance Report.

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

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

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

12. Set options, if needed.

13. At the prompt asking whether you have picked all post dated orders, enter Yes or No 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