E1: 42: OM Purchase Order Created from RMA (P400511) has Incorrect Cost on Multi-Currency Order when Customer has a Supplier Master Record (F0401)
(Doc ID 2598698.1)
Last updated on APRIL 28, 2020
Applies to:JD Edwards EnterpriseOne Sales Order Management - Version 9.2 and later
Information in this document applies to any platform.
When creating an RMA from a Sales Order that is multi-currency, if the last disposition code of CRR is used, the resulting OM purchase order will have an incorrect Unit Cost (PRRC), Extended Cost (AEXP) and Amount Open (AOPN). This occurs when the Customer/Ship to number is also set up with a Supplier Master record (F0401). With this setup, the PRRC is the domestic cost x the exchange rate.
Steps to Duplicate
1. Create a foreign currency Customer (P01012 and P03013).
2. Add a Supplier Master record for the customer, P04012.
3. Create a Sales Order for the customer and process to Ship Confirm (P4205).
4. Add an RMA - P40051, calling P400511 (processing option is set with Credit Memo last disposition = CRR)
5. In P400511, enter customer number and take form exit to Sales Ledger (system calls P42025).
6. Find the original sales order (SO), select the line and take the row exit to Credit Memo/Select Line.
7. Click on the cancel button; the system returns to the P400511. The Last Disposition = CRR as expected. It is observed that a CO and OM purchase order are created.
8. Save the RMA.
9. Inquire on the F4311 in databrowser for the OM order. Note the Unit Cost (PRRC), Extended Cost (AEXP) and Amount Open (AOPN) values are incorrect.
10. Perform the same test for a customer that is not set up in the Supplier Master (F0401). Note that the system creates the OM order with the correct costing information.
The issue is addressed in our code by the following 9.2 bug:
Bug 30413303 : OM Purchase Order Created from RMA has Incorrect Cost on Multi-Currency Order
Return Material Authorization Revisions - P400511
Before the fix, when a Purchase Order is created though RMA for foreign order, the system passes the domestic cost to F4311EditLine and the it is used as foreign cost in purchasing.
After the fix, changes have been made to pass the correct cost to the Purchase Order
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document