Cancelled posted invoice by mistake need to reinstate as posted

QUESTION: An invoice was cancelled in error. Is there any way we can change the status of this invoice back to posted?

RESPONSE: The programmatic change of status for the invoice is dependent on many other factors like the creation of related GL operations and updates to detailed data fields across multiple tables rendering this type of project too costly and risky to undertake. The one-off program cannot capture all internal controls inherent in the application, when creating and posting an invoice, opening up the database to imbalances, potential reporting errors as well as functional ones on subsequent transactions affecting the invoice.

The most cost-effective and safest process to rectify the situation is for the user to re-do the invoice.  Please note that the new invoice will need to be dated with a date equal to the invoice cancellation date or more in the future to ensure the historical integrity of the database is not compromised.