Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)
Posted on by Microsoft Employee

What would cause the GL not to be updated with PO receivals when the receivals posting journal clearly shows the audit trail code and all GL batches have been posted out?  

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GL

    Try unchecking the Post To box and checking the Post Through box, click Save and then pull the settings back up again and check the Post To box and uncheck the Post Through box and click Save. I would be concerned about how many lost postings have occurred. Do you have any idea how long this may have been occurring? Do you have a test company? Do you see the corresponding vendor invoices appear in the AP trial balance? Does you AP TB balance equal your GL AP balance?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GL

    The Post Through GL box is unchecked. The accounts that were distributed to at the Receiving stage are not showing these transactions in the GL.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GL

    Is the Post Through GL box also checked? If it is the batch will get posted all the through the ledger and you will not see it. Can you see the results of the posting in your GL?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GL

    No. There are no batches in Batch Recovery.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: GL

    That shouldn't cause what you're seeing Rogger.  Have you checked to see if there are any batches in Batch Recovery?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GL

    The post to GL box is checked. On closer scrunity, i noticed that the matched/invoiced method was used instead of received then invoiced. Could this be the problem?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GL

    Also, make sure no one is deleteing these PO batches before they get posted. In Posting->Posting make sure the Post to GL box is checked otherwise batches would not even go down to the ledger.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: GL

    Is the posting setting set to Post to or Post through for those transactions?  Also, are inventory batches being created for the PO Receipts?  There is a flag in the batch header for inventory batches called Post to General Ledger.  This must be checked or, when the batch is posted, it will update inventory but not GL.

    Start there.

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans