E1: 43: Deferred Tax Rounding Issue with Positive vs Negative Amounts (Doc ID 2100267.1)

Last updated on APRIL 05, 2017

Applies to:

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

Symptoms

When performing a voucher match with VAT and Deferred Tax on Retainage, there is a rounding difference created by the voucher match program. In this example, there are two order lines being matched (one amount is positive and the other amount is negative - same absolute value). The positive line item generates a tax amount that is 0.01 different from the negative line item. This should not be the case.  Both tax amounts should be the same (albeit directionally opposite). This then causes a difference in the Deferred Tax on Retainage amount. Note that it is possible to manually overwrite the Tax Amount; however, the correct and consistent amount should be calculated automatically by the JDE program.

The issue can be reproduced at will with the following steps:
1. Create a Tax Rate Area for 20% and assign that to a supplier and a V tax explanation code.
2. Enter a 2 line subcontract order with a 2.5% retainage on the header and with the following detail line amounts: $1091244.64 for line 1 and -$1091244.64 for line 2.
3. Perform a progress payment on the 2 lines and notice the tax amount is off by .01. The tax amount should be the same for both lines. This causes the Deferred Tax on Retainage amount to be off by the same .01.

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