Overview of Work In Progress (WIP) view
Work in Progress report contains a list of clients’ WIP (Unbilled time), which is tracked on the relevant WIP Hours Control main account.
It groups WIP in the aging buckets: 15 (unbilled time standing as work in progress for 15 less than 15 days), 30, 45, 60 and Over 60. Total WIP is a sum of all aging buckets
The table below explains the columns in the matrix
Please note that the above mentioned buckets are just an example of how they can be defined. Users can set up and manage user-defined aging period definitions in evergreen using the form ‘Aging period definitions’.
The form can be found on this path: in *Account payable > Setup or Credit and collections > Setup. *
Note that any change in one of these forms will be reflected in the other, so there is no need to make adjustments on both sides.
To activate a different period, the following steps must be taken: BI Setup > Populate ageing period dimension table
For more details on how to enter unit and interval information on the Periods tab in the form, please refer to the Microsoft documentation.
The product itself is capable of enhancing the model and PBI reports based on the changes in evergreen, without any developer support. In this way, the users are able to change the aging period definitions independently based on their needs.
Each aging period that you set up for the aging period definition corresponds to a column in Work in Progress report
Three visuals at the bottom of the page are used to highlight:
- Share of each bucket in the Total WIP
- WIP per company (provided that more than one entity is selected in the Company
slicer)
- Top list of 5 clients with the highest Total WIP, still with a visual representation of the
age structure
Post your comment on this topic.