Marking Invoices 'Ready for Export'

Occasionally you might need to [re-] mark an invoice as ready for export. An export may have failed (but is marked as successful) or the destination system failed to load correctly.

UPDATE Invoice SET Exported = 0, ApprovalStatus = 0 -- Optionally also [, DateExported = null, ExportIdentifier = null] WHERE InvoiceId = xxx -- or whatever other WHERE clause you like