Featured Post

Five Years for Dynamics GP Essentials - Which gives birth to Another Blog of Mine

Blogging and giving to the Dynamics Communities has always been my passion, it's been almost 5 years since I started writing and cont...

Wednesday, April 23, 2014

Checkbook Setup – Important Assignment Concept


In a previous checkbook- General Ledger reconciliation with one of the clients where no Reconcile to GL tool is available (GP 10.0),the checkbook balance doesn’t tie to the Cash account balance.


Troubleshooting Checklist

Fortunately, non of the above was the case as all the transactions were entered correctly. Although, there is a variance between the Checkbook and General Ledger !

It just happened that several checkbooks are assigned to one General Ledger Account, which makes it impossible for the current checkbook balances and current cash balance to tie.

The bottom line is, it is highly recommended to have one-to one assignment type checkbook management, in which only one Checkbook is assigned to one General Ledger account.



This brings us to an essential point, reconciling checkbooks versus general ledger for Dynamics GP prior to GP 2013 (Checkbook Reconcile to GL Tool) could be a suffering sometimes. Therefore; in the next post, T SQL query will be provided to match the current Checkbook balance versus General Ledger balance and categorize results as Matched, Un Matched and Potentially Matched transactions.


Best Regards,
Mahmoud M. AlSaadi

No comments:

Post a Comment