WIP Rollforward, by Account Manager
This section describes the fields and actions on the WIP Rollforward, by Account Manager report.
The WIP Rollforward, by Account Manager report estimates the WIP (work in progress) figure by a date (To Date), basing the WIP on another date (From Date) and entries and invoices during the period between the From Date and the To Date.
- You can drill up on the No & Name column to the company, and you can drill down to the job.
- The Opening Bal. column links to the WIP Aging report.
The CPA solution uses the purpose dimension for Client Manager , and in that solution this report is renamed to WIP Rollforward, by Client Manager. Thus, this report is a client manager focused version of the WIP Rollforward report.
Report Description
This report has three tabs. The first tab displays similar columns as the WIP Rollforward report. The second and third tabs display the same columns, except that:
- They do not offer drilling.
- The second tab groups by the Purpose dimension and displays the name and number of the Client Level 1 instead.
- The third tab groups by the Purpose dimension and the Client Level 1 dimension, and displays the name and number of the job instead.
| Column | Description |
|---|---|
| No & Name | This column displays the number and name of the current drill-down level. The drill-down levels are:
|
| WIP, Opening Bal. | This column displays the total WIP balance by the From Date . |
| Registered, Time | This column displays the entered billing price for time activities within the interval given. |
| Registered, Amount | This column displays the registered billing price for amount activities within the interval given. |
| Invoiced, Time | This column displays the invoiced billing price for time activities within the interval given. |
| Invoiced, Amount | This column displays the invoiced billing price for amount activities within the interval given. |
| Invoiced, Up/Down | This column displays the up/down writing of the invoiced billing price within the interval given. |
| Invoiced, Net on Acc. | This column displays the amount invoiced on account that is not yet reconciled, within the interval given. |
| WIP, Gross | This column displays the estimated value of WIP by the
To Date.
It is calculated from other columns. The formula is as follows: WIP, Opening Bal + Registered, Time + Registered, Amount - Invoiced, Time - Invoiced, Amount + Invoiced, Up/Down |
| WIP, Reserve | This column displays the contribution to WIP within the given interval, for revenue recognition adjustments (WIP Adjustments).
These are adjustments made in the window Revenue Recognition and which have the journal type Revenue Recognition. |
| WIP, Net | This column displays the Net WIP, which is calculated as the WIP, Gross minus the WIP, Reserve and Net On Acc. |