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:

Symptoms

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


Example

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

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.