Analyzing the reconciliation data

The best way to analyze the reconciliation data depends on your main business processes and your information requirements. The Operations Management - Financial Reconciliation (tfgld4595m000) session and the report options in the Print Reconciliation Data (tfgld4495m000) session enable you to create various views of the reconciliation data on various levels of detail.

For example, you can generate the reports:

  • By business object:

    • Order number
  • By reconciliation element:

    • Item
    • Business partner
    • Purchase office
  • By status:

    • Open/Active
    • Closed
  • By ledger account
  • By transaction type

For more details about how to print the reconciliation reports, refer to To print the reconciliation reports.

This topic describes a few example types of reconciliation transaction and gives some general guidelines on how to approach the analysis.

Types of reconciliation transactions

In general, the following types of reconciliation transactions can be distinguished:

  • Transactions logged on Business Object (order) level. For example, the Production Order (JSC) WIP and the Project (PCS) WIP.
  • Goods received not invoiced (GRNI) transactions (Invoice Accrual 3).
  • Transactions on inventory accounts.
  • Transactions on interim transit accounts. Related integration transactions belong to different business objects. You can link the transactions by means of the generated reference link.
Transactions logged on Business Object (order) level

You can print a reconciliation report to check whether the balance for Closed production orders is zero. You can analyze this type of transactions, for example, Production Order (JSC) WIP and the Project (PCS) WIP after acceptance of the reconciliation data.

In the Print Reconciliation Data (tfgld4495m000) session, select the following options:

  • Select the production orders with the Closed status.
  • Select the full range of periods.
  • Select the Suppress Zero Balances check box.
  • Clear the Compare Reconciliation with Finalized General Ledger check box.
  • Select the Business Object ID check box.

If all is well, no differences exist and the report is empty. If a difference exists, you can use the Operations Management - Financial Reconciliation (tfgld4595m000) session to investigate the transaction and drill down to the Operations Management transactions.

Goods received not invoiced (GRNI) transactions

For GRNI transactions, you can print the report by closed purchase order to detect any differences between the closed order balance and the invoice accrual amounts. You can analyze the GRNI reconciliation group after acceptance of the reconciliation data.

You can print the following reports:

  • In the Print Reconciliation Data (tfgld4495m000) session, you can print a report based on the logged transactions in the Reconciliation Data (tfgld495) table.

    • Select the following options:

      • Select the purchase orders with Closed status.
      • Select the full range of periods.
      • Select the Suppress Zero Balances check box.
      • Clear the Compare Reconciliation with Finalized General Ledger check box.
      • Select the Business Object ID check box.
  • In the Checklist Reconciliation Goods Received Not Invoiced (tfgld4495m200) session, you can print a report based on both the logged transactions in the Reconciliation Data (tfgld495) table and the registered purchase receipts in Procurement or the posted receipts and invoice approvals in Accounts Payable.
Transactions on inventory accounts

By their nature, inventory accounts usually do not balance at any particular moment in time. You can print the reconciliation reports to obtain a report of the inventory by reconciliation element, for example, by item, by item group, or by warehouse.

You must first analyze the Inventory reconciliation group before you can accept the reconciliation data.

To analyze the inventory accounts, print a report of the reconciliation data with the balances on a higher level, for example, by warehouse item. In the Print Reconciliation Data (tfgld4495m000) session, select the full range of periods.

If no transactions have been archived or deleted, the report that results lists the inventory by reconciliation element (item). This report must be in accordance with the report from the Perform Inventory Valuation (whina1210m000) session. If inventory transactions have already been archived or deleted, you can manually create an opening balance for reconciliation.

Note

The reconciliation report is per financial company. The inventory valuation report should include all the warehouses that are linked to the financial company through their enterprise unit, and not other warehouses.

Interim transit transactions

Interim transit accounts are used for the integration transactions of which the debit and credit entries on these accounts belong to different business objects. The transactions are linked by a reference link.

Because the debit and the credit entry on interim accounts are created at the same time, the balance of these accounts is usually zero. You can use the Print Reconciliation Data (tfgld4495m000) session to print a reconciliation report to check whether the balance is indeed zero.

Select the following options:

  • Select the orders with Closed status.
  • Select the full range of periods.
  • Select the Suppress Zero Balances check box.
  • Clear the Compare Reconciliation with Finalized General Ledger check box.
  • Select the Business Object ID check box or the Reference Link check box.

If all is well, no differences exist and the report is empty. If a difference exists, you can use the Operations Management - Financial Reconciliation (tfgld4595m000) session to investigate the transaction and drill down to the Operations Management transactions.

You can analyze the Interim Transit reconciliation group after acceptance of the reconciliation data.