My Oracle Support Banner

E1: 43: Tolerance Error (2837) on Foreign Voucher Match Due to Exchange Rate Difference Rather Than Amount Difference (Doc ID 2751329.1)

Last updated on FEBRUARY 10, 2021

Applies to:

JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

The system throws the error Value Exceeds Tolerance (Error ID 2837) on a foreign voucher when changing the exchange rate and foreign amount to voucher. But the tolerance is exceeded due to exchange rate difference, not to foreign amount change by 1 cent, which is, however, under Tolerance limit setup.

The issue can be reproduced at will with the following steps:

  1. P4322 Set tolerance rules for Unit Cost, Tolerance Percentage 1%.
  2. Create a foreign purchase order with exchange rate 0,3245294, the Foreign Unit Cost is 0,391, so the domestic Unit Cost is calculated as 0,1269.
  3. Receive the purchase order at same exchange rate.
  4. Set processing option of P4314 to check the tolerance and Display an error message.
  5. Enter a voucher for a different exchange rate 0,3295812. Based on this the domestic Unit Cost is calculated as 0,1289.
  6. Tab down and note there is no tolerance check error. This is correct as only exchange rate changed and the variance will be booked in a specific variance account.
  7. Change the foreign amount to voucher with 1 cent, which is definitely under Tolerance limit setup, and tab down.
  8. The error Value Exceeds Tolerance (Error ID 2837) is thrown.

As there is a change in the voucher amount, the system checks the tolerance rule set on the domestic unit cost, calculated based on the amount changed. And the error will be displayed when comparing the voucher domestic unit cost as 0,1289 with the receipt unit cost of 0,1269, the difference is more that 1% (which is the tolerance setup). So, when checking the tolerance, even if the amount changed with only 1 cent which does not exceed the tolerance, the system also considered the exchange rate variance and ended in tolerance error.

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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