E1: 47: R47071 Incorrectly Rounds Amount Open and Amount Received for Foreign Currency Purchase Order (Doc ID 2496741.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

When changing foreign unit cost using the EDI Receiving Advice Edit/Create - Purchasing (R47071) - Inbound 861, system calculates Amount Open and Amount Received in domestic currency incorrectly.

When changing foreign unit cost from P4312
==========================================
1. Enter foreign currency(USD) purchase order in P4310. Base currency is JPY and quantity is 380000.
2. Open P4312 to enter receipt.
3. Enter exchange rate 111.01 and quantity is 380000, leave foreign unit cost blank and enter extended foreign amount as 158.84 USD.
4. See the Databrowser: F43121.  See the Amount Open and Amount Received are calculated as 17,633 JPY.  (158.84 USD * 111.01 = 17632.8284 It's rounds to 17,633 JPY)

When changing foreign unit cost from R47071
==========================================
1. Next enter other foreign currency(USD) purchase order in P4310 with same quantity with above case.
2. Prepare EDI tables F47071/F47072. Set quantity as 380000, rate as 111.01, foreign amount received as 158.84 USD. Also populate foreign unit cost (FUC,FRRC) in F47072.
3. Run R47071
4. See the Databrowser: F43121  See the Amount Open and Amount Received are calculated as 17,632 JPY which is 1 JPY different from above case even if the quantity and amount are exactly same.

Changes

Cause

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