Notifications
Announcements
No record found.
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
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.
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.
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...
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
Sorry, I had it backwards. 1 = queued for invoice print
Ok.
Thanks!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
