How to make a tax change to a paid invoice

Module: Payables

Oracle Version: Oracle R12

Error Message:

You have made a mistake on the tax rate used and accounted and paid that invoice. You have realised the tax amount is correct but the name of the tax or type of tax is wrong and you want to change it before submitting your tax returns. The issue is that you cannot update the paid invoice but don’t want to cancel and re-enter the one that has been paid as you will need to reverse the payment first.

Cause of Issue:

Payables has been set ups so the ‘Allow Adjustment to Paid Invoices’ option has been set to no.


First you need to make sure you know the policy of adjusting a paid invoice as many companies do not want to allow this option and by default it should certainly be set to NO. However, we have found that when a user applied the wrong tax code to a transaction and a correction is needed, it is far easier, cleaner and more accurate to change that invoice even if it has been paid.

Changing the original transaction instead of applying a credit note and re-entering the invoice has many more benefits. Firstly, the time taken is much less than having to create a credit memo and a new invoice, both of which then have to be paid. If you do create a credit memo and new invoice then you have to be 100% accurate on the invoice distributions that you are entering so the risk here is high as the tax recovery amount could be dependent on the GL code used. Credit Memo and new invoice also means that the tax reporting becomes less clear as instead of one transaction on there you now have 3 which you may or may not be able to link together.

You also cannot change a zero rated tax rate to a standard rate as this would put the invoice out of balance and as it has been paid, the invoice amount has been locked down, a change to a paid invoice is when you have a Zero rate tax when it should be Exempt or Reversed Charged (Offset) or the rate used had the wrong recovery percentage.

How to make the change

To make this change, go to the Payables Module that you have access to that has setup capabilities. Then open the ‘Payables Options’ form.

Navigate to the ‘Invoice’ Tab and find the ‘Allow Adjustments to Paid Invoices’ option and tick it.

You can now make changes to your paid transactions.

When you make the changes, you will need to reapply to create the accounting as often with a change to a tax rate.

After the changes are paid, reset the ‘Allow Adjustment to Paid Invoices’ back to being unticked.


Submit a Comment

Your email address will not be published. Required fields are marked *

Additional Support

When available, we provide additional resources to a particular support item, such as User Guides, blog posts, support videos and links to recommended Oracle solutions.


User Guide

Video Support


Oracle Recommendations

GCC VAT Oracle Learning Series

Want to know how to set tax up for Oman, Kuwait, Bahrain, Qatar, United Arab Emirates and Saudi Arabia then sign up to our free webinar series.

Share This