Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Historical Aged Trial ...

Historical Aged Trial Balance Current Period posting balancing to GL

(0) Share

Report

Posted on by Community Member

Hello, I'm super new to Dynamics GP, I've been using it at my new accounts payable job for about 2 months but so far this has seemed like a really helpful community for all of the dumb questions and roadblocks I encounter.

I'm trying to match the current period total in the historical aged trial balance of the sub ledger, to the net change in the GL trial balance and I've ran into a few discrepancies. One that I haven't been able to figure out is why only part of some of my manual payments get added to the current period subtotal. It seems that its all the invoices the payment covers that are not included in the current month I am analyzing. Does this get balanced out elsewhere? Am I looking for discrepancies in the wrong place? If a screenshot is necessary I may be able to whip something up.

Any input appreciated, thanks!

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

L Vail 65,271 on at

Like (0)

Report

RE: Historical Aged Trial Balance Current Period posting balancing to GL

Hi,

In my opinion, the best way to approach a reconciliation between your subledger and your general ledger is to use the Reconcile to GL routine in the Financial module. The routine produces an Excel spreadsheet that identifies any discrepancies between the two ledgers.

Kind regards,

Leslie