In-Context reports
These in-context reports are available for the Finance domain:
DSO Value
Description: This report shows the DSO value by customer number over 6 months. The measure used in this report is sourced from the AR Balances fact.
Measure: DSO Value
Aggregation: Sum
Analyze by: Accounting Period Date
Chart type: 1 data series spline chart
Parameter: Customer Number
No of Invc vs Invcd Amt
Description: This report shows the number of invoice versus the invoice amount by customer number over a period of 6 months. The measures used in this report are sourced from AR Balances and AR Invoices facts.
Measure: No. of Invcs, Invcd Amt – Division
Aggregation: Sum
Analyze by: Accounting Date, Accounting Period Date
Chart type: 2 data series combo, 1 column chart on Y axis 1 and 1 spline chart on Y axis 2
Parameter: Customer Number
Overdue vs Outstanding Trend
Description: This report shows the overdue invoice amount versus the outstanding amount by customer number over a period of 6 months. The measures used in this report are sourced from the AR Balances fact.
Measure: Overdue Invc Amt – Division, Outstanding Amt – Division
Aggregation: Sum
Analyze by: Accounting Period Date
Chart type: 2 data series combo, 1 area chart on Y axis 1 and 1 line chart on Y axis 2
Parameter: Customer Number
Amt Due vs No of Invc Due in Next 3 Months
Description: This report shows the amount due versus the number of invoices due in the next 3 months by supplier number. The measures used in this report are sourced from the AP Ledger fact.
Measure: Invc Amt, No. of Invc Journal Entries
Aggregation: Sum
Analyze by: Accounting Date
Chart type: 2 data series combo, 1 spline chart on Y axis 1 and 1 column chart on Y axis 2
Parameter: Supplier Number
No of Invc vs No of Credit Notes
Description: This report shows the number of invoices versus the number of credit note by supplier number over a period of 6 months. The measures used in this report are sourced from the AP Operational Metrics fact.
Measure: No. of Invoices, No. of Credit Notes
Aggregation: Sum
Analyze by: Accounting Date
Chart type: 2 data series combo, 1 line chart on Y axis 1 and 1 column chart on Y axis 2
Parameter: Supplier Number
Open Amt vs No of Invc Past Due
Description: This report shows the non-reconciled invoices versus the number of past due invoices by supplier number. The measures used in this report are sourced from the AP Ledger fact.
Measure: Invc Amt, No. of Invc Journal Entries
Aggregation: Sum
Analyze by: Accounting Date
Chart type: 2 data series combo, 1 column chart on Y axis 1 and 1 spline chart on Y axis 2
Parameter: Supplier Number