Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

AP not posting to Ledger, ledger not updating Management Reporter

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

It appears my AP module is not interfacing with my ledger, and my ledger is not interfacing with my management reporter software.  I think it has been going on for over a month.

We are cutting checks, and my IT guy can find the transactions in the AP history, but they are not in the GL.

Also, entries that are being made in the GL are not showing up in the P&L.  I can see the entries in the GL Detail within GP, but when I run the P&L in Management Reporter it does not change - like it is pointed to some static version of the database that existed a month ago.

Anyone have any ideas what went wrong, and how to fix?  

*This post is locked for comments

  • Frank_Heslin Profile Picture
    Frank_Heslin 895 on at
    RE: AP not posting to Ledger, ledger not updating Management Reporter

    Good to hear!

    If you can provide a screen shot of your report setup & the column definition it may provide some clues.

    If the datamart isn't being updated, then the next step is to rebuild the datamart.  If needed I can provide links to step-by-step instructions.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AP not posting to Ledger, ledger not updating Management Reporter

    Thanks Frank, that was the problem.  We turned on some purchasing approvals, and when we did it seems that the transactions stopped automatically posting to the GL.  Just found about 500 transactions that need to be posted.  Also found the series posting to do it at once.  And they go to the correct periods which was my biggest concern.

    As to the Management reporter issues, my IT guy seems to think some data mart isn't being updated?

    Thanks again for the help.

  • Frank_Heslin Profile Picture
    Frank_Heslin 895 on at
    RE: AP not posting to Ledger, ledger not updating Management Reporter

    One thing at a time:

    Is your AP setup to Post To or Post Through to the GL?

    If it's Post To, then you still have to go to the GL & post the batches.

    The check batches will  start with PMCHK on the GL side.

    Are there batches sitting in your GL that need to be posted?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans