With the release of Dynamics GP 2016 R2 comes a great new feature that will help the customers that use Bank Reconciliation heavily, or have been using Dynamics GP with Bank Reconciliation for a long time.  The new feature is the addition of the Reconciled Transaction Maintenance process!  The goal for this additional routine for Bank Reconciliation will be increased performance for various Bank Reconciliation processes after moving the bulk of Reconciled Transactions to History.

This new window will allow uses to move transactions that have been Reconciled in the Reconcile Bank Statement window to the newly created History tables for Bank Reconciliation.  The link for the newly created window can be found under the Financial Routines Navigation Pane in Dynamics GP 2016 R2, and will be labeled as Reconciled Transaction Maintenance.  Users can also go to Microsoft Dynamics GP | Tools | Routines | Financial | Reconciled Transaction Maintenance to get to the window as well.

As shown in the screenshot above, users will be able to either process all Checkbooks, or select a range of Checkbooks using the familiar From and To fields found throughout Dynamics GP.  The other options in the window will allow users to customize exactly what they would like to see move to History, including Transaction Type checkboxes, as well as a Cut Off Date field.  When marked, the Transaction Type checkboxes will then be included in the move to History process.

There is also a Print Register checkbox, which will allow users to choose if they would like to see the Reconciled Transaction History Register report, which will show what transactions have moved to History.  If your system has been using Bank Reconciliation heavily, this report can be quite large the first time that you run this process.

In addition to this new feature comes the addition of two new tables in the Company database for Dynamics GP.  The CM30200 (CM Transaction History) will hold the same information as the CM20200 table, except for this information will have been processed through the Reconciled Transaction Maintenance window.

The CM30300 (CM Receipt History) table will hold the Receipt information associated with Deposits that had their Receipts marked off in their initial entry, that have also been moved to History.  Voided Receipts will also be held in this table, such as voided Cash Receipts from Receivables Management.


Two important notes for this new feature:

Transactions that have been entered in Bank Reconciliation will not be available to be voided once they have been moved to History using the Reconciled Transaction Maintenance window.  You will want to ensure that the transactions have been processed and can be moved to History, without the need to void the entry, as they will not be available when using the Void Transaction option in Bank Reconciliation.

Secondly, if you have a lot of transactions in your checkbooks, you will want to utilize a Date Range in the Checkbook Register Inquiry window when attempting to view entries within your larger checkbooks.  If you enter a date range into the From and To fields before selecting the Checkbook ID, the transactions will display very quickly.  This might not be the case if you select the Checkbook ID first.

NOTE: If you recently upgraded to Microsoft Dynamics GP 2016 or Microsoft Dynamics GP 2018 from Dynamics GP 2013, you may notice items are slow when you select a document number in the inquiry window.  If you do Select * from CM30200 and you have Zero records, you need to look at doing what this blog indicates as it will help with slow performance.  It will move records from the CM20200 to the CM30200 for you.

Click HERE for more detailed documentation for Dynamics GP 2016 R2 features.
Dynamics GP 2016 R2 feature VIDEO click HERE!

Be sure to check back to the Microsoft Dynamics GP 2016 R2 Feature Blog Series Schedule page to review posted blog articles and upcoming blog posts to help you gear up for What's New in Microsoft Dynamics GP 2016 R2 with great content, documentation, and videos.

Thank you!

Lucas Reuss