I am looking to reconcile Cashbook transactions against the General Ledger. I am having trouble finding tables that hold cashbook posted transactions distributions for Bank Transfers, Cash Receipts and Deposits. Also it seems historical cashbook transactions distributions are held in a separate table, is this correct?
I would appreciate your insight .Many Thanks,
The Best thing in Life is Life
Of course, the definite easy solution is to upgrade to Dynamics GP 2013 in which a new feature was introduced to reconcile checkbook to General Ledger, it provides a detailed report for the matched, unmatched and potentially matched transactions.
If that was not a solution, digging in the database for associated checkbook transaction would be quite difficult since the CM is related to payable and receivable. I have worked previously on a similar project to reconcile CM to GL in an environment which doesn't have the reconcile utility, here is the script that were developed:
If this resolves your issue, please feel free to close the case
Your feedback is highly appreciated,
Mahmoud M. AlSaadi
Dynamics GP Essentials | mahmoudsaadi.blogspot.com
Can you confirm if you are using the "Cashbook Bank Management" module, or the "Bank Reconciliation" module?
Hi Mahmoud, thank you for your response. I have looked at your scripts. The transactions I am looking at are sitting in CB tables not CM.
Hi Justin,Thanks for response, It's the 'Cashbook Bank Management' Module.