R12: AP: Invoice Amount Unpaid Shows Incorrectly in Apply/Unapply Prepayments Window For Partially Paid Invoice With Offset Tax
(Doc ID 2791081.1)
Last updated on SEPTEMBER 01, 2021
Applies to:Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.
Standard invoice is created with Offset Tax. After invoice is partially paid the remaining Unpaid amount Shows Incorrectly in Apply/Unapply Prepayments Window
and invoice cannot be fully paid with Prepayment application
Prepayment amount = 100000
1st Standard invoice amount = 99000
2st Standard invoice amount = 2000
1st standard invoice 99000 + 2nd standard 1000 = 100000 fully applied prepayment.
Now the system should show 1000 unpaid amount of the 2nd standard invoice.
However, system is showing 930.23.
Note: On all invoices 5 % reverse tax has been calculated (Offset Tax)
Standard Invoice with Offset Tax, amount 101589.31 and amount paid 28502.31 with Check
Offset Tax (16%) value=16254.29-16254.29 = 0
In the amount remaining column , it is showing correctly as 73087 (invoice amt – amt paid)
In Apply/Unapply Prepayments window, the invoice amount unpaid is showing
incorrect as 63006.03 instead of 73087
Steps to reproduce
1. Payables responsibility
2. Create Standard Invoice with Offset tax
3. Partially pay Standard invoice by applying a Prepayment or by Check
4. Try to fully pay Standard invoice with Prepayment
Navigation path: Invoice workbench> Search for Standard Invoice > Click on Actions button . Enable Apply/Unapply Prepayment and press Ok
5. Unpaid amount is incorrect
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