Good afternoon, all! I hope that you are doing well and avoiding COVID-19.
My client has an AR Batch that shows as Unposted in GL. They tell me that the batch released in AR without issue, but when they attempt to post in GL they receive an "Out of Balance" error.
In SQL I looked at the Batch and GLTran records, and it is indeed out of balance. Stepping back a bit more and looking at ARTran, I found that a good number of the records did not release and are are still in the table with a Rlsed = 0 status.
My question is twofold:
1. Any idea on how this would happen?
2. How to go about fixing this? my initial thought was to change the batch to "S" status and release it again, but I'm not sure how that would affect the records already in GLTran.
Any help, as always, is greatly appreciated.
Stuart Nottingham
