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