The business wanted to analyze specific accounting data in their ERP system; Microsoft Dynamics AX.
They wanted to analyze and understand the details in Accounts Receivable; specifically; customer payment reporting including Days Sales Outstanding, Open AR, Invoice Amount and Work In Progress (WIP).
We started out by vetting the data and measures in the existing model. The data was in the Data Warehouse but the measures were not being calculated correctly.
We worked with the business to figure out the calculations for the measures and created a different report to be used to vet the data and measures.
We recreated the existing report in Power BI based on business needs and requirements. We used the new measures in the report to deliver a more accurate view of the data.
The DSO report provided metrics on invoices, accounts receivable, sales, work in progress etc., and insights into which clients were taking longer to fulfill their invoices.
This insight was used by Project Managers to help them understand why invoices were not being fulfilled on time and decide on contracts and contract revisions.
We can help you streamline your reporting systems. Please contact us for a free consultation.