To print the reconciliation reports

Depending on the type of reconciliation, you can print reconciliation reports with these sessions:

  • Print Reconciliation Data (tfgld4495m000)
    You can use this session to print the reports for all reconciliation groups.
  • Checklist Reconciliation Goods Received Not Invoiced (tfgld4495m200)
    For the Invoice Accrual 3 (GRNI) reconciliation group, you can use this session to print additional reports.
Print Reconciliation Data (tfgld4495m000)

Use this session to print reports with various levels of detail. How much detail you want to see on the reconciliation report depends on the stage in the reconciliation process and on your requirements to see much detail about the transactions on the ledger accounts.

For example, in the first stage, you can print a not very detailed report and, if no significant differences are detected, you can be satisfied that the postings for the reconciliation area are correct. However, for important reconciliation areas, you might want to see more detail even if no significant differences occur.

To begin, you can select the Print Summary Report, Compare Reconciliation with Finalized General Ledger, and Suppress Zero Balances check boxes to print a report of the ledger accounts that do not balance. The report includes the opening balance and the up-to-period balances.

Next, you can clear the Print Summary Report and Compare Reconciliation with Finalized General Ledger check boxes and, on the Options tab, in the Group by section, select, for example, Business Object ID, set Tolerance for Printing Balances to a specific amount, and then select various other options to print very detailed reports.

The Print Summary Report setting determines whether you print a summary or a detailed report.

Use the check boxes on the Options tab to select the level of detail.

Print

If you click Print, LN prints one of these reports:

  • Reconciliation Data by selected grouping (Detailed)
    Prints a detailed report of the individual transactions grouped by the selected grouping entity, as well as the totals per selected grouping entity.
  • Reconciliation Data by selected grouping
    Prints a summary of the transactions by the selected grouping entity, and the totals for each selected grouping entity.
  • Totals by Reconciliation Group
    Prints a summary of the total amounts per reconciliation group for the selected ledger account.
  • Flat Report
    Prints a detailed flat report of individual transactions grouped by the selected grouping entity, without selection details or any (sub) totals.
Checklist Reconciliation Goods Received Not Invoiced (tfgld4495m200)

For the Invoice Accrual 3 (GRNI) reconciliation group, you can use this session to print reports of this data:

  • The data in the Purchase Orders History (tdpur450), Purchase Order Lines History (tdpur451), and Purchase Actual Receipts History (tdpur456) tables compared with the data in the Reconciliation Data (tfgld495) table. This is the most detailed report that you can print for the GRNI data.
  • The data in the Accounts Payable tables. The receipts and approval transactions registered in the Order Data for Approval (tfacp240), Receipts (tfacp245), and Invoices Related to Purchase Order Lines (tfacp250) tables compared with the data in the Reconciliation Data table (tfgld495).

Differences between the financial data and the operational data are printed on the report. Differences do not always indicate a problem, but can also occur, for example, if:

  • Not all related integration transactions have been finalized and posted to Financials.
  • Part of the transactions have already been archived and deleted.

You can print both reports to check whether a difference exists between the amounts.

In addition, you can use the Checklist Reconciliation Goods Received Not Invoiced (tfgld4495m200) session to print the standard reconciliation report only based on the data in the Reconciliation Data (tfgld495) table.

Related topics