E1: 76E: Ecuador Voucher Transactions are Out of Balance When Using Tax Explanation Code = 'C' and Tax Rate/Area Has 3 Lines With the Third Line Showing a Negative Tax Rate Percent (Doc ID 3066362.1)

Last updated on JANUARY 06, 2025

Applies to:

Symptoms

When processing a voucher that is using Tax Explanation code = C (Value Added + Sales Tax) and a Tax Rate/Area with three (3) lines where the the first and third lines are negative percents and the second line is a positive percent, the posting of the transaction will fail and cause an out of balance for the tax amount.

Steps to duplicate:

1. Set the User Profile for country to EC and sign off and back on.
2. Go to Work with Tax Rate/Areas (P4008) and set up the following for the Tax Rate/Area using three different G/L offsets:
   - Tax rate 1  -15.000 (Retention)
   - Tax rate 2   15.000 (IVA)
   - Tax rate 3  -15.000 (Retention for IVA)
   The net percent is negative.
3. Verify the AAI's (fast path AAI) are set up correctly for the tax G/L offsets.
4. Go to P76E0002 - Tax Setup verify all three rows have Y in Calculate Accounts Payables (Y/N).
5. Go to Standard Voucher Entry (P0411) and enter a voucher using the above Tax Rate/Area with Tax Explanation code = C.
6. Post (R09801) the voucher and note the Out of Balance errors in Work Center.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.