I have read all of the questions on here about the reconciliation of the A/R Trial balance to the GL Trial balance.
I have run countless reports, and excel files trying to find the differences.
Things I know: There are zero postings to the A/R GL account from anything other than the A/R sub ledger. No adjustments, and no reverse batches.
I ran the report all the way out to end of 2018 and I'm still out of balance so it doesn't look like an aging issue.
Invoice from sales statistics add up in the GL and in the A/R trial balance, so it is not an issue with invoices. I can't get credits to balance so I am leaning towards an issue with the way credits and or applying them are done. Tracing down the payments is a much harder task than invoices.
Any other ideas on reports to run, or where to look? This is a consitent issue so I'm wondering if its something ingerent in the software set up.. We are only 2 years in to using Sage 300.
Thank you!