My Oracle Support Banner

Incorrect Cost Posted in Tran_data (Doc ID 2748662.1)

Last updated on JUNE 22, 2023

Applies to:

Oracle Retail Merchandising System - Version 16.0.2 and later
Information in this document applies to any platform.


Using Standard Cost methodology in RMS (Retail Merchandising System).
Items with negative stock on hand are posting a Tran Code 70 showing cost variance following a PO (Purchase Order) receipt using Average Cost instead of the Standard Cost.

Expectation is Tran Code 70 will be posted using Standard Cost for Inventory revaluation instead of using the new PO Cost/Average Cost.

P1 is a pack with C1 as component item.
SOH for P1 is negative.
RMS is using standard cost.

Steps required to reproduce this issue:
1. Do cost change to a component item C1 - which had an open Order for the pack P1.
2. Once the cost is reflected, perform PO receipt for this Order.
3. Tran code 70 is posted showing cost variance of using Average cost instead of standard cost.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.