My Oracle Support Banner

E1: 43: Value Exceeds Tolerance Error (2837) After Exchange Rate Changed (Doc ID 2612896.1)

Last updated on MARCH 26, 2021

Applies to:

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

Symptoms

While attempting a 2-Way Match Voucher for 10,403.18 on a Foreign Purchase Order after the Exchange Rate changed, the system responds with a 'Value Exceeds Tolerance' (2837) error. This occurs because at the time of PO Entry on 6/15/2019 the USD to CAD exchange rate was 1.2948336, but at the time of Voucher Match on 10/30/2019 the USD to CAD exchange rate fluctuated to 1.3243279. The foreign unit cost of the voucher did not change but the domestic unit cost fluctuated above the tolerance limit because of the exchange rate fluctuation.

ERROR MESSAGE:


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

  1. On the Tolerance Revisions (P4322) screen for Function 1 (Voucher Match) the Zero Tolerance checkbox is checked on Quantity, a Tolerance Percent of 10% and Tolerance Amount of 100.00 is set for both Unit Cost and Extended Cost.
  2. Customer created a J line type foreign purchase order with a USD Supplier and a Canadian Dollar (CAD) Branch Plant on 6/15/2019. The USD to CAD exchange rate was 1.2948336.
  3. The foreign amount of the purchase order in of 10,403.18 USD
  4. Open PO Inquiry (P4310) for Purchase Order shows the Domestic Amount of the Purchase Order is 13,470.38 CAD.
  5. When attempting to create a 2-Way Match Voucher on 10/30/2019, the exchange rate has fluctuated to 1.3243279.  
  6. The foreign amount of the purchase order in of 10,403.18 USD has not changed, but the domestic amount in CAD will have gone up more than 100.00 because of the currency fluctuation.
  7. As a result the Value Exceeds Tolerance Error (2837) is because the domestic cost is now greater than 100.00 or 10% more than the original purchase order.
  8. The error should not occur since only the exchange rate changed and no change was made to the foreign amount vouchered.


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.