Oracle R12 How to change a paid invoice when you need to make a tax corrections

Changing the tax rate or recovery rate on a paid invoice

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 reentering 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.Oracle R12 Payables Options for Invoices

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.

Andrew Bohnet
Follow Us

Andrew Bohnet

Managing Director and Oracle Fusion Tax / eBTax expert at eBiz Answers Ltd
Andrew Bohnet is the current chair for the Oracle Tax Management SIG. He founded eBiz Answers to offer clients complete tax solutions making the most of the rich functionality of the R12 and Fusion tax modules. Whether it is analysis, design, configuration or support, eBiz Answers provide an unparalleled service when it comes to a complete tax solution. Having worked on one of the first Oracle R12 implementations in Europe, Andrew was exposed to the tax module early on and worked closely with Oracle to fix bugs, enhance functionality and present on numerous occasions on the subject of tax and Oracle. When it comes to presenting on eBTax, you wont find a more experienced consultant outside of Oracle.
Andrew Bohnet
Follow Us