E1: 76C: Amount To Distribute Calculated Incorrectly with Multiple Taxes with Voucher Entry (P0411) For Colombia (Doc ID 2353138.1)

Last updated on JUNE 09, 2022

Applies to:

Symptoms

When posting Colombia Vouchers, tax explanation code C with multiple taxes setup in a specific manner.  The amount to distribute is incorrect and receive an out of balance error.

Detailed specific steps to duplicate the issue
The issue can be reproduced at will with the following steps:
1. P0013 - COP - Colombia, Decimals = 0
2. P4008 Tax Area setup
Tax Rate CO1VNHO0006, Effective Date 01/01/2017, Expiration Date 12/31/2040
         Address Tax Authority     GL Offset   Tax Rate
Row 1 99999999                      RTHO         11.000-
Row 2 99999999                      IVGC          19.000
Row 3 99999999                      RIVA            2.850-
Row 4 99999999                      ICPA             blank
Row 5 99999999                      RERS             .600-
                                    Total amount           4.550
3. P76CUI02 Tax Parameters - Work With Tax Parameters
Sys Code (2 = A/P)
CO TxP (Company 80 - A/B Tax Type) = A
Sup TxP (P01012 Regional info Tay Payer Type) = N
Tax Type (see P4008 - GL Offset)
Effective Date - blank
Expiration Date - (See Tax Rate/Area P4008)
Calc Tax - blank
Min Amt - if there is a minimum amount specfied
EA Flg (Economic Activity Flag) would also be on the Supplier regional setup
Sys CoTxP SupTxP TaxType Descrip         Effect.Date     Exp Date     CalcTax MinAmt EA Flg Tax Rate
 2     A         N          IC      IND&COM       01/01/1999  12/31/2030    Y           N         Y
 2     A         N          IV      IVA                01/01/1999  12/31/2030    Y           N         N
 2     A         N          RE      RETECREE      01/01/2013  12/31/2030    Y           N         N
 2     A         N          RI      RETENCION    01/01/1999  12/31/2030    Y           N         N
 2     A         N          RT     RETEFUENT    01/01/1999  12/31/2030    Y           N         N
 2     A         N          TC     IMPUESTO      01/01/2013  12/31/2030    Y           N         N
.
4. ICA Parameters: Used only for tax type ‘IC’:
TaxType CityCd C/EA   Desc        Effect Date      Exp Date     Max Unit Tax Rate
IC          CAL    BCO    Consult    01/01/2003    12/31/2030  Blank      .690-
.
5.P01012 A/B for 171141
6. Click on Form>Regional Information
Address Number = 171141
Alpha Name = Colombia Supplier
Tax Payer Type - Colombia = S
Pers/Corp -Colombia = C
Tax ID = suppliers tax ID
Economic Activity Colombia = blank
CIIU Code Colombia = for example 7630
Effective Date = 01/01/2016
Expiration Date - 12/31/2040
7. G76C>Voucher Entry
8. Enter a domestic voucher
Supplier, 171141, Company 00080 - Colombia, Currency = COP
Taxable Amount = 2,847,000
Tax Ex = C
Tax Rate/Area = CO1VNHO006
Click okay and the Gross Amount will be populated 2.973,976
(2,847,000 + 126,976 = 2,973,976)
Tax Amount = 126,976
Click okay and to the distribution screen.
Amount to distribution shows 3,287,146 which is incorrect
Amount to distributed should be 3,387,930
The difference is 100,784 (81,140 + 19,644)
9. Click okay and go back to the Standard Voucher Entry A/P Supplier Leger
Inquiry
10. Select the Document PV, for example 102>Row>Regional Info
11. Tax Information will appear
Tax Authority   GL Offset     Tax Rate    Tax Amt
Blank line
99999999        RTHO           11.000-     131,170-
99999999        IVGC            19.000      540,930
99999999        RIVA              2,850-      81,140-
99999999        ICPA                .966-      19,644-
99999999        RERS              blank        blank
Taxable amt 2,847,000 Total Tax 4.460 126,976 (Net Tax Amt)
12.Post the Voucher
Receive an out of balance error.
Doc     Cur Code      Debit          Credit
PV 102 COP        1,151,840
AE 102 COP                         1,041,840-
AE 102 COP                               9,660-
AE 102 COP                             28,500-
AE 102 COP                           110,000-
  Total                1,151,840  1,190,000-

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.