Running the Inventory Adjustment Register Report

Use the Inventory Adjustment Register to run a report on adjustments made in Inventory Adjustment Entry.

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

To run the Inventory Adjustment Register Report:

From the Warehouse Management > Reports menu, select Inventory Adjustment Register to display the Inventory Adjustment Register window.
In the Start Date and End Date fields, enter the dates for the period to include in the report.

For example, to view all inventory adjustments for December 2003, enter 12/01/03 in the Start Date field and 12/31/03 in the End Date field.

In the Branch field, enter or select the branch or territory for which you want to run the report. Enter All to include all branches and territories in the report.
In the Product field, enter or select the product for which you want to run the report.

Leave this field blank to run the report for adjustments made to all products at the indicated branch or territory.

In the Comment field, select a header comment for which to run the report. The comment must be entered exactly as it was entered for the adjustment register, or the system will not find a match. Leave this field blank to run the report for all header comments in the indicated branch or territory.

If the Validate Inventory Adjustment Header Commentscontrol maintenance record is set to No, you can enter your own comment to include in the report, such as "Adjustment After Cycle Count." The report includes the inventory adjustment registers that include this header comment.

In the Line Type field, select either Price or Buy to indicate whether to run the report for a price or buy line.

If you select Price for the type, the next field defaults to Price Line. Enter a price line in this field or select Price Lines from the Lines menu to select multiple price lines for which to run the report. Leave this field blank to run the report for all price lines at the indicated branch or territory.
If you select Buy for the type, the next field defaults to Buy Line. Enter a buy line in this field or select Buy Lines from the Lines menu to select multiple buy lines for which to run the report. Leave this field blank to run the report for all buy lines at the indicated branch or territory.

In the Adjustment Type field, select the adjustment type for which to run the report or type All to include all the adjustment types in the report.
In the Sort By field, select the sorting method for the report: Creation Date, Location, Price Line, Buy Line, or Adjuster Name.

In the Minimum $ Adjustment field, enter the minimum monetary adjustment amount to include in the report. Leave this field blank to run the report for all monetary adjustment amounts at the indicated branch or territory.

The system excludes any adjustments with a monetary value below what you enter in this field.

In the Detail/Summary field, indicate if you want to create a summary or detail report. See What the Report Shows below for the columns that display in each mode.
Set options, if needed, and generate the report.

What the Report Shows

The Inventory Adjustment Register Report shows the following information:

Field/Column	Description
Branches	Branches for which the report was run.
For x Types By x	Adjustment type for which the report was run, and sort by method applied to the report. For example, For All Types By Creation Date.
Adj#	Adjustment number.
Header Comment	Header comment for the adjustment.
Writer **	Adjustment writer.
Dollars **	Dollar amount associated with the cost of the adjusted product.
Units **	Units affected by the adjustment.
Qty/UM*	The amount of product adjusted by unit of measure.
Part# *	Part number of adjusted product.
Product Description *	Product description of adjusted product.
RegCost *	Average cost of the adjustment, if set.
NetCost/UM *	Net cost by unit of measure for the adjusted product.
ExtCost *	Extended cost for the adjusted product.
Rvw Location *	Location in which the adjusted product exists.
Br / Branch Name	Branch in which adjustment was made.
AdjDate	Adjustment date.
Subtotals *	Total weight, total load, and writer for adjustment.
Grand Totals	Total weight and total load for all reported on adjustments.

* This data displays in detail mode only.

** This data displays in summary mode only.