web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Reconciling AP Aging t...
Microsoft Dynamics GP (Archived)

Reconciling AP Aging to GL

(0) ShareShare
ReportReport
Posted on by D. Reiter 495

Hello,

Our AP Aging has a different balance the our GL. I found alot of involved material online about how to identify the cause of the difference, but in my case, I already know the invoice/check that caused the difference... I'm just looking for the best way to fix it.

We were printing a check, and for some reason there was an issue and the entry went into Batch Recovery. A team member deleted the batch, when it should have been posted. Now our AP Aging is $2,200 higher than the GL (the amount of that invoice/check). What's the best quick fix?

Thank you.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,623 Super User 2025 Season 2 on at
    RE: Reconciling AP Aging to GL

    Was it a GL journal batch that was deleted?  If so, post a JE to correct it, documenting why the JE was necessary.

  • D. Reiter Profile Picture
    D. Reiter 495 on at
    RE: Reconciling AP Aging to GL

    I believe it was GL. What would the entry be? Wouldn't an entry between AP and Cash cause issues?

  • Verified answer
    D. Reiter Profile Picture
    D. Reiter 495 on at
    RE: Reconciling AP Aging to GL

    I figured it out. The original invoice was posted to a closed AP account. The entry went into Batch Recovery and then was erroneously deleted, rather than fixed. However, the invoice still posted, just without a distribution going through. I corrected the issue by debiting the appropriate expense account and crediting the correct AP account.

    Thank you.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Reconciling AP Aging to GL

    Although this post is closed and figured out, but to consider one thing on the long run.

    If you are not on GP2013, then you might not have the reconcile to GL utility which shows all the transactions between AP and GL categories as (Matched, Not Matched and potentially matched), you may consider the following script, for AP-GL reconciliation,

    SQL Script for AP-GL Reconciliation

  • D. Reiter Profile Picture
    D. Reiter 495 on at
    RE: Reconciling AP Aging to GL

    We are on GP 2010. Is anything else required?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans