Microsoft Dynamics GP (Archived)

AP Aging does not match AP GL

(0) Share

Report

Posted on by Community Member

AP Aging does not match AP GL. I have GP10. Everything was reconciled for 2016 and periods locked. Now, I have an unreconciled balance between the sub-ledger and the ledger. I went to Reconcile to GL but nothing there. The report is the same report as was on December when I reconciled 2016. Help! Any thoughts!

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

L Vail 65,271 on at

Like (0)

Report
Copy link

Link copied!

When you run the Reconcile to GL routine, make sure your beginning balance reconciles. If the error didn't happen within the date period you choose, you will not get any results in the spreadsheet. Somebody could have posted something to history making the error roll forward.

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

Thank you for responding back to me. I've been working with GP for less than a year now. The beginning balance never reconciles. non a single month. However,every month everything matched. I did all my financials as of Deceber 2016. I was working on some revenue issues and I went back an look and from June-2016 to December the AP balance is different. I have everything printed and now shows another balance on the GL transactions and another balance on the payable transactions. I have no idea. I checked everything.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report
Copy link

Link copied!

Awilda,

If everything is posted, and you've included all of the GL accounts, the subsidiary trial balance should match the GL every time. Be sure you are using the GL Posted date when running your Historical Aged Trial Balance report. To find differences, you need to find a time when it matched. You stated that it never matched, it must have at some point. Maybe you'll need to go back to the beginning and include a very large period in the GL reconciliation routine. Comparing the two ledgers is the only way that I know of to identify the differences.

Kind regards,

Leslie

Was this reply helpful? Yes No
Heather Roggeveen 9,150 on at

Like (0)

Report
Copy link

Link copied!

Also another point to note. I have seen it relatively often - and usually in older sites - where something in history ends up with a missing apply record - resulting in a very old record appearing on the ATB that wasn't there before. So if the ATB has changed, this could be a factor. Printing a detailed ATB may give you some clues.

If I am reading your post right - the ATB itself has not changed - is that correct? Just the GL balances have changed?

If so, then also look for a transaction that has been posted into the GL that did not have a series Purchasing. I have many times seen where a journal has been posted to a control account.

Was this reply helpful? Yes No