Running the Project Cost Report

Select Project Reports (G31P14), Project Cost Report.

Use the Project Cost report (R31P401) to print a list of tasks and display these cost amounts:

  • WIP amount.

  • Planned and estimated material, labor, other and special costs.

  • Actual costs to date.

  • Committed amounts from parts lists and purchase orders.

Based on the F4801 table, you can print the information for the task of one project or multiple projects.

The system calculates the WIP amount by subtracting the sum of all unaccounted completed and unaccounted scrapped amounts in the F3102 table. If the result equals zero, no exception exists, and the system does not print the WIP amount. If the WIP amount is greater than zero, the report indicates that not all of the activities for the completed amount have been reported. If the value is less than zero, the exception report states that an overcompletion exists.

The system retrieves the estimated, planned, and actual amounts for the report from the corresponding cost field in the F4801 table. The system calculates the committed amount from the open commitment amounts in the F3111 table and the F43199 table.

When the total actual cost-to-date exceeds the total budgeted cost by the percentage that you specified in the processing options, the system creates a budget exception message for alert-sensitive tasks. If a task has a related purchase order or subcontract, and the amount received exceeds the extended cost by the percentage that you specified in the processing options, the system sends an over-payment exception message.

The exception messages appear on the report even if you decide not to send alert messages.