While it was initially the AR/GL discrepancy that got my attention, it is not a Credit Note to GL problem. The problem is with the AR Aged Trial Balance. And while I appreciate the advice given very much, the issue remains unsolved.

What we have found is the failure of some credit notes to appear on the Aged Trial Balance even though they are correct in the customer's account and in the control account. This happens almost every month without a pattern that we have so far been able to discern. It does not appear date related. Our credit note numbers are auto generated in OE and do have the CN designation.

I am wondering if this problem is somehow related to the invoice to which the credit note is associated or to how the credit is handled as a cash application. This is now the thrust of my investigation.

We have been doing this reconciliation for many years (Accpac Plus) and have resolved various discrepancies. This started happening shortly after we began using Adagio and to date it is apparently a mystery to all. Of course, if the subledger report is not functioning properly, this would explain it. But it is most likely something we are doing and I would very much like to know so we can correct it. I hate to think of this as our new month end reality. If you can offer any suggestions, I would really appreciate it.

Regards
Jody