E1: 04: R04580 Disregards Gross Amount Data Selection For 3-Decimal Currency (Doc ID 2043972.1)

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.

Symptoms

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

TND 750.000

as

TND 7500

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).

 

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