Hi Laccpac,

Since your post relates directly to Sage 300 ERP, I am going to move your question to that Support Group so that other users of this program will see it and be able to offer their thoughts and insight.

Thanks,

Derek

Run the A/R Trial Balance report, cutoff by period.

Hi Jay. thanks for your reply. Appreciate it!

A/R trial balance report is the total for sub-ledger?

and where can I get the total for General Ledger?

Thanks!

L

thanks Derek! I also new to this site...

GL Reports

Trial Balance

thanks a lot Jay!

This solution applies to most versions of most software, and to Sage 300, and Ptree 50, too.

Post all o/s AR transaction to AR, and to GL.

Then run the [AR TB], and the [GL TB for the AR control account] at the END of the furthest period open in your system. If reports agree here AND agree at current period, then no problem.

If a difference in totals, run both reports for EACH period back until no difference; note each difference, or a change in the difference.
[If many periods involved, skip by 6 periods, until localize those periods of error.]

** Problems will be found in each period where the difference in totals changes. **
Diff s/be 0 at all times that all trans are posted.

If you need more help than this, you need a competent consultant to either fix directly, or to train you on how to do it.
I've even written out instructions for my clients.

Glad you noticed the problem, as many users do not even know there is a problem until their auditors scream!
Those without auditors might blindly report incorrect financials for years.
Good luck.

Thanks George! really appreciate your nice instruction!