Use the Work in Progress Detail Report screen to create a report of work in progress detailed information for selected projects, including costs to date, percent complete, billing to date, cash received. An asterisk (*) is shown next to cost to complete amounts that are affected by entries made in Update Work In Progress. You can print or save this report.

Use the Select Format criteria field to select the type of work in progress report to create.

You can control the output of the Work in Progress Detail Report by entering details in one or more of the following fields on the Options tab:

• Select Format - Select WIP Detail to show a report of work in progress details at the level the data was entered. Select Entry Level WIP Comparisons to show a comparison of WIP entries made over two selected periods. This report should be exported to Microsoft Excel for optimal viewing. Select Project WIP Comparisons to show a comparison of WIP entries at a project level made over two selected periods. This report should be exported to Microsoft Excel for optimal viewing. If you have modified the format and layout of any of these reports on the Modify Reports screen, click to select the version to use for this report.
• Project Values Through - Click to select the date through which to show project amounts in the report.
• Comparison Period 1 Start Date - Enter the start date for the first comparison period, click to select the date from a Date Picker, or click to enter a Date Formulas. If you want to save the information in the date field when you save the report options, you must use a date formula. This field is used in the Entry Level WIP Comparisons format and the Project WIP Comparisons format.
• Comparison Period 1 End Date - Enter the end date for the first comparison period, click to select the date from a Date Picker, or click to enter a Date Formulas. If you want to save the information in the date field when you save the report options, you must use a date formula. This field is used in the Entry Level WIP Comparisons format and the Project WIP Comparisons format.
• Comparison Period 2 Start Date - Enter the start date for the second comparison period, click to select the date from a Date Picker, or click to enter a Date Formulas. If you want to save the information in the date field when you save the report options, you must use a date formula. This field is used in the Entry Level WIP Comparisons format and the Project WIP Comparisons format.
• Comparison Period 2 End Date - Enter the end date for the second comparison period, click to select the date from a Date Picker, or click to enter a Date Formulas. If you want to save the information in the date field when you save the report options, you must use a date formula. This field is used in the Entry Level WIP Comparisons format and the Project WIP Comparisons format.
• Company - Click to select one or more companies for the report. If no companies are selected, all companies appear in the report.
• Division - Click to select one or more divisions for the report. If no divisions are selected, all divisions appear in the report.
• Customer - Click to select one or more customers for the report. If no customers are selected, all customers appear in the report.
• Project Classification - Click to select one or more project classifications for the report. If no classifications are selected, all classifications appear in the report.
• Project Manager - Click to select one or more project managers for the report. If no project managers are selected, all project managers appear in the report.
• Project - Click to select one or more projects for the report. If no projects are selected, all projects appear in the report.

• Project Status - Click to select the project status for the report. Select Both to show both active and inactive projects in the report.

• Cost Code - Click to select one or more cost codes for the report. If no cost codes are selected, all cost codes appear in the report.
• Cost Type - Click to select one or more cost types for the report. If no cost types are selected, all cost types appear in the report.
• Exclude Projects with Contracts < - Enter a contract amount below which projects should be excluded from the report. Enter 0 to include all projects in the report.
• Include Pending Transactions - Select the checkbox to include both pending and posted transactions in the report. Deselect the checkbox to show only posted transactions in the report.

• Include Committed Costs - Select the checkbox to include committed and posted costs in the report. Deselect the checkbox to include only posted costs in the report.

• Include Pending COs in Contract Amount - Select the checkbox to include amounts from pending change orders in the calculated contract value. This affects the Revised Contract, Percent Profit (WIP Detail Report), Estimated Percent Profit (Entry Level and Project WIP Comparisons), and Earned Profit Percent (Entry Level WIP Comparisons). Deselect the checkbox to include only amounts from approved change orders in the report.
• Sort By - Select Project to sort the report by project. Select Division to sort the report by division. Select Project Manager to sort the report by Project Manager.
• Consolidate Sub Projects and Master Project - Select the checkbox to show the sum of cost codes across master and subprojects, when the cost codes match. Deselect the checkbox to show subproject details.
• Subtotal Over Billed and Under Billed As - Select One net amount to show over billed and under billed amounts subtotaled in one amount in the report. If the net amount is positive, the amount is shown in the Over Billed column; if the net amount is negative, the amount is shown in the Under Billed column. Select Separate amounts to show over billed and under billed amounts as separate subtotals in the report.
• Include Zero Rows - Select the checkbox to include zero cost rows in the report. Deselect the checkbox to exclude zero cost rows from the report.
• Round Values to Whole Numbers - Select No to show all values in the report without rounding. Select Yes to round all values in the report to the nearest whole number.

For information on running the report, see Run and Print Reports.