Cost Detail Report screen

Use the Cost Detail Report screen to create a detail or summary report of project cost information for a selected date range. This report displays the Intercompany Setup screen for transactions. You can print or save this report.

Use the Select Format criteria field to select the type of cost detail report to create; either the standard cost detail report or cost detail with labor hours in separate columns by type.

Note: To open the Cost Detail Report screen, go to Projects > Reports > Cost Detail Report.
You can control the output of the Cost Detail Report by entering details in one or more of the following fields on the Options tab:
  • Select Format - Select Cost Detail Report with Summarized Labor to create the standard cost detail report with summarized labor. Select Summarized Labor Cost Detail with Hours Columns to show separate columns for regular, overtime, and doubletime hours in the report. If you have modified the format and layout of this report on the Modify Reports screen, choose the version to use for this report.
  • Report From Date - Enter the start date for the report, select the date from a Date Picker, or select to enter a date formula. If you want to save the information in the date field when you save the report options, you must use a date formula.
  • Report Through Date - Enter the end date for the report. This field is required.
  • Date Type - Select Posting to show non-payroll costs based on the posting date. Select Transaction to show non-payroll costs based on the transaction date.
  • Date Type for Payroll Costs- Select Date Worked to show payroll costs based on the date worked. Select Check Date to show payroll costs based on the check date. Select Posting to show payroll costs based on the posting date.
  • Company - Select one or more companies for the report. If no companies are selected, all companies appear in the report.
  • Division - Select one or more cost code divisions for the report. If no divisions are selected, all cost code divisions appear in the report.
  • Project - Select one or more projects for the report. If no projects are selected, all projects appear in the report.
  • Project Status - Select the project status for the report. Select Both to show both active and inactive projects in the report.
  • Project Classification - Select one or more project classifications for the report. If no classifications are selected, all classifications appear in the report.
  • Project Manager - Select one or more project managers for the report. If no project managers are selected, all project managers appear in the report.
  • Owner Change Order - Select one or more owner change orders for the report. If no owner change orders are selected, all owner change orders appear in the report.
  • Change Management Record - Select one or more change management records for the report. If no change management records are selected, all change management records appear in the report.
  • Cost Code - Select one or more cost codes for the report. If no cost codes are selected, all cost codes appear in the report.
  • Cost Type - Select one or more cost types for the report. If no cost types are selected, all cost types appear in the report.
  • Accounting Basis - Select Accrual to show posted transactions with an accrual accounting basis. Select Cash to show posted transactions with a cash accounting basis.
  • Transactions To Include - Select Posted to show only posted transactions in the report. Select Posted and Pending to show both posted and pending transactions in the report. Select Posted, Pending and Committed to show all transactions in the report.
  • 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.
  • Print Change Orders Separately - Select the checkbox to show change management records and owner change order totals on the report. Pending and Rejected owner change orders are printed in the Unapproved Change Orders section. Deselect the checkbox to include change management record and owner change order totals in the project totals in the report.
  • Detailed/Summary - Selected Detailed to show detailed project cost information. Select Summary to show project cost information summarized by posting date, document source, journal sequence number, ID, and transaction number.
  • Page Break At Project - Select the checkbox to include a page break at the start of each new project included in the report.
  • Include Fiscal Period Totals - Select the checkbox to show fiscal period total in the report. Deselect the checkbox to only show totals for the selected dates in the report.
  • Include Totals by Cost Type - Select the checkbox to show totals by cost code/cost type in the report. Deselect the checkbox to only show totals by cost code in the report.

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