Why Does the Inventory Journal Report Show a Cost Update Record?

Questions and Answers

Q: The IC Journal Report shows a Cost Update record under the Transaction Type heading for an item distribution. The Reference and Src headings display Adjust cost, tranno xxx and PO. There is no indication of why this cost adjustment was made.

Important
The cost adjustment record comes from the ICTRAN table. These cost adjustment records are distinguished by a CA value found in the Trantyp field.

A: In this scenario, a cost adjustment was created in the Purchase Order module. The cause of this cost adjustment record is the result of one of three things:

  •  Receiving an item on a purchase order
  • Entering a cost greater or less than the frozen average cost of the item
  • Applying the receipt to a shortage (overship) record

In Sage Pro ERP overshipping an item will automatically freeze the average cost of the item at the last recorded cost. When a receipt is applied to that overship record, the cost will be adjusted to account for any differences and the cost of the item will be unfrozen.

© Copyright Sage Software

Leave A Comment?