KB - How to reprint the reports that are generated during the checkbook reconciliation process in Microsoft Dynamics GP

S’applique à : Dynamics GPDynamics GP 2016Dynamics GP 2018

INTRODUCTION


This article describes how to generate reports after you reconcile a checkbook in Microsoft Dynamics GP 10.0, in Microsoft Dynamics GP 9.0, or in Microsoft Business Solutions – Great Plains 8.0.

More Information


After a checkbook is reconciled, the following reports are printed:
  • Bank Reconciliation Posting Journal

    This report displays checkbook and bank statement balance information.
  • Bank Adjustments Posting Journal

    This report displays the adjustment transactions that are entered to balance the checkbook.
  • Cleared Transactions Journal

    This report displays the transactions that are marked as cleared.
  • Outstanding Transactions Report

    This report displays the transactions that have not cleared the bank and that fall between the cutoff dates which are entered in the Reconcile Bank Statements window.

The Outstanding Transactions Report cannot be reprinted in GP 2013 and prior versions. The information from this report is contained in the CM Unreconciled TEMP table before the reconciliation process is complete. When the process is complete, this table is cleared.  The only way to reprint this report in GP 2013 and prior is to restore a backup that was created before the reconciliation process was performed, select the checks, and then rerun the reconciliation.  

You can reprint this report in GP 2013 R2 and later versions.  The reprint report options pull by audit trail code from the CM20502 – CM Unreconciled history table. 

To determine whether a user has the access to the Bank Reconciliation reports


To do this, use the appropriate steps:

  • In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions – Great Plains 8.0, follow these steps:
    1. On the Tools menu, point to Setup, point to System, and then click Security.
    2. In the User ID list, click the appropriate user ID.
    3. In the Product list, click Microsoft Dynamics GP or Microsoft Business Solutions – Great Plains.
    4. In the Type list, click Reports.
    5. In the Series list, click Financial.
    6. In the Access list, double-click the appropriate report, and then click OK.
  • In Microsoft Dynamics GP 10.0, follow these steps:
    1. On the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to System, and then click Security Tasks.
    2. In the Task ID list, click the appropriate task ID.
    3. In the Category list, click Financial.
    4. In the Product list, click Microsoft Dynamics GP.
    5. In the Type list, click Reports.
    6. In the Series list, click Financial.
    7. Click to select the Reconcile Journal check box, and then click Print Operation Access.
    8. In the Report Destination window, select the appropriate destination, and then click OK to print a report that displays users who have access to the report.


      Note If you receive the following message, save the changes in the window, and then follow step 1 through step 8 again:
      Select a record first
    9. Follow step 1 through step 8 for the following reports:
      • Bank Adjustment Edit List
      • Bank Adjustment Posting Journal
      • Marked Transactions Report
      • Outstanding Transactions Report
    10. If users are not displayed on the report that is printed in step 8, follow these steps:
      1. On the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to System, and then click Security Roles.
      2. In the Role ID list, click the appropriate role ID.
      3. Click to select the appropriate security task ID check box, and then click Save.
      4. Follow step a through step h for the remaining reports.
To reprint the Bank Reconciliation reports

To do this, follow these steps:
  1. On the Reports menu, point to Financial, and then click Bank Posting Journals. The following reports can be reprinted:
    • Reconciliation Journal: Select this option to reprint the Reconciliation Posting Journal.
    • Bank Deposit Journal: Select this option to reprint the Bank Deposit Posting Journal.
    • Bank Transaction Journal: Select this option to reprint the Bank Adjustments Posting Journal.
    • Cleared Transactions Journal: Select this option to reprint the cleared transactions in the last bank reconciliation.
  2. In the Ranges list, click Audit Trail Code, and then type the appropriate audit trail codes in the From field and the To field.
  3. Click Destination.
  4. Select the appropriate destination, and then click OK.