Average Cost Change

The Average Cost Change (RACCG) report provides an audit trail of changes in the average cost of an item. This report alerts the warehouse manager to any large fluctuations in the average cost of an item and to any manual cost adjustments.

The Average Cost Change (RACCG) report displays the quantity of the item involved in the transaction and the on-hand balance of the item. The recalculated average cost of the item appears on the report along with the previous average cost of each unit and the transaction unit cost. The date and time of the average cost change are also displayed on the Average Cost Change (RACCG) report.

A field labeled REASON appears on the Average Cost Change (RACCG) report. The information that appears in this field explains the reason for the change in the average cost of the item. For many transactions listed on this report, information does not appear in this field. The absence of information in the REASON field indicates that the item’s average cost change was due to daily receipts and/or returns. However, a message will appear in the REASON field if the average cost change resulted from something other than receipts and returns. The messages that can be displayed on the Average Cost Change (RACCG) report include:

• Override: The item’s average cost was changed manually via the Average Cost Change (ACC) screen in the Inventory module.
• Limit exceeded: The item’s average cost changed more than 10 percent.
• Negative balance: When the NCAS calculated the average cost of the item, the item’s on-hand balance was negative.

The Average Cost Change (RACCG) report should be reviewed daily. It is located in RMDS in the report group IN261-2.