Substantiated Billing - Consolidated

Form ID: (PM650050)

This report is used to provide proof of project costs. By using this report, you can review, print, and email a list of costs from accounts payable invoices, debit adjustments, credit adjustments, labor, and other project expenses. The generated report includes all scanned or uploaded images of the PNG, JPG, JPEG, BMP, GIF, TIFF, or TIF format attached to the corresponding cost records of a project for a specified billing period. When the report is generated, PDF copies of the images are attached as separate pages within the same PDF. In addition, the generated PDF includes hyperlinks to the attached files that could not be included directly in the report file (such as encrypted PDF files).

See the following section for a description of each parameter on the Report Parameters tab of the report form. For more information about using other elements on the report form, see Reports.

Report Parameters

On the Report Parameters tab, you use the following parameters to select the information to be displayed on the report:

  • Project: The identifier of the project for which the report is displayed.
  • Select Transactions By: The criteria by which the system selects the cost transactions to be included in the PDF report. You can select one of the following options:
    • Date Range (default): The PDF report will show all cost transactions that are related to the selected project and have been posted to account groups of the Expense type within the specified date range. If this option is selected, the Start Date and End Date parameters are required.
    • Pro Forma Invoice: The PDF report will show all cost transactions that have been posted to account groups of the Expense type and are related to the selected pro forma invoice of the selected project. If this option is selected, the Pro Forma Invoice Nbr. parameter is required.
    • Pro Forma Invoice and Date Range: The PDF report will show all cost transactions that have been posted to account groups of the Expense type within the specified date range and are related to the selected pro forma invoice of the selected project. If this option is selected, the Start Date, End Date, and Pro Forma Invoice Nbr. parameters are required.
  • Start Date: The start date of the date range for which the report is displayed. By default, the first date of the current financial period is selected.
  • End Date: The end date of the date range for which the report is displayed. By default, the current business date is selected.
  • Pro Forma Invoice Nbr.: The reference number of a pro forma invoice for which the PDF report is prepared. You can select only an open or closed pro forma invoice of the project that is selected in the Project box.
  • Include Non-Billable Transactions: A check box that indicates (if selected) that non-billable cost transactions are included in the PDF report. If the check box is cleared, the report includes only billable cost transactions—that is, project transactions that have the Billable check box selected on the Project Transactions (PM304000) form.
  • Copy Line Attachments to Report: A check box that indicates (if selected) that line-level attachments of the included documents originating from the AP, PM, GL, or CA source are included in the prepared PDF report, along with the document-level attachments of these documents. If the check box is cleared, the prepared PDF report includes only document-level attachments of the included documents that originate from the AP, PM, GL, or CA source.