Share
ReportIs there a way to find invoices that have not printed due to system issues, interruptions, etc. via a query or report?
*This post is locked for comments
You’re offline. This is a read only version of the page.
Is there a way to find invoices that have not printed due to system issues, interruptions, etc. via a query or report?
*This post is locked for comments
Ok.
Thanks!
Mark
Thanks for the response above.
When I run a query on this table all my records have "0" in the InvcPrint field and I know OM invoices have been printed.
Chuck
Depends on what type of Invoice you are asking about. If it is an AR Invoice, nothing in the DB will tell you if it has been printed or not. If it is an OM Invoice, the "InvcPrint" field in the SOShipHeader table will indicate "1" if it has been printed, "0" if it has not.
Of course, if SL sent the print job to the printer, and there were outside agencies (printer errors, network issues, etc.) that prevented the job from physically printing, SL will not know of or track the failure...
Ok. I was hoping there was a SQL query my client could run once a week to see if any invoices didn't print.
Thanks.
Chuck,
We may need some further definition by what you mean here. SL does not record anything within a document indicating that it has been "printed" so if you actually mean not printed then I believe the answer is no.
All responses (
Answers (
6,451