Information about the balances in the Reconcile to GL window in Microsoft Dynamics GP
Bank Reconciliation -
- If your checkbook is in the functional currency, the Ending Balance should display the Current Checkbook balance (adjusted back to your 'To' date in your Date Range by the transactions in the CM20200 table). The Beginning Balance should then adjust by the transactions in the CM20200 table back to the 'From' date of your Date Range to arrive at a Beginning Balance to display for the Subledger.
- If your checkbook is in an 'originating' currency, the beginning and ending balances in this window will omit the beginning balance amount since a functional currency equivalent of the beginning balance is not stored. The Ending Balance column will display the net activity for the month (from the CM20200 table), but you will be off by the amount of your beginning balance, if your checkbook is in a non-functional currency. In the meantime, you can manually add the beginning balance to the spreadsheet, and/or use the 'unmatched' section to help find differences to research. Please vote on this product suggestion to get this functionality enhanced (ie. beginning balances in functional currency to populate the Reconcile to GL window/spreadsheet balance fields) in a future version:
Article ID: 3191232 - Last Review: 09/21/2016 15:49:00 - Revision: 8.0
- kbmbsmigrate kbsurveynew KB3191232