Student Financials - Cancel Invoice That is Out of Sequence
Hello
Campus has an issue with Student Financials > Bill Customers > Cancel Invoice. Invoices created with Billing Request #29 had some errors, and they need to be cancelled using the Cancel Invoice process on #29. However, before the cancel could take place, staff ran Invoices with Billing Request #30 after that. So now only #30 is available to select in the Cancel Invoice (and we don't want to cancel that successful run since only the #29 had an error).
The campus would like to avoid cancelling #30 since the information already went out to a third party system.
Question: Is there SQL to run to cancel the invoice #29 (so that it can be run again, this time to success)?