Missing invoices

Joppe Borsboom

July 24, 2026 15:19

Zendesk Ticket: #385923
Account: PAU
Region: EMEA
Articles used in your research: Find Missing Invoice Numbers
 
General
Business impact if not resolved: For French tax regulations, the FEC file (Accounting Entry File) must reflect the recording of sales invoices in perfect chronological order.
Short Summary of issue (issue description): Customer noticed some missing invoice numbers. In ZZ401_INVOICE_AUDIT table, we found 50+ numbers missing in January and February of this year. They all threw the same error. Is this due to bad data, or is this a bug?
Macro Vertical: Convention Centers
 
Debug Environment:
Customer DB Location: Hosted
Database: PAU_PROD_0578340275_USI
Server: Debug-EMEA,1433
Version: 26.22026071301
V30 Link: https://supportwebemea.ungerboeck.com/PAU_PROD
User Login: USIADMIN / ITRocks2014
 
Recreation Steps: 

1. On debug, open SQL Server Management Studio
2. Connect to Debug-EMEA,1433
3. Expand Databases and run a New Query on PAU_PROD_0578340275_USI
4. Paste the query and Execute:
   SELECT * FROM ZZ401_INVOICE_AUDIT
LEFT OUTER JOIN AR030_INVOICE_REGISTER ON ZZ401_INVOICE_NBR = AR030_INVOICE_REGISTER.AR030_INVOICE AND ZZ401_ORG_CODE = AR030_INVOICE_REGISTER.AR030_ORG_CODE
   WHERE AR030_ORG_CODE IS NULL
5. Notice that in January and February, there were a lot of invoices missed with the error:
   System.Exception:  Index # 0 Class - 16 LineNumber - 1 Message - Invalid column name 'ER205_EVENT_ID'. Number  - 207 Procedure  -  Server  - Sagan.usi-euvpc.com,1642 Source  - .Net SqlClient Data Provider State   - 1  Index # 1 Class - 16 LineNumber - 1 M

What does the client want to accomplish: They would like to understand why these invoice numbers were missed.
 
Attachments:

• Official comment

  

  Ryan Ungerboeck

  July 24, 2026 16:51

  When any error is encountered in the invoicing process - the details of the error are saved off to the invoice audit table to avoid skipping the invoice outright - thus the invoice numbers are not missing but marked essentially as voided/cancelled
  
  This was a fix for FIN-8276 related to invoicing credit notes that was resolved earlier in the year.  
  
  https://ungerboeck.atlassian.net/browse/FIN-8276
   
• 

  Joppe Borsboom

  July 24, 2026 15:19

  Ryan Ungerboeck, Pieter Fourie, Mike Schepker, Satya Ram Nukala 

Please sign in to leave a comment.