Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / What tables does the R...
Microsoft Dynamics GP (Archived)

What tables does the Reconcile to GP report pull from

(0) ShareShare
ReportReport
Posted on by Pford 325

I had a batch that went to recovery.  We discovered that it did post and even posted to GL.

It caused duplicates in my PM tables.  So we had to delete from the work tables and all was looking good.

The transactions show in inquiry on AP and GL but they show as not matched on this recon report

Any idea

*This post is locked for comments

  • Laura Peters Profile Picture
    Laura Peters 505 on at
    RE: What tables does the Reconcile to GP report pull from

    What tables for Bank Rec?  Inventory is see30303

  • Pford Profile Picture
    Pford 325 on at
    RE: What tables does the Reconcile to GP report pull from

    Thanks for your help.  We found some posting flags that were not set to posted in the PM10100 and PM30600 tables.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: What tables does the Reconcile to GP report pull from

    Hi,

    As David Mason said for PM Reconcile to GL reports are pulled from the following tables

    PM Distribution Work/Open – PM10100

    PM Distribution History – PM30600

    in addition to that there are two more tables

    PM Transaction OPEN File – PM20000

    PM Paid Transaction History File – PM30200

    For GL it uses GL20000 table

    Regards,

    SantoshG

  • Suggested answer
    PGS Profile Picture
    PGS 1,130 on at
    RE: What tables does the Reconcile to GP report pull from

    Hello,

    I'm not 100% however I believe that the reconcile to GL only looks at the PM10100 or PM30600 on the PM side, GL20000 on the GL side

    David

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,489 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans