My Oracle Support Banner

R12:AP:Amount Piad Is More Than The Invoice Amount Of Standard Invoice After Applying The Prepayment Invoice (Having WHT Calculated) (Doc ID 2579060.1)

Last updated on JULY 19, 2021

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.


User find that when the prepayment invoice having withholding tax calculated is applied on standard invoice and validated then the amount paid is more than the invoice amount for the standard invoice.


Steps To Reproduce the issue

The issue is reproduced in customer instance but in internal instance, it is calculating the correct amount

1)Responsibility: Payables vision operations
2)Setup steps:

A)Create Tax authority as a Supplier
Navigation: Go to payables Responsibility>Supplier>Entry>
Enter the Supplier name>click on organization>select Type as tax Authority
Enter the required details and save it
for Example:INCOME TAX SUPPLIER created as Tax Authority

B)Create a Supplier
Navigation:Go to payables Responsibility>Supplier>Entry>
Enter the Supplier name>Provide the required details
Click on tax details hyper link>enable the check box >Allow Withholding Tax and enter the Payment Withholding Tax Group at supplier and supplier site level
for Example:1% tax rate

C)Create Tax Code
Navigation:Go to payables Responsibility>Setup>Tax>Tax Code
Enter the tax code, Gl account, tax authority, enable the radio button against flat rate,enter tax rate and from and to dates
for Example: WHT@1%

D)Create Tax group
Navigation:Go to payables Responsibility>Setup>Tax>Tax Group
Enter name
Enter Tax code>operating unit,tax code

E)Create Prepayment Invoice Example:INV_PRE3
Navigation:Go to payables Responsibility>Invoices>Entry>Invoices
Select the type as prepayemnt and enter the required fields and enter invoice amount of 50000 while making payment apply the payment withholding tax which is 1%.Once the payment is made the withheld amount would be 500 and the amount paid is 49500.

 F)Create a standard invoice example: INV_STA1 with the invoice amount of 70000 and validate then apply the prepayment of 50000 so the remaining amount of standard invoice woudl be 20000
    when the remaining amount of 20000 is being paid as per the payment withholding tax calculation the payment amount should be 19800 but it is calcualting the 20300.





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.