Project Interim Results (tppdm6103m000)

Use this session to view the settings defined for the interim financial results of a selected project.

 

Project

The project code.

Project Status
Primary Description

The description of the primary results.

Revenue Interim Results
Calculation Method

The method to calculate the percentage of the work completed.

Note

This field is enabled only if the Revenue Recognition Method field is set to Percentage of Completion.

Default value is Cost to Cost.

You can modify this value only if the project status is Free.

Infor LN allows you to calculate the revenue to be recognized based on the Percentage of Completion method only if:

  • In the Project Progress Parameters (tpppc0100s000) session, Leading Forecast Method field is set to Estimate to Complete or Estimate at Completion.
  • You must run the Build Actual Cost Control (tpppc4803m000) session to retrieve the latest aggregated cost for the project, based on which the percentage of completion is calculated.
Percentage Completed

The percentage of completion of the project. You must multiply this percentage with the contract amount to calculate the revenue to be recognized.

Note

You can manually enter the percentage of completion or click Percentage Completed to get the calculated value. LN calculates the percentage using the following formula:

percentage of completion = costs (incurred) / estimate at completion cost 
Earned Revenue Factor

Specify the earned revenue factor. You must multiply this factor with the cost to calculate the revenue to be recognized.

Note

You can manually enter the earned revenue factor or click Calculate ERF to get the calculated value. LN calculates the factor using the following formula:

ERF = project contract amount / total budgeted costs

To calculate ERF, the project status must be Active, because the total budgeted cost is known only for active projects.

Revenue Recognition Threshold

The minimum percentage completion expected before revenue is recognized.

Note

Only if the percentage completion is greater than or equal to this field, revenue is recognized when interim results are generated using the Generate Interim Results (tpppc3250m000) session. However, if the Profit Percentage is negative, revenue will be recognized irrespective of minimum percentage completion being met or not.

Default value

0

Revenue Recognition Limit

The limit on the revenue to be recognized. Specify a maximum percentage.

Note

The value can be changed. The revenue recognition limit is valid for all RR methods except the Completed Project method. The percentage times the contract amount gives the maximum revenue that can be recognized (until the completion of the project). This percentage is ignored when the project is complete and the final revenue (and COGS) is posted.

Default value

100

Cost Interim Results
Costs of Goods Sold
Percentage Completed

The percentage of completion of the project. You must multiply this percentage with the estimate at completion (EAC) to calculate the cost to be recognized.

Note

Infor LN defaults this value with the Percentage of Completed calculated for the project when Method is set to Percentage of Completion.

You cannot use this value to calculate the cost to be recognized if the Method field is set to Profit Percentage.

Profit Percentage

Specify the profit percentage. The COGS is calculated on the basis of this percentage and the revenue recognized.

Note

You can manually enter the percentage or click Calculate Profit Percentage to get the calculated value. LN calculates the percentage using one of the following formulas:

profit percentage = budget / contract amount

or

profit percentage = EAC (Estimate at Completion) / contract amount

When the COGS is determined at project level, LN allows you to select the base to calculate the profit percentage. You can either select Budget or select Estimate at Completion as the base to calculate the profit percentage.

Alternate Description

The description of the alternate results.

 

Calculate Perc. Complete

Calculates and displays the Percentage Completed of the project.

Calculate ERF

Calculates the earned revenue factor using the following formula:

Earned Revenue Factor = Project Contract Amount / Total Budgeted Costs

To calculate the earned revenue factor, the project status must be Active, because the total budgeted cost is calculated only for active projects.

This button is enabled only if the Revenue Recognition Method field is set to Earned Revenue Factor.

Calculate Profit Percentage

Calculates the profit percentage using the following formula:

Profit Percentage = Budget / Contract Amount

This button is enabled only if the Revenue Recognition Method field is set to Profit Percentage.

Calculate Primary Results

Calculates the default values to determine the project interim result based on the primary setting scenario.

Calculate Alternate Results

Calculates the default value to determine the project interim result based on the alternate setting scenario.

Change Interim Results Method

LN allows the user to modify the interim result calculation method such as Cost to Cost, Revenue Recognition Method, and COGS Method.

Switch Primary and Alternate Results Settings

Selects an alternate setting based on which the interim result must be calculated.

For example, if the Primary scenario is specified, you can select the option to use another setting for the scenario, based on which the interim results are calculated. Consequently, the alternate interim result setting is considered as the primary interim result setting.