Printing Project Costs and Revenues

• If the report type is Actual, only actual costs and revenue are printed.
• If the report type is Interim and Actual, actual costs and revenue as well as interim amounts are printed. If revenue recognition functionality is used for PCS projects, this report type provides overviews.

If you select report type Actual, you can choose to print several types of reports. These report types are listed below. Financial transactions for these reports are read from table tipcs300, PCS WIP and Inventory Transactions. Financial transactions can be viewed in the PCS Financial Transactions by Transaction Origin and Financial Trans. (tipcs3500m000) details session.

• Project Costs and Revenues (Detailed)
  This type of report gives a detailed overview of the project costs and revenues directly related to the PCS project, sales orders, service orders, and warehouse orders. The following data is included in the report:

  • PCS related

    Financial transactions with transaction origin Project (PCS): Cost of Goods Sold and Additional Costs of Goods Sold.

    The expected and realized gross profit equal the COGS, multiplied with -1.

  • Sales/Service related

    The Cost of Goods Sold financial transactions for the transaction origins Sales Order and Service Order. For sales, the expected revenue is based on the amount on the sales order that is linked to the PCS project. In the report, the realized revenue is split in Goods Invoiced and Invoiced Installments not Settled.

    Based on the revenue and COGS, the gross profit is calculated as follows:

    • Expected Gross Profit = Expected Revenue -/- Costs
      						of Goods Sold

    • Realized Gross Profit = Realized Revenue -/- Costs
      						of Goods Sold

    • To be Invoiced = Expected Revenue -/- Realized
      						Revenue

  • Warehousing related
    In the report, a split is made between warehouse transfers with invoicing and warehouse transfers without invoicing. For orders with invoicing, the COGS are determined in the same way as they are determined for sales and service orders. For orders without invoicing, the COGS are based on the issue transactions, and the revenues on receipt transactions. The expected revenue is based on order amount.
• Project Costs and Revenues (Summarized)
  If you choose to print a summarized report for project costs and revenues, only one line per project is printed. However, the underlying calculations are done in the same way as for the detailed report.
• Project Costs (Summarized)
  This report prints the COGS for each project. The costs of goods sold are split into parts related to:

  • Project
  • Sales
  • Service
  • Warehouse (transfers with invoicing)
  • Pseudo COGS for Warehousing (transfers without invoicing)
• Project Revenues (Summarized)
  This report prints the revenues for each project. The revenues are split into parts related to:

  • Sales
  • Service
  • Warehouse (transfers with invoicing)
  • Pseudo COGS for Warehousing (transfers without invoicing)