I want to show how whether our past due receivables are increasing or decreasing at each month end over the past 12 months, or something similar, as a way of measuring our collection performance. I will show total receivables and the over 60 portion department. I will put this into a trend / bar chart.
The AR subject provides the current aging based on what is currently open. I need more than this. I need to capture what was open items and their age at each month end.
The final piece would be to create a 'what if' using SAP Crystal Dashboards to see how your cash flow would be improved by looking at avg days to pay, vs credit terms vs credit sales.
UPDATE: QQube Version 6.0 introduced several hundred Power BI out-of-the box examples - including a daily graphical representation of A/R using the general ledger analytic:
Choose a location