My Oracle Support Banner

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 JULY 27, 2023

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


Case 1

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)

Case 2

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.