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

 

Project

A collection of manufacturing and purchasing actions that are performed for a particular customer order. A project is initiated to plan and coordinate the production of the to be manufactured items.

For a standard-to-order production, the project is only used to link the item with the customer order. A project can also include these:

  • Customized item data (BOMs and routings)
  • Project planning (activity planning)
Calculation Type

The moment that revenue recognition is carried out.

Allowed values

Calculation Type

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

Possible values

Entity

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

Currency

A generally accepted medium of exchange such as coins, treasury notes, and banknotes.

The following currency types are available in LN:

  • Home currency, which is used internally by companies to calculate costs, record budgets, and register tax amounts
  • Transaction currency, which is used in transactions with business partners, such as orders and invoices
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 COGS 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 COGS 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 COGS

The estimated total costs at completion (the value in the TotalEstimated 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 COGS

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 COGS 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 COGS

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 COGS 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 COGS field.

Note

Actual COGS and revenue postings are aggregated by entity.

Confirmed Interim COGS

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 COGS field but you can adjust the interim COGS in this field before you confirm it.

 

Show Order

Select a line, and click to zoom to the order that is indicated on the line.

Toggle to and from calc. office currency

Every department / entity can have a different currency. To compare the amounts on the orders, click Toggle to and from calc. office currency to change the departments' currencies to the currency of the PCS calculation office.