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) / A/P subledger does not...
Microsoft Dynamics GP (Archived)

A/P subledger does not tie to the GL

(0) ShareShare
ReportReport
Posted on by AWhalen 215

Our A/P subledger is not tying to the GL.  I am fairly sure it has something to do with how invoices are matched to purchase order receipts, and creating a large balance in the unvouchered PO receipts account.  We use landed costs for freight and duty charges.  The freight invoices typically are paid before the purchase order receipt is posted.  

Also, the received/not invoiced report shows POs that have been fully matched and closed.  Is it possible that some part of the landed cost is causing this to continue to show that the qty shipped and qty matched are not matching?

Thanks in advance!

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: A/P subledger does not tie to the GL

    The 'posting date' is the date the transaction affected the General Ledger. The Posted Date is the System date when the user pushed the [Post] button when the doc was originally posted. These can be very different dates. I did a blog post on the different date fields in certain AP tables with an explanation of what they meant.

    You might want to take a look at it. There are many dates in those files. The article can be found here: dynamicsconfessions.blogspot.com/.../whats-in-date-pm-transactions.html

    You can also print your AP trial balance according to the Posting Date (GL Date) instead of the transaction/document date.  Have you tried printing the AP trial balance using this option?

    Kind regards,

    leslie

  • AWhalen Profile Picture
    AWhalen 215 on at
    RE: A/P subledger does not tie to the GL

    What about if an AP batch gets hung up in batch recovery?  For example, if a batch for January gets hung up, but isn't posted until March would this cause a variance?

  • AWhalen Profile Picture
    AWhalen 215 on at
    RE: A/P subledger does not tie to the GL

    Jonathan,

    After further research, I have found that the variance I have is due to the posting date being in a different period than the posted date.  Would you happen to have any insight into this?  

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: A/P subledger does not tie to the GL

    Any update on the resolution? This is a post that is getting a large number of views so we would like to get a confirmed resolution.

  • AWhalen Profile Picture
    AWhalen 215 on at
    RE: A/P subledger does not tie to the GL

    I ran the reconcile to GL, and there are a lot of unmatched transactions.  There is also a large variance in the potential matched transactions.  This has not been reconciled on a regular basis so I am having to do a lot of clean up.  Any suggestions you might have is appreciated.

    Thank you.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: A/P subledger does not tie to the GL

    Mr. Whalen

    I am not sure we have a common background, I am afraid I am not being able to completely direct you to the correct tool. I highly recommend reviewing the tutorial provided on the link below on how to run Reconcile to GL and how to check the results on the report.

    Reconcile to GL in Dynamics GP

    Your feedback is highly appreciated, 

  • AWhalen Profile Picture
    AWhalen 215 on at
    RE: A/P subledger does not tie to the GL

    I was able to run the reconciliation.  I also ran the purchase order reconciliation report, and found a lot of "errors".  I am not sure what exactly these errors mean.  Is this process necessary for the subledger to tie to the GL?

    Thanks!

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: A/P subledger does not tie to the GL

    Before processing the reconciliation, you are supposed to specify the path of the file, at the end of the process the system will generate the reconciliation results on a predefined  Excel template to categorize your AP transactions upon three main categories, Unmatched, Potentially matched and Matched Transactions

  • AWhalen Profile Picture
    AWhalen 215 on at
    RE: A/P subledger does not tie to the GL

    This is the first time I have run this in GP.  Is there a report that I can view?  I hit "process" and didn't see any output.  

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: A/P subledger does not tie to the GL

    AP Reconciliation is something different related to matching master balances against transactions amounts.

    In case the window is not available in your Dynamics GP, keep us updated to provide an AP-GL reconciliation script.

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,307 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans