Occasionally we get an Invoice that is missing the Batch No. from when it was created via Shipping Data Entry. We have multiple batches a day, usually separated out between EDI and Non-EDI orders and/or AM vs. PM shipments; totally anywhere between 2 - 5 batches. Shippers will enter their orders as they do every day and then once every 2-3 weeks or so, 1 invoice will not have a batch no. associated with that record in SO_InvoiceHeader. The Invoice can be for either an EDI shipment or a Non-EDI shipment. The shippers process the shipment without any errors, pop-ups, warnings, etc. so they aren't aware of any issues. The issue is found at the end of the day when the accounting department goes to post the batches, both EDI and Non-EDI. Sometimes they'll get an error that there is an issue with one invoice and I'll go into DFDM to enter the Batch No. Other times, they don't get any errors and we'll find the invoice that isn't assigned to a batch a day or two later when comparing to EDI and I'll go into DFDM under SO_InvoiceHeader and enter a Batch No.
I created an alert via Sage Alerts to email me when the Batch No. field is empty so I can try to quickly figure out what is happening at that time. Unfortunately nothing has come up as the reason 1 particular Invoice isn't assigned the Batch No. Users have PCs, no laptop, hardwired, no wi-fi, no performance issues, IT department has guaranteed me nothing is wrong with their network connections.
I'm at my wits end of trying to figure out what is causing this sporadic behavior.
We are on Sage 100c Advanced v2019.2 with True Commerce EDI and Scanco's Manufacturing module (I include this because our finished Work Tickets create their own SO Invoice Batches).
Anyone experience this and/or have any ideas of what is causing this?