Analyzing the reconciliation dataThe 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:
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 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:
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:
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:
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.
| |||