Master Records > Inventory > Inventory Reports > Cost Adjustment Requirement Report

The Cost Adjustment Requirement Report function generates a report that provides information about inventory items whose costs are out-of-balance due to rounding off differences. This report is useful when evaluating any cost discrepancies in your inventory items. Generate this report as a guide in posting inventory adjustment using the Inventory Adjustment function.

In this report, you will see the following costs related to the different inventory items:

oTotal Cost

This column reflects the sum of the transactions for the inventory item as of the current date.

oCalculated Cost

This column reflects the cost of the inventory item's on-hand quantity that the system calculates by multiplying the on-hand quantity of the inventory item and cost per unit as shown on its inventory record.

oSuggested Adjustment

This column reflects the difference between the inventory item's Total and Calculated Costs. The amount shown in this column is the suggested amount that you can adjust in the Inventory Adjustment Maintenance function to reconcile the two cost values.

To generate the Cost Adjustment Requirement Report, perform the following procedures:

1.Access the Cost Adjustment Requirement Report function from the Adjustment Reports group under the Reports main menu in the Inventory Control module.

2.Click the List box button next to the Configuration field; then, select the report configuration that you want to use.

3.Select the report sorting option by clicking the List box button next to the Sort By field. Select any of the following options:

•Item #

•Item Class

•Product Line

•Warehouse

4.In the Layout field, click the List box button to select the report layout you want to use in generating the report.

5.In the Report Configuration area, define the desired report filters. You may mark the Individual checkbox if you want to generate the report for a single item, item class, product line or warehouse; and enter the appropriate value in the adjacent field; otherwise, select in the Filters area the desired criteria in generating the report.

6.Click the Preview or Print button to preview or print the report. Click the Configure tab to return to the report configuration page.

The Cost Adjustment Requirement Report function also provides you with the flexibility to perform the following:

•Set up user-defined report macro

•Set up user-defined sort option

•Set up user-defined report layout

•Include notes in the printed report

•Export the report to various supported file formats

•Send the report as attachment to an email

•Include time and printed by information

•Drill-down on certain fields in the report:

oItem #

AccountMate displays the Item Profile when you double-click the item number in the report.

Cost Adjustment Requirement Report

Cost Adjustment Requirement Report

See Also