COGS and Revenues by Project and Order (tipcs3192m000)

If you work on a PCS project in a multicompany environment where sales offices, service departments, and warehouses belong to different financial companies, you can choose to post financial transactions for PCS related COGS and revenues on the financial company of the sales office, service department, and/or warehouse instead of on the PCS project's calculation office.

Use this session to to view and modify the distributed COGS and revenues for a PCS project, specified by order and department (entity). You can view in this session the interim COGS and revenues as well as the COGS and revenues for a closed PCS project.

Note that the estimated and actual COGS and revenues are posted and viewed by order, while the interim COGS and revenues are posted and viewed by department.

Note: 
  • You cannot confirm interim COGS and revenues separately by department. Instead, you must confirm the interim COGS and revenues by PCS project in the Confirm and Post Interim COS and Revenues by Project (tipcs3291m000) session.
  • You can start this session from the Interim COGS and Revenues by Project (tipcs3190m000) session. This session provides the total (interim) COGS and revenues for a PCS project, not specified by order and department.

Field Information

Project

project

Calculation Type

The moment that revenue recognition is carried out.

Allowed values

Interim

If revenue recognition is carried out while the status of the PCS project is Active or Finished, the calculation type of revenue recognition is always Interim.

Final

If the status of the PCS project becomes Closed, the calculation type of the last revenue recognition automatically changes to Final.

Generation date

The date and time that you calculated the interim COGS and revenue.

Entity Type

The office, department, work center, or warehouse for which interim COGS and revenues are calculated.

Allowed values

Sales Office

sales office

Shipping Office

shipping office

Project Management Office

project management office

Production Department

production department

Purchase Office

purchase office

Not Applicable
Service Department

service department

Work Center

work center

Warehouse

warehouse

Project

project

Accounting Office

accounting office

Contract

contract

Inventory Management Department

Inventory management department

Entity

The code that indicates the office, department, work center, or warehouse for which interim COGS and revenues are calculated.

Currency

currency

Order

The order that generates COGS and revenue for a specific entity.

Note: If COGS and revenues are posted on the PCS calculation office, no order number is displayed.
Calculated Interims

If this check box is selected, the interim COGS and revenues are calculated by the Calculate Interim COS and Revenues by Project (tipcs3290m000) session. The interim COGS and revenues are calculated on the entity level. As a result, if more than one order is present for a specific entity, the Calculated Interims check box is selected for only one of the orders. For the other orders on the entity the check box is still cleared.

Estimated Revenue

The total estimated revenue that is expected for the order.

Earned Revenue

The estimated total revenue for the order at completion (the value in the Estimated Revenue field) multiplied by the PCS project's Percentage of Completion (POC). The POC is calculated based on the value in the Percentage of Completion Calculation Method field in the Project Details (tipcs2130m000) details session.

Actual Revenue

The revenue of the order that is already posted by the Invoicing module in Invoicing at the date of the interim revenue recognition.

Invoiced Amount

The order amount for which already an invoice is sent.

Amount Paid

The order amount that is already paid.

Amount Overdue

The order amount for which payment is overdue.

Interim Revenue

The interim revenue for the order and position line that is or will be posted to the General Ledger module in Financials . The interim revenue is calculated by running the Calculate Interim COS and Revenues by Project (tipcs3290m000) session. The calculation is as follows:

estimated total revenue at completion = estimated revenue of the entity + estimated revenue variance
earned revenue = estimated total revenue at completion * percentage of completion (POC)
interim revenue of current period = earned revenue - (already posted actual revenue + interim revenue posted in prior periods)

If necessary, the user can overrule the calculated amount by typing an amount in the Confirmed Interim Revenue field.

Note: Actual COGS and revenue postings are aggregated by entity.
Confirmed Interim Revenue

The interim revenue for the entity that is or will be posted to the General Ledger module in Financials . The default value of this field equals the value in the Interim Revenue field but you can adjust the interim revenue in this field before you confirm it.

Earned COS

The estimated total costs at completion (the value in the Total Estimated Costs field) multiplied by the Percentage of Completion (POC). The value of the Percentage of Completion Calculation Method field in the Project Details (tipcs2130m000) details session determines which POC is used.

Actual COS

The cost of goods sold (COGS) that were already made for the order at the date and time of revenue recognition. The actual COGS can originate from:

  • Sales
  • Service
  • Warehousing

If the Post Interim COS and Revenues by Cost Component check box in the Project Details (tipcs2130m000) session is selected, the actual COGS are specified by cost component, which can be viewed in the COGS by Cost Component (tipcs3191m000) session.

Interim COS

The interim COGS that is or will be posted to the General Ledger module in Financials . The interim COGS is calculated by running the Calculate Interim COS and Revenues by Project (tipcs3290m000) session. The calculation is as follows:

estimated total costs at completion = estimated cost of the projects + estimated cost variance
earned COGS = estimated total costs at completion * percentage of completion (POC)
interim COGS of current period = earned COGS - (already posted actual GOGS + interim COGS posted in prior period)

If necessary, the user can overrule the calculated amount by typing an amount in the Confirmed Interim COS field.

Note: Actual COGS and revenue postings are aggregated by entity.
Confirmed Interim COS

The interim COGS for the entity that is or will be posted to the General Ledger module in Financials . The default value of this field equals the value in the Interim COS field but you can adjust the interim COGS in this field before you confirm it.