E1: 42: Sales Update (R42800) Enhanced to Prevent Integrity Issues Between Account Ledger (F0911) and Cardex (F4111) When Processing Credit Orders and Standard Cost (07) (Doc ID 1623515.1)

Last updated on SEPTEMBER 29, 2022

Applies to:

Symptoms

An integrity issue exists between the Account Ledger (F0911) and Cardex (F4111) for the inventory account when credit orders (CO) are created from history and the standard cost 07 is changed in P4105 after ship confirm(P4205) and before sales update (R42800) of the CO.

Issue can be reproduced with the following steps:

1. Have an item setup with standard cost 07 in P4105 ( $10 ).
2. Create sales order with quantity 20, ship confirm, print invoice and sales update.
3. P4105 Change standard cost for the item from $10 to $14. IB document created in F4111. Cardex and GL are in balance at this point.
4. P4210 create credit order from history CO. Credit order gets created with a cost equal with original cost ($10)
5. P4205 Ship confirm credit order. Entry is made to Cardex for credit along with standard cost variance = (14-10)*20=80
6. P4105 Change the standard cost from $14 to $16 . Corresponding IB record created in Cardex. This adjustment of standard cost is made after ship confirm and before sales update of credit order CO.
7. Print invoice for credit order and sales update for CO.
8. Sales Update (R42800) will write a inventory record to the General Ledger (F0911) of $120 instead of $80. There will be variance between GL and Cardex in inventory account of USD 40.

Cause

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