Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

What can I fix a problem with an invoice payment applied to AR but it didn't reach to GL

Posted on by Microsoft Employee

Hi There, I posted a few invoice payments to AR and reconciliated the bank statement. Now, I just noticed that the invoice payments didn't reach to GL and AR Aging. What can I do to fix the problem? Thank you in advance for your suggestions.

*This post is locked for comments

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: What can I fix a problem with an invoice payment applied to AR but it didn't reach to GL

    Dora, if the transactions posted to the GL but they don't show in Account Inquiry my first question would be, are we sure they posted to the correct account and in the correct period/year?  The fact that you can't find posted transactions in either AR or GL really leads me to suspect that either they didn't actually post (most likely scenario) or that they were subesequently deleted from the database (not so likely).  

    If you haven't yet, I would check Batch Recovery to see if the transactions are sitting there, unposted.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: What can I fix a problem with an invoice payment applied to AR but it didn't reach to GL

    Thank you, Frank again for your help.  I just did more researches and found the payments were applied correctly in AR and posted all the way to GL but they just don't show up in the GL acccounts and AR Aging.  How can I fix them?  Thanks.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: What can I fix a problem with an invoice payment applied to AR but it didn't reach to GL

    Is there a resulting GL batch that needs to be posted?  Were the payments applied to specific invoices or left unapplied?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: What can I fix a problem with an invoice payment applied to AR but it didn't reach to GL

    Thank you, Frank. The payment batch was posted and I did finish the bank reconciliation for the period.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: What can I fix a problem with an invoice payment applied to AR but it didn't reach to GL

    Are the payments sitting in an unposted batch?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans