E1: 42: Invoice Print (R42565) Calculates a Small Difference in Order Total Due to Tax Amount Rounding (Doc ID 2993633.1)

Last updated on DECEMBER 21, 2023

Applies to:

Symptoms

On a 30 line Sales order for Government Customer with VAT Taxes, Invoice Print (R42565) calculates a Total Amount of the Invoice with 0.02 more than what the Government Customer calculates that it should be.

When the invoice data is sent to the Government Customer's Website for automatic payment, it is rejected because of the 0.02 difference. 

STEPS TO DUPLICATE (From Oracle Support Test using Demo Data)

1. Setup a new Tax/Rate Area (P4008): 
   1. Tax Rate is 19% on one Tax Authority.
2. Setup a new Customer:
   1. Currency is EUR.
   2. Tax Explanation Code is V (Value Added Tax).
   3. Tax Rate Area is populated with the value from step 1.
3. Branch Plant for the Sales Order will be 74  (EUR Currency).
4. Setup Tax Rules (P0022) for Company 74 AR:
   1. Tax on Gross Including Discount radio button is selected.
   2. Sales Order Taxes at Order Level checkbox is NOT checked.
5. Create a 30 line sales order for the Customer and Branch Plant with the same Extended Amounts as those from the Customer’s order:
   1. The Sum of the Extended Amounts without Taxes is 750.76.
6. Take the Row Exit to On-Line Invoice to see the Tax Calculations.
7. On-Line Invoice shows the following Tax Calculations:
   1. Order Total = 750.76.
   2. Taxable Amount = 750.76.
   3. Tax Rate at 19% = 142.66.
   4. Order Total = 893.42.
8. Now Export the Order to an Excel Spreadsheet and calculate totals:
   1. Taxable Amount = 750.76.
   2. 19% Tax = 142.64.
   3. Spreadsheet Total Order = 893.40.
   4. JDE Invoice Total Order = 893.42.
9. Run Invoice Print (R42565) with Tax Summary by Tax Authority processing option set:
   1. Tax Summary correctly calculates tax as 142.64.
   2. Total Line incorrectly calculates tax as 142.66 and Order Total as 893.42, which is 0.02 too high.

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.