| Print Project Costs and Revenues (tipcs3490m000) |  |
| Use this session to print the costs and revenue for PCS projects on several detail levels. 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 the Include Costs and Revenues from Sub Projects in Main Project check box, the costs of goods sold (COGS) and revenue are printed for main projects as well as for subprojects. 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) Related topics Overview of interim revenue recognition in Project Control (PCS) Cost price calculation by project
Fields | Description
Report Type | The status of the interim revenue recognition calculation. Allowed values Calculation Type
Project | A collection of manufacturing and purchasing actions that are performed especially for a particular customer order. A project is initiated by a customer order for items having a To Order order policy. The purpose of a project is to plan and coordinate the production of these items. For a standard-to-order production, the project is only used to link the item with the customer order. Otherwise, a project can include: Customized item data (BOMs and routings) Project planning (activity planning) A budget is a special type of project. A budget is used to plan and estimate, not to carry out production.
Project Status | Indicates the current progress of the project(s).
Search Key | An alternative form of a description used for convenience during searching. Typically, it is an abbreviation, an acronym, or a mnemonic alternative to a full description.
Project Employee | The person who is in charge of the project.
Start Date | The date the project is started.
Completion Date | The date the project is completed.
Sold-to Business Partner | Usually a customer's purchase department; the business partner who orders goods or services from your organization, that owns the configurations you maintain, or for whom you perform a project. Details of the agreement with the sold-to business partner can include: Default price and discount agreements. Sales order defaults. Terms of delivery. The related ship-to and invoice-to business partner.
Currency for details | The type of currency in which the report is printed.
Currency for totals | The currency in which the report is printed.
Calculate Percentage Invoiced based on local currency | The calculation percentage that is invoiced based on the local currency. Note This field is only applicable in case of independent currency system. If you have a local currency EUR, GBP and USD and the Expected revenues are EUR 1000,- and the realized revenues are EUR 400,- then the percentage is 40%. Expected revenues are GBP 1000,- and the realized revenues are GBP 500,- then the percentage is 50%. Expected revenues are USD 1200,- and the realized revenues are USD 400,- then the percentage invoiced is 30% 40% + 50% + 30%: Then the percentage invoiced field is 120/3 = 40%
Include Costs and Revenues from Sub Projects in Main Project | If this check box is selected, the costs and revenues from sub projects are included in the costs and revenues of the main project. Related topics Project types
Print Interim Line Details | If this check box is selected, details of interim revenue recognition are printed in the report. If this check box is cleared, only the project totals are printed.
Print Interim Data by Cost Component | If this check box is selected, the COGS for interim revenue recognition is specified by cost component. Only if for the project the Post Interim COGS and Revenues by Cost Component check box in the Project Details (tipcs2130m000) session is selected, you can print interim data by cost component.
Print Confirmed Lines Only | If this check box is selected, only interim revenue recognition that is confirmed is printed.
Commands | Description
Print | Prints the entered selection.