Project - WIP (report)

Cost price accounts

Account	Hour - Qty.	Posting - Total WIP cost	Posting - Total WIP sales	Calculation 1 Gross WIP	Posting - WIP - Invoiced - On account	Calculation 2 Net WIP
About cost	Not applicable (N/A)	N/A	N/A	N/A	N/A	N/A
About payroll allocation	N/A	N/A	N/A	N/A	N/A	N/A
About WIP cost value accounts	Included	Included	N/A	N/A	N/A	N/A
About item cost	N/A	N/A	N/A	N/A	N/A	N/A
About WIP cost value item accounts	N/A	Included	N/A	N/A	N/A	N/A
About accrued loss	N/A	N/A	N/A	N/A	N/A	N/A
About WIP accrued loss accounts	N/A	Included	N/A	N/A	N/A	N/A

Sales price accounts

Account	Hour - Qty.	Posting - Total WIP cost	Posting - Total WIP sales	Calculation 1 Gross WIP	Posting - On account	Calculation 2 Net WIP
About invoiced revenue	N/A	N/A	N/A	N/A	N/A	N/A
About on-account invoiced revenue	N/A	N/A	N/A	N/A	N/A	N/A
About sales value and accrued revenue	N/A	N/A	N/A	N/A	N/A	N/A
About WIP sales value accounts	Included	N/A	Included	N/A	N/A	N/A
About accrued revenue through production	N/A	N/A	N/A	N/A	N/A	N/A
About WIP production accounts	N/A	N/A	Included	N/A	N/A	N/A
About accrued revenue through profit	N/A	N/A	N/A	N/A	N/A	N/A
About WIP profit accounts	N/A	N/A	Included	N/A	N/A	N/A
About on-account accrued revenue	N/A	N/A	N/A	N/A	N/A	N/A
About WIP invoice on-account accounts	N/A	N/A	N/A	N/A	Included	N/A
About subscription and accrued revenue	N/A.	N/A	N/A	N/A	N/A	N/A
About WIP subscription accounts	N/A	N/A	Included	N/A	N/A	N/A

Tip
Run the Transactions - Projectlist with the Project statementset to WIPto see the figures on this report broken down by category or employee/item ID. Run the Transactions - Projectlist with Project statementset to WIPand the Vouchercheck box selected to see the figures on this report broken down by vouchers. Run the Ledger reconciliation - WIPreport from General ledger, Reports, Reconciliation, Projectto view the figures on this report broken down to the account level. Run the Ledger updates - WIPreport to break down the figures in the Ledger reconciliation - WIPreport to the transactions' level.

Tip

Run the Transactions - Projectlist with the Project statementset to WIPto see the figures on this report broken down by category or employee/item ID.

Run the Transactions - Projectlist with Project statementset to WIPand the Vouchercheck box selected to see the figures on this report broken down by vouchers.

Run the Ledger reconciliation - WIPreport from General ledger, Reports, Reconciliation, Projectto view the figures on this report broken down to the account level.

Run the Ledger updates - WIPreport to break down the figures in the Ledger reconciliation - WIPreport to the transactions' level.

The following links and table provide descriptions for the controls in this form.

Enter criteria on the General tab

Prepare batch processing on the Batch tab

Buttons

Button	Description
Select	Open a query and select the data to be included. View the data selections of some reports in the Selectquery.
Default	Return to the default settings of the Selectquery.
Options	Set up report delivery, such as formatting for a printer, printing, or saving as a file.
Recurrence	Change the starting time and starting date of the batch job or set up a recurring batch job.

Fields

Field	Description
Include project types	Select the checkboxes to include the project types you want in the report.
Include transaction types	Select the checkboxes to include the transaction types you want in the report.
From date/ To date	Specify a start and end date to include project transactions posted in Project.
From date/ To date	Specify a start and end date to include project transactions posted to Ledger.
Actual or Budget	Select Actualto display the actual figures in the report. Select Budgetto display the budgeted figures in the report.
Forecast model	Select the forecast model to be used by the report.
Project view	Select the point of view of the output in the report from the drop down list in this field. For example, the output can be based on the project group, the person in charge of the project, the person financially in charge of the project, or the customer.
Project level	Enter the number of subproject levels to be applied in the overview. The number of levels that can be applied corresponds to the number of levels applied in the project hierarchy. Enter 0to display all projects summarized at one line. Enter 1to display all projects summarized at one level - at one line each. An asterisk () indicates if the summarized number includes sub-projects below the parent level. Enter 2to display all projects and the first level of sub-projects. The projects below the parent project level are summarized on one line and an asterisk () indicates if the summarized number includes sub-projects below the first sub-project level.
Skip blank ID	Select this check box to exclude unidentified projects, such as internal projects, from the overview.
Skip zero	Select this check box to include projects with registrations, but with zero amount, to be included in the overview.
Show amount	Select how you want the amounts to display in the report.
Show hour	Select whether to display the amount of hours, the quantity of hours, or both, in the report.
Positive WIP	Select this check box to show data from projects where the net WIP amount is positive (debit), which means that the amount of work registered on the project exceeds the value that has been on-account invoiced. The value of the project is registered as an asset on the balance sheet (funded by the company.)
Negative WIP	Select this check box to show data from projects where the net amount is negative (credit), which means that the value that has been on-account invoiced exceeds the amount of work registered on the project. The value of the project is registered as a liability on the balance sheet (funded by the customer.)

Processing batch jobs

Relationship between figures in this report and the posting setup

Cost price accounts

Sales price accounts

Navigating the form

Buttons

Fields

See Also