My Oracle Support Banner

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

Last updated on JULY 17, 2020

Applies to:

JD Edwards EnterpriseOne Accounts Receivable - Version 9.2 and later
JD Edwards EnterpriseOne Accounts Payable - Version 9.2 and later
Information in this document applies to any platform.

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:

  GL Offset Tax Rate
P4008 grid setup
Row 1 RFCO Leave blank
Row 2 IVOC Leave blank
Row 3 RICO Leave blank
Row 4 RCBI Leave blank
  1. Set up RT AAIs for each of the above offsets, with unique GL Accounts
  1. Set up Tax Parameters (P76CUI02) as follows:
Sys Co Txp Sup Txp Tax Type Descr Effective Date Expiration Date Calculate Taxes Minimum Amount Economic Activity Tax Rate
Tax Parameters (P76CUI02) Setup
1 A N IV IVA 01-Jan-2020 31-Dec-2040 Y N N 19.000
1 A N RC RC 01-Jan-2020 31-Dec-2040 Y N Y 0.450
1 A N RF RF 01-Jan-2020 31-Dec-2040 Y N N  
1 A N RI RET 01-Jan-2020 31-Dec-2040 Y Y N -4.000
  1. 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
  1. 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
  1. 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
  1. 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

  1. In Customer Ledger Inquiry (P03B2002) inquire on the invoice, highlight it, and then select Row exit ‘Regional Information’.
  1. 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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