E1.8.12 Multicurrency Issue with Standard Voucher CAD...

[saramann]

We are a US Company...We are entering a standard voucher in CAD, Supplier (CAD), Bank Account (CAD), g/l Distribution for expenses (USD). The CA (company) intercompany transactions to USD (currency) is the problem - however the posting report is correct and appears to balance. It is not creating the intercompany AE (USD) correctly as the amount difference is off by the exchange.

I have reviewed the version, AAi's, company constants, MBF, reviewed the ledgers in both currencies and yet it is not balanced. This month there were at least 5 - 8 errors per the AC - any ideas as to what is missing. We cannot pay invoices to our CAD suppliers as this will cause an error. We can however enter if USD to CAD and make payments without an error.

I have opened a SR with Oracle/JDE and uploaded needed files. I also perused the Knowledge Garden as well. Would anyone have a clue as to what we are missing.

Thanks in advance for your response.

Sincerely, Sara-Mann

 

[jdesteve11]

Our company is having the same issue but has also not found an acceptable solution. It is believed to be a Bug that goes all the way back to 8.4 but Oracle isn't commenting or just won't say. We are experimenting with custom mod that will add another line to the order that is the difference amount that is missing.

 

[Nashaat]

Our workaround solution is to manually correct the amount in F0911. We do not like this SQL method. Investigation is progressing with the following information from Oracle.


Question 3: Batch out of balance ( R09801) error in XE and ERP 8 with multi currency orders because of decimal rounding issues.

Answer 3: SETUP:
Step my process Foreign mod (Currency=USD,Base=THB and X-Rate=39.5901).

Entered po with qty 10,000.000 EA and unit cost 9.8500$ so the system has been calculated extended cost to 98,500.00$.
Entered partail receipt with lot#200406170001,qty=604.330 the system has been calculated foreign amount to 5,952.65$ and domestic amount to 235,666.04 BHT.
Entered match voucher with the system has been calculated domestic amount to 235,666.01 BHT.
Tried to calculate by 5952.65 * 39.5901 = 235,666.01 , or , by 9.85*39.5901*604.330 = 235,666.03 and have never gotten the result 235,666.04.
How is the value 235,666.04 calculate?
EXPLANATION:
The root cause is due to the difference in calculation of Extended amount in PO Entry/Receipts and AP Editline. In PO Entry and receipts domestic extended amount is calculated by converting foreign unit cost to domestic unit cost and multiplied by quantity.

Whereas in Accounts Payable domestic extended amount is directly calculated from foreign extended amount using exchange rate. So the calculations are like this:

PO Entry/Receipts : Rounded-up (Rounded-up(9.85 x 39.5901) x 604.330).
Round (389.9625 x 604.330) = 235,666.04 (rounded-up)

In Accounts Payable: Round (5952.65 x 39.5901) = 235,666.01 (rounded-up)
That means there is penny variance between these two calculations, you may need to set Allow Post Out Of Balance to bypass the error or manually adjusted the value in F0911 and re-run the posting.

Note: This is a soft rounding issue and already addressed under reported SARs 10787193 , 10800169 and 10796489 . The fix will be available in EnterpriseOne 8.9 and higher releases. For XE / ERP 8 also ensure that BUG 10824679 has been applied.

Best
Nashaat