Invoice Numbers Missing II
Description of the Issue:
Client reported gaps in their invoicing.
It goes 9219 → 9226 → 9232
This was reported by multiple clients in the past. The reasons seem to vary though.
For example here:
https://documentus.zendesk.com/hc/en-us/community/posts/37526988136983-Invoice-numbers-missing?input_string=Missing%20Invoice%20Numbers
..a Trigger was responsible.
Ryans Feedback on where to check:
“Place to check is the ZZ401_INVOICE_AUDIT table which should track the error received when generating that invoice.”
…and also this article https://supportcenter.ungerboeck.com/hc/en-us/articles/204553518-Recording-Used-Invoice-Numbers
But as @... suggested there, we should maybe better the documentation in the Knowledge Base as I also recall this to happen regularly.
I also checked for the Invoice Audit but could not find it.
Client.
Koblenz_PROD_0446688743
Version:
25.42026020501
zendesk:
#379544
-
Has anyone a feedback for me on how to proceed here / any possible actions.
-
Based off Ryan's last response, can you check whether there were any errors in the invoice audit table? Perhaps this customer also had a custom trigger that caused it to not commit the number to the database.
-
I'm working on updates. https://supportcenter.ungerboeck.com/hc/en-us/articles/204553518-Recording-Used-Invoice-Numbers seems to not apply - I couldn't follow the steps and on looking, the article is at least 10 years old. I'm confirming with Chai and Ryan but will most likely archive it.
Based on Ryan's comment in the other missing invoice number post I've got this drafted and out for review: https://supportcenter.ungerboeck.com/hc/en-us/articles/38618280787095-Find-Missing-Invoice-Numbers
Let me know if I should also mention that custom triggers can cause issues (timing out before invoice can be added).
-
Thanks @...
Nicole Loh I was able to locate errors in the audit table for the problematic invoices here. Currently checking with the client as it seems the issue is rooted in changes they made. -
As we were able to find the error:
"Message - Invalid column name 'ER205_EVENT_ID'."
…for all affected Invoices.
Do you have any idea how we can help the client here or is this something the client needs to figure out as they have done changes which lead to this outcome?
They are asking if we have the Event ID's but as of my knowledge we don't. We just have the error.
Nicole Loh -
Ryan Ungerboeck do you maybe have an idea or even knowledge of former cases here.
I could share Documentation because of the Invoice Audit Log but what exactly is the right or even legally appropriate way to deal with this? -
If the invoices are in the invoice audit table - I'd say we don't have missing invoices. Each invoice has an explanation for failure in ZZ401 and is thus accounted for.
This should enable any auditor to achieve the completeness assertion by providing them this list of failed invoices.
-
I agree. This is also how I sold it to the client.
Please sign in to leave a comment.
Comments
9 comments
Date Votes