E1: 76C: Amount To Distribute Calculated Incorrectly with Multiple Taxes with Voucher Entry For Colombia

(Doc ID 2353138.1)

Last updated on JANUARY 26, 2018

Applies to:

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

Symptoms

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

STEPS
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
Exriration Date - (See Tax Rate/Area P4008)
Calc Tax
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 link
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 Tot 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

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