How can I move invoices from the print queue?

Symptom

• How can I move invoices from the print queue

Applies to

• ILLiad

Resolution

This requires a 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'

Page ID