- How can I move invoices from the print queue?
This requires and SQL Managment studio query. Hosted sites, please contact OCLC Support. Self-hosted sites will need to run the script below:
--select script should show the 540 invoices select * from billing where processed = 'PRI' and invoicedate > '6/16/2021' --update script to revert the status, rows affected should be same as select script 540 update billing set processed = 'No', invoicedate = NULL where processed = 'PRI' and invoicedate > '6/16/2021'