How to change the Cancelled Date of Invoice in AP. If Invoice has got no distributions and does not require any Accounting

https://aporaclepayables.blogspot.com/2017/07/how-to-change-cancelled-date-of-invoice.html

User has cancelled the Invoice on 01-JUL-2017. We required to change the Cancelled Date to 30-JUN-2017. 

Please Note that Invoice has got no distributions and does not require any Accounting.

---------------------------------------

You can use following script to update the canceled_date. If Invoice has got no distributions and does not require any Accounting.

update ap_invoices_all
set cancelled_date = ''
where invoice_id = <invoice id >;