web
You’re offline. This is a read only version of the page.
close
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) / Reconciling payables t...
Microsoft Dynamics GP (Archived)

Reconciling payables to GL

(0) ShareShare
ReportReport
Posted on by J Smith 300

Hi. I am having a problem with my totals when reconciling the payables to GL. When I run the report say from 09/01/11 - 09/29/11, I get the totals at the bottom that say this:

PM End Bal: 227,950.45

GL End Bal: 76,430.80

Difference: 151,519.65

I know the difference is supposed to be zero and that is what I am trying to look for, however that is not my question. My question is that when I go and look at my 2030-1 (payables account #) in financial the number equals the GL End Bal of 76,430.80. But when I run a trail balance for AP, the balance is 230,837.45. Shouldn't the amount on the bottom of the AP trial balance be the same as the PM End Bal? Am I not looking in the right spot for this info, or are there gremlins in my accounting software?

This is also the case with my AR.

Thank you for any help you can give me :)

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi,

    In theory, yes they should be the same, but there are reasons why they could be different.

    You might have posted a GL Journal directly to your 2030-1 account. Since Payables knows nothing about this journal (because it was entered directly in GL) - its going to be a reconciling item.

    Similarly if you posted a Payables Invoice, but for some reason deleted the GL journal it created instead of posting it - then thats a reconciling item too.

    In GP there is a reconcile feature that reconciles your GL to your PM (and your AR to your GL too).

    Tools >> Routines >>Financial >> reconcile to GL.

    This exports an XL spreadsheet which matches transactions common to both...and highlights transactions that are in one and not in the other.

    Best to run this for all dates the first time you run it - the difference could be in a prior period.

    Post again if it throws up anything you don't understand.

    Ian.

  • J Smith Profile Picture
    J Smith 300 on at

    Hi Ian I appreciate your help however I don't think I explained my question well enough.  I will try again.

    I am using: Tools >> Routines >> Financial >> Reconcile to GL.

    At the bottom of the excel file it prepares it says this:

    **PM End Bal: 227,950.45

    GL End Bal: 76,430.80

    Difference: 151,519.65

    However, when I run an AP trial balance, the total balance owed at the bottom says 230,837.45, not the 227,950.45** from the excel file, which is a difference of 2,887. How can this be? Shouldn't the excel file and the trial balance match?

  • Community Member Profile Picture
    Community Member on at

    Ah! sorry - I should read posts more carefully.

    Have you tried running the reconciliation well into the future?

    Could be a transaction with a funny PM date.

    Which PM TB are you running? Is it the Historical TB? Try different TB reports - and make sure you're running an unmodified version.

    Ian.

  • J Smith Profile Picture
    J Smith 300 on at

    I just ran both reports well into the future (12/31/2999 lol) and no change in the totals.  Do you think it could have something to do with the tables?  The AR totals are also off 94.00.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    It could also be the Report Options that you have checked in the aging reports.  Run the Historical Aging and make sure you set 'Select Transactions for Report Using: is set to GL Posting Date.  Also make sure all boxes in the Exclude section are checked EXCEPT for Credit Balance.

    Hope this helps,

  • J Smith Profile Picture
    J Smith 300 on at

    Hmm, did exactly as you said and still the same.  We have our professional acct software people coming in to see us in a couple weeks, I can ask her then.  Maybe she can figure it out when she sees it.  The thing is, we have had problems with our tables before - such as I cannot change a customers account number because it says there already is something named that, even though there is not.  I have even had a customer's account completly disappear from the system before.  They sent in their payment, and I could find the invoice fine but there was no account attached to it - it was so weird.  So we had to call our service and they remotly went in and found it was something in the tables and they fixed it. We just switched the vendor that we use for our professional help because of problems with our last service. I wonder if it's possible that they didn't really know what they were doing?

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    Do you have any very old payables or receibables?

    The reports will drop any open payable or receivable that is older than 999 days.

  • J Smith Profile Picture
    J Smith 300 on at

    I don't think so, but I suppose it's possible.  I have only been here 3 years.  How would I go about looking for something like that?

  • Amanda Oertel Profile Picture
    Amanda Oertel on at

    Have you found a resolution for this? I am having the same issue with one of my customers. The Reconcile To GL routines shows that the AP Subledger and GL match, however if I compare the HATB report to the GL, I am off by about $70.

    I tried running Reconcile which looked to have made a few changes but did not change the Reconcile to GL or the aging report.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans