Invoice Number Update script, R12
Hi Community,
Can anyone help me with a script to update invoice number in R12.
User wants to cancel duplicate invoice R12. But when they tried to cancel the invoice, it doesnt allow to cancel.
Hence, I want to update invoice number for the accounted invoice. Also Please let me know what are the tables will be affected if I update invoice number to new invoice number in ap_invoices_all?
Appreciate if I am helped with datafix script.
Thanks.
Regards,
Karthik