E1: 76C: Colombia A/R Invoices have Incorrect Taxes Calculated (P4008, P76CUI02, B76C0009) (Doc ID 2674772.1)

Last updated on NOVEMBER 07, 2023

Applies to:

Symptoms

When you have a tax rate/area set up for Colombian taxes in Tax Rate/Areas (P4008) with multiple lines for different tax percentages and GL offsets, the system forces the net tax amount to be 0.000 (zero) for A/R invoices.  This is even though the amount should be 1,560 for example.  As a result when the invoice is posted there are no entries for tax amounts calculated.

Steps to duplicate:

1. P4008 Tax Area setup:

Header:

• Tax Rate GCOMGEN
• Effective Date 01/01/2019
• Exp Date 12/31/2040

2. Set up RT AAIs for each of the above offsets, with unique GL Accounts

3. Set up Tax Parameters (P76CUI02) as follows:

4. Set up A/B Revisions (P01012) for the customer:
   1. Mailing tab:
      1. City – Bogota
      2. State: CO – Colombia
   2. Category Codes tab:
      1. Cat Code 07 - BCO

5. Click on Form exit ‘Regional Information’ in P01012, and set up the following for the customer:
   1. Tax Payer Type - Colombia = N
   2. Pers/Corp -Colombia = A
   3. Tax ID = customer’s tax ID or blank
   4. Economic Activity Colombia = BCO
   5. CIIU Code Colombia = for example 50521
   6. Effective Date = 01/01/2020
   7. Expiration Date = 12/31/2040

6. Set up A/B Revisions (P01012) for the company and click on Form exit ‘Regional Information’:
   1. Tax Payer Type - Colombia = A
   2. Pers/Corp -Colombia = A
   3. Tax ID = company tax ID
   4. Economic Activity Colombia = BCO
   5. CIIU Code Colombia = for example 50521
   6. Effective Date = 01/01/2020
   7. Expiration Date - 12/31/2040

7. Create an A/R invoice for the customer via Standard Invoice Entry (P03B2002/P03B11):
   1. Taxable Amount of 10000
   2. Tax Area from Step 1
   3. Tax Explanation V

NOTE: There are no taxes calculated

8. In Customer Ledger Inquiry (P03B2002) inquire on the invoice, highlight it, and then select Row exit ‘Regional Information’.

9. The tax information appears as follows:

RFCO – Tax amount is blank as setup was not complete

IVOC – Tax Rate is 19.000, the tax amount is 340 which is incorrect, as it should be 1,900.00

RICO – Tax Rate is 4.000-, amount is correct 400-

RCBI – Tax Rate is .600, amount is correct 60

The system is forcing the Net Tax amount to be 0.00 whereas it should be 15.60, and the total tax amount should be 1,560. 00

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.