Doorgaan naar de website
OCLC Support

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 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'
Page ID
38404