E1: 43: Increase Currency Precision When Rounding Exchange Rate Variances (P4314) (Doc ID 2963354.1)

Last updated on JULY 24, 2023

Applies to:

Symptoms

For foreign currency P4314 Voucher Match Accounting, when the exchange rate varies over time and the receipt and voucher match consistently have exchange rate variances, the calculated variance amounts can be off-by-one, due to rounding differences. When the rounded result is compared to a calculated foreign amount, the rounding is often off-by-one, as if rounding is not accurate consistently.
 
For example, a calculated amount of -62,04068 was rounded to -62.03 instead of -62.04, as expected. These rounding inconsistencies can lead to batch totals that are off by 0.01 or 0.02 or more.
 
At purchase order voucher match, the foreign and domestic extended amounts and currency exchange rate variances calculated amounts show rounding inconsistencies.

The request is that any entry (with more decimals than the number set up in JDE) would be rounded up or down according to the universal rule of rounding. In particular, the exchange rate variance credit amount needs to be calculated first without any rounding, then the final result rounded and written to the batch.

Cause