E1: 04: R04580 Disregards Gross Amount Data Selection For 3-Decimal Currency
Last updated on NOVEMBER 18, 2015
Applies to:JD Edwards EnterpriseOne Accounts Payable - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.
When Calculate Withholding (R04580) is run with a data selection on Gross Amount (AG) as follows:
Gross Amount (AG) greater than 1000
and it is run for vouchers entered in a 3-decimal currency, for example Tunisian dinars (TND), R04580 does not exclude vouchers with a gross amount that is less than or equal to 1000.
This is because even though you enter 1000 as a literal value, the system converts it to 1,000.00 (where the comma is the thousand separator, and the dot is the decimal separator). It then reads an amount like
and includes it in the R04580 run.
NOTE: the same appears to be happening with the QBE field above the Open Amount column in Speed Status Change (P0411S), found when researching a possible workaround (see below).
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