Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Reconcile to GL

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi

 

Does anyone know how to reconcile an account to the GL in version 10.

Thank you

 

Pat

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Reconcile to GL

    GP12 is billed to have a Bank Rec to GL reconciliation tool along the lines of the existing AR/AP to GL reconciliation.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Reconcile to GL

    Hi Ian

     

    Would you know a quick way to find out:

    When you reconcile the bank to the GL and you are out, without have\ing to go through every transaction is there an easier way.I am trying to reconcile bank register to the GL.

    Any thoughts will help..

     

    Thank you very much.

     

    Pat

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Re: Re: Reconcile to GL

    Thanks for the update, Michael.

    Ian.

  • 789user Profile Picture
    789user 20 on at
    Re: Re: Re: Re: Re: Re: Reconcile to GL

    Folks...I ran into the very same issue.

    I looked at the GL and AR tables and compared that data to the Excel spreadsheet record by record (on a subset) and found that this routine does NOT always pick up all the data...even if there is an exact match in GL to AR or AP.

    I have a case going with Microsoft on this...and then... 

    ...MBS just released Dynamics GP 10 SP5 which has fixes that are supposed to address that deficiency.

    So...I am hoping that the "Reconcile to GL" Routine will now work accurately. (I am sure there are folks out there where it has worked fine, but MBS has acknowledged that this Routine through Dynamics GP 10 SP 4 is flawed.) 

    Best regards,

     Michael 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Reconcile to GL

    HiPatricia,

    Understood. Perhaps som one back posted an error into June or earlier. When you printed and reconciled in June...all was fine...but it is possible that afterwards someone posted a transaction back into June. It would be worth re-running June, May, April just to make sure nothing has changed... Also of course, a transaction could have been posted into August?

    Hope this helps.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Reconcile to GL

    Hi Ian

     

    I am running for the month of July I run and reconcile every month.

     

    thank you for your help.

     

    Pat

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Reconcile to GL

    Are you running the reconcile for just one particular time period? The reason for the imbalance may be in a period that youhave not included in the reconciliation date range.

    Best regards,

     

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Reconcile to GL

    Hi

     

    I am trying to reconcile the payables to the GL (vendors) I run the reconcile which goes to excel it gives me the possiblities of unmatched transactions and all matches but my payable total does not match my GL total.

    I hope this will help you to help me.

     

    Thank you very much

     

    pat

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Re: Re: Reconcile to GL

    There is also a third-party module called THE CLOSER

    http://www.ask.com/bar?q=the+closer+gp&page=1&qsrc=121&dm=all&ab=0&u=http%3A%2F%2Fwww.reporting-central.com%2F&sg=BgO8xBsfjb1xniW2i9Fbq43hWtJKeM5ew3cwBmEk5qM%3D&tsp=1269669718171

    It is very nice and does a lot more than the GP Routine. Of course, it costs extra too. Definitely worth consideration if you have inventory.

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Reconcile to GL

    Hi

     

    Thank you I will try that

     

    I appreciate your help

     

    Have a nice day!!!

     

    Pat

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans