The item report function can be used for the following purposes:
Dynamic Reporting
Dynamic Reporting allows real-time analysis of P/L (Profit Loss) items based on calculated profitability results, including slicing and dicing into all available characteristics.
Pre-allocation reconciliation reporting
In pre-allocation reconciliation, general ledger data can be compared with the enriched data to find out whether all ERP data is reflected completely before allocation.
Post-allocation reconciliation reporting
In post-allocation reconciliation, general ledger data can be compared with the allocation results to find out whether all ERP data is reflected completely after allocation.
Dynamic Reporting
The item report uses an input function (for example, allocation results) together with an item form (for example, P/L schema) to produce a dynamic report. As an input function, you can choose any data source containing key figures, which at least partly match the key figures used in the item form. You then apply the item formulas for these matching key figures. For example, if there is a data source containing profitability results for assets, but an item form is assigned that calculates the complete P/L schema including assets, liabilities and tax, then the P/L items for assets are filled and the P/L items for the rest are 0.
Reconciliation(Pre-Allocation/Post-Allocation)
The item report uses two input functions (for example, general ledger P/L data as a source and allocation results for comparison) together with an item reconciliation (for example, to reconcile general ledger P/L data with allocation results) and an item form (for example, a P/L schema) to produce a reconciliation report. If the item report category is post-allocation reconciliation, then the item report allows the system to send reconciliation postings to the general ledger to update the P/L.
Settings Configuration
In the Settings roadmap step, choose the Item Report category from the list.
Choose the Item Form function with which you want to build this report.
If you choose Post-Allocation Reconciliation, then you can optionally assign a G/L Write Adapter to the Item Report. This sends reconciliation postings to the general ledger to update the P/L
Source Configuration
In the Item Report Source roadmap step, from the list of input functions, choose the one that about which you want to report.
In the Source Input function, you can select the Is Dimension checkbox column for characteristics of the input data that you want to use as analysis dimensions (slicing/dicing characteristics) in the item report result. Note: the order of the dimension field within this input function decides the hierarchy of the dimension values that appear in the tree structure on the left side of the item report analysis result.
In the Source Input function, you can select the Expand Values checkbox column for a single characteristic of the input data. The values of this characteristic will be set as column headers within item report analysis and the P/L item results values will be shown accordingly.
Comparison Configuration
This page will appear only if the item report categories Pre-Allocation/Post-Allocation Reconciliation is chosen.
n the Item Report Comparison roadmap step, from the list of input functions, choose the one that about which you want to report.
This function outputs the P/L Item Schema values based on the input data. If used for reconciliation (pre-allocation or post-allocation), then the system also shows the comparison values for the P/L Item Schema.
To see the results in the hierarchical P/L item schema, choose Analysis. The results will be shown in a new application screen. The user can “slice and dice” using the analysis dimension characteristic values in the tree structure on the left side tree of the screen. To do so, select a dimension value and choose Refresh Results. Additionally, you can specify selection criteria for the input data by choosing Selection.