Featured Post

Dynamics GP 2016 R2 is Now Available .. and #MSDynGP will Always be Avilable

The Microsoft Dynamics GP team announced today that Microsoft Dynamics GP 2016 R2 has released . Dynamics GP 2016 R2 continues the grea...

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.

image

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.

Checkbook

 

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