E1: 52: Retainage Release (P52RR) Rounds Up Causing Penny Differences (Doc ID 1606702.1)

Last updated on MAY 31, 2016

Applies to:

JD Edwards EnterpriseOne Contract and Service Billing - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

When using a 10% Retainage Rule (P5204) in the Contract Billing Master (P5201) and a Tax Rate Area (P4008) of 8.25%, the system calculates the Deferred Tax (DDTR) incorrectly casuing a .01 penny difference in the original Retainage Amount (RTNG) and the sum of the released amount stored in the Gross Amount (AG) of the invoices created in the Customer Ledger (F03B11).

For example, a contract billing invoice with a Retainage Amount of 100 and a Deferred Tax Amount of 8.25 creates a penny difference if releasing the retainage only 50% at a time. The first 50% released in Retainage Release (P52RR) creates a Tax Amount (STAM) of 4.13. The remainder, when released in a separate invoice, creates a Tax Amount of 4.13 as well. The sum of the Gross Amount created by the two batches in the Customer Ledger (F03B11) is 8.26, which is .01 off of the original Deffered Tax Amount of 8.25, which causes the gross amount (AG) to be out of balance by .01 from the original Retainage Amount held.

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