Running the Adjustment Variance Report

Use the Adjustment Variance Report to view a summary of cycle count or other adjustments made for a period of time. Adjustment quantities display with their variance percentages and dollar amounts. You can use this report for daily error rate calculation by branch, as it displays the absolute totals (without positive or negatives) of any adjustments made.

Note: On-hand quantities displaying on the Adjustment Variance Report do not reconcile with the Inventory History Ledger, as the report displays location-specific on-hand quantities and the ledger displays total on-hand from all product locations.

Note: Eclipse Support needs to activate an internal control record, ADJ.VAR.RPT, for your RF site to use this report. This hidden control record updates and stores RF cycle count records in a separate WORK.MISC file. RF sites not using this report and non-RF sites using this report do not utilize this data.

For a description of the report, see What the Report Shows at the end of the topic.

To run the Adjustment Variance Report:

From the Whse Mgt > Reports menu, select Adjustment Variance Report to display the Adjustment Variance Report screen.
In the Branch field, enter the branch or territory for which to run the report.
In the Start Date and End Date fields, enter the date range of the period to be included on the report.
In the Adj Type field, press F10 and select one of the following adjustment types for which to run the report:

Adjustment Type	Description
All	All cycle counts.
RF Counts	Items counted using RF, whether there was an adjustment or not.
Location Adjustments	RF cycle count adjustments based on location.
Cycle Counts	RF cycle count adjustments.
Return Goods	Returned good adjustments.
Product Merging	Merged product adjustments.

In the Price Line field, press F10 and select a price line for which to run the report.
In the Buy Line field, press F10 and select a buy line for which to run the report.
In the Min Variance field, select the minimum variance parameters to indicate which products to include in the report.

In the Summary/Detail field, press F10 and select one of the following levels of detail to display in the report.

Level	Description
Product Detail	Generates the report for each adjustment entry by adjustment number for a product ID at a given location.
Product Summary	Generates the report for each adjustment number by product ID.
Line Summary	Generates the report for each buy line / price line with one or more adjustment numbers.

In the Select field, press F10 and select one of the following to indicate whether to limit the report to products with quantity adjustments only:

Option	Description
Variance Only	Selects all products that have a quantity adjustment during the time period indicated in the Start Date and End Date fields. Products that have changed locations only do not display.
ALL	Selects all products even if the total quantity adjustment is zero (0). This total includes products that have changed locations.

In the Sort By field, press F10 and select how to sort the report:

Option

Sorting Method

Price Line

First by branch, then by price line, buy line, and product.

Select this option to print buy line, price line, and branch totals.

Location

By product location.

Select this option to print branch totals only.

Set options, if needed, and generate the report.

What the Report Shows

The Adjustment Variance Report shows the following information:

Column	Description
Adjust # *	Transaction ID of the adjustment, for example, A1234567.
Product Desc *	First 20 characters of the product description.
Br	Branch at which the product is stocked.
Prc Ln	Price line to which the product belongs.
Buy Ln	Buy line to which the product belongs.
Location **	Location of the product.
UM	Unit of measure of the product.
Adjust	Adjustment quantity.
On Hand	On-hand quantity.
Total	Total adjusted quantity (Adjust + On Hand).
Diff %	Percentage difference between the adjustment quantity and the on hand quantity. For example: If Adjust is 2 and On Hand is 0, the Diff % is 0.0%. If Adjust is 5 and On Hand is 3, the Diff % is 166.7%.
Adjust $	Total dollar variance for the adjustment (Adjust $ = Cost Basis * the adjustment quantity). Note: Set the cost basis on the Update Physical On Hand screen.
On Hand $	Total dollar value of the on hand quantity (On Hand $ = COGS * the on hand quantity). Note: The system uses the COGS global basis.
Total $	Sum of Adjust $ and On Hand $.
Product Id *	Eclipse Product ID for the item.

* This data appears in Product Detail and Product Summary mode only.

** This data appears in Product Detail mode only.