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