My Oracle Support Banner

R12: AP: The Prepaid Amount Including Tax Exceeds The Invoice Amount Due to Rounding Applied to Multiple Lines in Standard Invoice (Doc ID 3022605.1)

Last updated on JUNE 27, 2024

Applies to:

Oracle Payables - Version 12.2.4 and later
Oracle E-Business Tax - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

The prepaid amount including tax is applied on standard invoice with multiple lines and same tax percent. Because of the rounding applied to total, sum of prepayment is different than same percent applied to multiple lines, and hold is placed on standard invoice 'The prepaid amount including tax exceeds the invoice amount'.



ERROR
-----------------------

Invoice with prepayment application cannot be validated because of hold "The prepaid amount including tax exceeds the invoice amount"



STEPS
-----------------------
Steps to reproduce:

1. Log into Oracle Applications using Payables responsibility.

2. Open the Invoice Workbench screen

3. (N) Invoices > Entry > Invoice

4. Entry Prepayment invoice with amount 50 000

5. Action> Validate

6. Action> create accounting and pay in full

7. Same responsibility, open the Invoice Workbench screen (N) Invoices > Entry > Invoice

8. Enter Standard invoice with 2 lines of 15541.67, 31083.34 total

9 Action > Apply/unapply prepayment above

10. Action> Validate

11. See Hold "The prepaid amount including tax exceeds the invoice amount" because of rounding:

 
LINE_TYPE    LINE AMOUNT TAX TAX AMOUNT 3 DECIMALS TAX AMOUNT ROUNDED NEAREST TAX AMOUNT ROUNDED UP TAX AMOUNT ROUNDED DOWN
LINE 1 15541.67 20% 3108.334 3,108.33 3,108.34 3,108.33
LINE 2 15541.67 20% 3108.334 3,108.33 3,108.34 3,108.33
PREPAY 3 -31083.34 20% -6216.668 -6,216.67 -6,216.67 -6,216.66
        DIFFERENCE -0.01 +0.01 0.00

 

 

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
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.