Sage 100

Has anyone ever had an SO batch partially post, leaving stranded invoices in Invoice Data Entry without a batch? I have and usually tell them to recreate the batch number and then verify the invoices are in it. Well, today, I told this customer the same thing and there were eight out of nine invoices in it which they posted. This customer keeps the paperwork and was checking things against the sales journal and this invoice was not on any sales journal BUT is in the customer's account under a different sales journal number. Long story short, I don't think this invoice actually hit the GL - their AR Trial Balance is off by it. One, how could this happen? And two, fortunately it is only one invoice but seriously? I have to figure out the posting? It's a $15K+ invoice with many lines. Yes, I can do a Crystal report for it but I would like to have SOME explanation for the customer. And yes, the GL is in balance. Thoughts??

Did the Sales Journal that it posted with, have a posting date more recent than the AR Trial Balance date? If you run the Daily Transaction Register from GL-> Main -> DTR, are there any unposted transactions? If so, is this ""different Sales Journal"" among the entries?

I checked the GL DTR and it is empty and no, the journal number is from Friday. I did the AR TB through 12/31/2018. The odd thing is, while the invoice history drill down shows the SO journal number, this invoice is not on it and it appears to only include postings for the invoices that are actually on it. I checked all other sales journals and it is not on any of them (since Thursday at least).

That is odd. Can you run a ""GL Detail by Source Report, include the Sales Journal number, and run it for ALL dates to see if there are two journals with the same number but different dates? Maybe even a Null date?

Good suggestion @ChrisStAmand but no such luck. Only the one updated 2/15.

I gave it a shot. So assuming it posted to inventory, you could make a copy of company data to a test company and probably re-create the invoice in a batch all by itself to get the resulting DTR. Otherwise, fun times figuring out the posting.

I just created a Crystal report and it wasn't all that hard. The only variable was the inventory account but fortunately, they all came out of one inventory GL account!

@ThereseLogeais I've seen this a couple of times unfortunately, both times it was caused by a network error during the posting & it basically only partially posted. I had to go through all of the AR history tables & found that it posted to only half of the tables it should have hit & didn't hit the GL. It was a mess. Like you, not super huge, so not hard to clean up, but not okay to be happening either.