Recognizing Interim Revenue in Project Control
This topic describes the steps to calculate interim COGS and interim revenue for a PCS project.
-
Project Details (tipcs2130m000)
In the Percentage of Completion Calculation Method field of the Project Details (tipcs2130m000) session, you can specify which method is used to calculate the percentage of completion for the PCS project. The selected POC is used to calculate the interim COGS and revenue.
Note: In the Project Control Parameters (tipcs0100m000) session, you can also select a POC method. This method is used as a default value in the project details of PCS projects that are generated from a sales order line by using the Generate (Project PCS) Structure for Sales Orders (tdsls4244m000) session.
-
Calculate Interim COS and Revenues by Project (tipcs3290m000)
To calculate interim COGS and revenues for one or more PCS projects, you must run the Calculate Interim COS and Revenues by Project (tipcs3290m000) session. LN carries out the following steps:
- The actual costs for the PCS project are calculated up to
the Reference Date, but the actual standard costs are not
overwritten.
- If the Perform estimated cost calculation check box is selected, the estimated standard cost for the PCS project is calculated. The estimated standard cost of the PCS project is based on the standard costs of items linked to the project. The project quantity is also taken into account, plus the estimated surcharges, and the estimated standard cost of the activities. Estimated costs for the PCS project that were already calculated, are overwritten.
- If the Perform estimated cost calculation check box is cleared, the estimated project costs are not calculated but they are taken from the Standard Cost by Project (tipcs3560m000) session.
- Actual hours are calculated. Project hours can originate from the PCS project, the PCS activities, Job Shop Control production orders, and service orders. Hours for Job Shop Control, service and PCS cannot be estimated. Therefore, ff interim revenues and COGS for a specific project are determined for the first time, the estimated hours need to be entered manually in the Interim COGS and Revenues by Project (tipcs3190m000) session. Only using the estimated activity hours would be misleading. If you calculate interim COGS and revenue in subsequent periods, the number of hours is used which you entered manually the first time.
- The estimated and actual COGS/revenues are determined. The sum of the most recent estimated revenues for sales, service, and warehousing is calculated. Furthermore, the sum of actual revenues, the sum of actual COGS for the PCS project, and the related sales orders, service orders, and warehousing orders are determined.
- The percentage of completion (POC) for the PCS project is calculated based on the method you chose in the Percentage of Completion Calculation Method field in the Project Details (tipcs2130m000) session. If you selected Manual as POC method in the Project Details (tipcs2130m000) session, you can indicate in the Stage of Completion field the percentage of the work on the PCS project that is completed.
- The Interim COGS and Interim Revenue are calculated.
- The actual costs for the PCS project are calculated up to
the Reference Date, but the actual standard costs are not
overwritten.
-
Interim COGS and Revenues by Project (tipcs3190m000)
You can view the calculated COGS and revenue in the Interim COGS and Revenues by Project (tipcs3190m000) session. You can manually adjust some of the calculated amounts and the POC percentage. For every PCS project one or more interim COGS/revenues can be listed.
From the appropriate menu, or with the buttons, you can handle the rest of the interim COGS and revenue procedure. This described in the next steps of the procedure.
-
COGS by Cost Component (tipcs3191m000)
If for a PCS project the Post Interim COS and Revenues by Cost Component check box in the Project Details (tipcs2130m000) details session is selected, you can view in the COGS by Cost Component (tipcs3191m000) session how the COGS is distributed over cost components. You must start this session from the appropriate menu of the Interim COGS and Revenues by Project (tipcs3190m000) session, or by clicking Cost Components.
If the interim COGS and revenue are not yet confirmed or posted, you can still modify the estimated costs and the confirmed interim COGS.
-
COGS and Revenues by Project and Order (tipcs3192m000)
If the COS and Revenues Restricted to Financial Company of PCS Project check box is cleared, hen a COGS distribution is applicable, manual or calculated, to use the Project COGS Distribution (tipcs3110m000) session.
Note: Changes to the COGS distribution affect internal billing between companies if intercompany trade relationships are defined.
In the Project COGS Distribution (tipcs3110m000) session, you can spread additional costs incurred by the project over the related production orders. Example If you ran an advertising campaign for the end item of the project, you can distribute the campaign costs among the orders linked to the project.
You can manually adjust the confirmed interim revenue per entity.
You can manage the interim revenue for the selected project using the COGS and Revenues by Project and Order (tipcs3192m000) and COGS and Revenues by Project and Order Line (tipcs3194m000) sessions. Additionally it is possible to manage the interim COGS, if the Post Interim COS and Revenues by Cost Component check box in the Project Details (tipcs2130m000) session is cleared. If the Post Interim COS and Revenues by Cost Component check box is selected, you must use the COGS by Cost Component (tipcs3191m000) session.
You can use the COGS and Revenues by Project and Order Line (tipcs3194m000) session to specify a transaction price per order line. The transaction price is used in the calculation of the interim COGS and revenues instead of the estimated revenue.
-
Confirm interim COGS and revenue
After you view and adjusting data in the Interim COGS and Revenues by Project (tipcs3190m000) session and/or the COGS by Cost Component (tipcs3191m000) session, you can confirm the data by clicking (de-) Confirm in the Interim COGS and Revenues by Project (tipcs3190m000) session. If after confirming, you still want to make changes, you can click (de-) Confirm again to de-confirm the data.
To confirm interim COGS and revenue, you can also start the Confirm and Post Interim COS and Revenues by Project (tipcs3291m000) session, select the Confirm Interim COS and Revenues check box, and run the session. Confirm and Post Interim COGS and Revenues by Project (tipcs3291m000)
-
Post interim COGS and revenue
After confirmation the interim COGS and revenue must be posted to the General Ledger module in Financials. In the Interim COGS and Revenues by Project (tipcs3190m000) session, start the Confirm and Post Interim COS and Revenues by Project (tipcs3291m000) session from the appropriate menu, or click Confirm and Post Interim COS and Revenues by Project. Select the Post Interim COS and Revenues check box, and run the session.