| # Print Reconciliation Data (tfgld4495m000) Use this session to print various type of reports that you can use for financial analysis. You can print a number of reconciliation reports with various levels of detail. The reports are based on the reconciliation data that LN logs in the Reconciliation Data (tfgld495) table when you save or close a transaction in Operations Management. Which fields of the Selection Range are available, depends on the selected reconciliation area and on the options selected on the Options tab. For example, if you select the Print Full Specification check box or the Group by Reconciliation Element check box on the Options tab, you cannot select the Select Specific Business Object check box. If you click Print, you can select one of the following reports: Print Reconciliation Data by [selected grouping] (Detailed) Prints the a detailed report of the individual transactions grouped by the selected grouping property, as well as the totals per selected grouping property. Print Reconciliation Data by [selected grouping] Prints a summary of the transactions by the selected grouping property, and the totals per selected grouping property. Note To print reconciliation reports for the work in process (WIP) values of PCS projects, use the Print Reconciliation Data PCS Work In Process (tfgld4495m300) session. Related topics The reconciliation process Selection Range Reconciliation Group Reconciliation Area The reconciliation area of the reconciliation group for which you print the report. Reconciliation Sub Area The reconciliation subarea of the reconciliation group for which you print the report. Reconciliation Sub Area The reconciliation group description if one is present. Selection Range Selection Range The ranges for which the report is generated. Note You can only select ranges of reconciliation elements if: Reconciliation elements are assigned to the reconciliation group. The Print Full Specification check box on the Options tab is cleared. Home Currency Home Currency The home currency used for the amounts on the report. From the Tools menu, choose Rotate Currency to switch home currencies. Selection Range Dimension Dimension To include the reconciliation data of a dimension type, select this check box. Dimension Type The dimension type included in the report. Dimension Type The dimension type included in the report. Dimension The From and To fields define the range of dimensions included in the report. Select Specific Business Object Select Specific Business Object To print the report for one business object or a range of business objects, select this check box. Business Object In the context of financial integration transaction processing, a business object is a logistic entity or event such as an item, a purchase order, a business partner, or a warehouse issue. Business Object ID The From and To fields define the range of business object IDs for which you wish to print the report. Options Options Print Full Specification If this check box is selected, LN prints a full specification of the entries on the selected ledger account(s). Select this check box to print all the entries on the selected ledger account(s). A check is performed whether the transactions in the reconciliation table are in balance with the ledger account history. If a difference exists, it is printed at the bottom of the report. This report includes the opening balance and the up-to-period balances. You can select this check box and the Suppress Zero Balances check box to print a report of the ledger accounts that do not balance. If you clear this check box, you can select the Group by Business Object ID check box and the Check Lifetime check box to print very detailed reports. Suppress Zero Balances If this check box is selected, LN prints a report of only the transactions of which the balance is not zero. You can select this check box and the Print Full Specification check box to print a report of the transactions that do not balance. Print Not Final Reconciliation Corrections If this check box is selected, LN includes any not yet posted reconciliation corrections in the report. You can select this check box to check the effect of the corrections that you created in the Operations Management - Financial Reconciliation (tfgld4595m000) session before you post the corrections. Print Only Non-accepted If this check box is selected, LN prints the reconciliation data of transactions that do not have the status Accepted or Final Accepted. Print Header Data once If this check box is selected, LN prints the header data only once on the report. You can select this check box to save space on the report, or if you print the data to a file. Print Backdated Transactions If this check box is selected, LN prints a report of only backdated transactions. If the message "No data within selection" appears, no backdated transactions exist for the selected ranges. Group parameters Group by Reconciliation Element If this check box is selected, LN groups the transactions on the report by reconciliation element. The report also shows the totals per reconciliation element. Group by Reconciliation Element The reconciliation element used to group the transactions on the report. Group by Reconciliation Element The description or name of the code. Group by Recon. Element Combination If this check box is selected, LN groups the transactions on the report by the combination of reconciliation elements up to and including the element that you enter. Group by Recon. Element Combination The reconciliation data is grouped by combination of reconciliation elements up to and including this element. For example, if the following reconciliation elements are available: Item Project Warehouse If you enter 2, the reconciliation data are grouped by item by project. If you enter 3, the reconciliation data are grouped by item by project by warehouse. Group by Recon. Element Combination The description or name of the code. Group by Business Object ID If this check box is selected, LN groups the transactions on the report by business object ID The report also shows the totals per business object ID. Group by Dimension If this check box is selected, LN groups the transactions on the report by dimension. The report also shows the totals per dimension. Group by Integration Document Type If this check box is selected, LN groups the transactions on the report by integration document type The report also shows the totals per integration document type. Group by Reference Link If this check box is selected, LN groups related reconciliation transactions that belong different business objects by their reference links on the report. The report also shows the totals per reference link. Note This option only applies to interim accounts. Check Lifetime Check Lifetime If you clear the Print Full Specification check box, you can select this check box to select reconciliation data with or without pending transactions. This option only applies to reconciliation groups for which the Basis for Final Acceptance is other than Not Applicable. Only select Business objects with status open/active If this check box is selected, LN prints a report only of reconciliation data with pending transactions. For example, use this option for types of business objects that stay Open or Active during a number of financial periods or fiscal years. Only select Business objects with status closed If this check box is selected, LN prints a report only of reconciliation data with no pending transactions. You can select this check box and the Suppress Zero Balances check box to print a report of reconciliation data with no pending transactions that still has an open balance. Details (Only applicable for the detailed reports) Financial Details If this check box is selected, LN prints the financial details on the report. Select this check box to include the following information in the report: The kind of entry (Debit/Credit). The dimension (if one of the dimensions is selected). The ledger account You cannot select this check box if you select the Logistic Details check box. Logistic Details If this check box is selected, LN prints the logistic details of up to two reconciliation elements on the report. You cannot select this check box if you select the Financial Details check box. Reconciliation Element The reconciliation element of which the details are printed on the report Reconciliation Element The description or name of the code. Reconciliation Elements Reconciliation Elements Displays the reconciliation elements of the reconciliation group, for information only. If the fields are empty, no reconciliation elements are assigned to the group in the Reconciliation Groups (tcfin0120m000) session. Print Prints the report. Select one of the following reports: Print Reconciliation Data by [selected grouping] (Detailed) Prints a detailed report of the individual transactions grouped by the selected grouping property, as well as the totals per selected grouping property. Print Reconciliation Data by [selected grouping] Prints a summary of the transactions by the selected grouping property, and the totals per selected grouping property. |