Hi
Does anyone know how to reconcile an account to the GL in version 10.
Thank you
Pat
*This post is locked for comments
Hi
Does anyone know how to reconcile an account to the GL in version 10.
Thank you
Pat
*This post is locked for comments
GP12 is billed to have a Bank Rec to GL reconciliation tool along the lines of the existing AR/AP to GL reconciliation.
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
Thanks for the update, Michael.
Ian.
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
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.
Hi Ian
I am running for the month of July I run and reconcile every month.
thank you for your help.
Pat
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,
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
There is also a third-party module called THE CLOSER
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
Hi
Thank you I will try that
I appreciate your help
Have a nice day!!!
Pat
André Arnaud de Cal... 291,711 Super User 2024 Season 2
Martin Dráb 230,458 Most Valuable Professional
nmaenpaa 101,156