Marking Invoices 'Ready for Export'

Created by Jeremy Burgess, Modified on Tue, 2 Nov, 2021 at 9:19 AM by Jeremy Burgess

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