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:

  1. From the Whse Mgt > Reports menu, select Inventory Adjustment Register to display the Inventory Adjustment Register screen.

  2. In the Start Date field, enter the first date of the period to include in the report.

  3. In the End Date field, enter the last date of the period to include in the report.

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

  1. In the Br/Tr/All field, enter the branch or territory for which you want to run the report. Enter All to run the report for all branches and territories.

  2. In the Product field, enter 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.

  1. In the Comment field, press F10 and select a header comment for which to run the report.

If the Validate Inventory Adjustment Header Comments control maintenance record is set to No, 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.

Leave this field blank to run the report for all header comments in the indicated branch or territory.

Note: You must enter the header comment exactly as it was entered for the adjustment register, or the system will not find a match.

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

  1. In the Adj Type field, press F10 and select the adjustment type for which to run the report.

Type All to include all the adjustment types in the report.

  1. In the Sort By field, press F10 and select the sorting method for the report.

  2. In the Min $ Adj field, enter the minimum monetary adjustment amount to include in the report.

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

Leave this field blank to run the report for all monetary adjustment amounts at the indicated branch or territory.

  1. In the Detail/Summary field, press F10 and indicate if you want to create a summary or detail report.

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

See Also:

Inventory Adjustment Entry Overview

Making Inventory Adjustments