E1: 43: Value Exceeds Tolerance (2691) Error Due To Currency Fluctuation (Doc ID 2271333.1)

Last updated on MAY 29, 2017

Applies to:

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

Symptoms

PO Receipts (P4312)

When attempting to receive a purchase order with tolerance checking activated with a different exchange rate (1.3742) than was on the purchase order (1.3356), the following error occurs.

ERROR
Value Exceeds Tolerance (2691)
Cause. . . . . The value entered exceeds the tolerance amount and/or percentage defined in the Purchasing Tolerance file (F4322).
Resolution . . The value entered will need to be adjusted, so that it is within the tolerance limits defined in the Purchasing Tolerance file (F4322).

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

  1. Tolerance Rules for Function 2 (Receipts) is setup with an Extended % Tolerance of 5 and Extended Amount Tolerance of of 25.00
  2. A J-line type lump sum purchase order is created in a CAD currency Branch Plant for a USD currency customer.
  3. The Domestic CAD Amount is 100,170 and the Foreign USD Extended Amount is 75,000 and the Exchange Rate is 1.3356.
  4. The exchange rate is updated from 1.3356 to 1.3742
  5. The Tolerance Tab Option #1 (Quantity and Amount) is set to 2 (Display an error message) in the PO Receipts (P4312) version.
  6. When the user attempts to receive the PO Foreign USD Extended Amount is still 75,000 which is the agreed price to the vendor but the system calculates a new Domestic CAD Amount to be 103,065 which is 2,365 CAD greater than was on the purchase order (100,170).
  7. The 2,365 CAD is greater than the 25.00 CAD tolerance rule that has been set so the system issues the Value Exceeds Tolerance (2691) Error message.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms