Drill back to M3 report

High Risk Payers Details - Drillback

Description: This report shows the payers that have a DSO Code of 2 or 5 in a tabular report. In this report, you can see the underlying factors that make a payer high risk in providing payments to the company. DSO Summary and credit manager are also provided. The measures used in this report are sourced from the AR Balances fact.

Measure: DSO Value, Invc Amt – Division, Pmt Amt – Division, Outstanding Amt – Division, Overdue Amt – Division, Stopped Amt – Division

Aggregation: Sum

Analyze by: Accounting Period Date

Chart type: Table

Drill back to M3: Hyperlink Payer to ARS200/B

Income Statement report

Description: This report shows the recorded amount for all report lines as rows, with fiscal periods displayed in the columns. It uses the variable M3A_FKRReport2 as input for the report ID, with a default value of M3FKR2. The measure used in the Income Statement report is sourced from the Finance Key Ratio fact.

Measure: Recorded Amt

Aggregation: Sum

Analyze by: Accounting Period Date

Chart type: Cross table

Balance Sheet

Description: This report shows the recorded amounts for all report lines as rows, with the fiscal periods displayed in the columns. Drillback functionality is enabled at the intersection of each value so that users can navigate directly to the M3 GLS210 program and view the underlying transactions. The international standard date format (YYMMDD) is used in the drillback configuration.

Measure: Recorded Amt

Chart type: Cross table