Interim Results (tpppc3150m000)

Use this session to view, modify, and process the interim results, which are the financial results of a project or contract that is not yet completed, for example, the profit or loss postings at the end of a financial year. For more information, refer to To use financial result. Revenue can be recognized either by project, contract, or contract line. You can specify the interim results in this session or generate the same using the Generate Interim Results (tpppc3250m000) session. The data is captured during the calculation of the results, which improves the visibility of the data for analysis. This ensures that the user is provided with accurate interim results and balances data. Expected loss can also be calculated.

You can use this session to:

  • Generate the interim results using the Generate Interim Results (tpppc3250m000) session.
  • Enter interim results or modify the generated interim results.
  • Process the transactions and view the integration transactions by revenues and costs.
  • View the totals of the revenue, cost, and balance for the selected interim result.
  • View the contract totals using the Financials by Contract (tpppc3150m100) option from the Reference menu.
  • View the hours related to the budgeted, cost incurred, estimate to complete, and estimate at completion costs and revenues.

LN allows multiple users to approve interim results using the ION based workflow-process status. For more information, refer to Workflow status process.

Field Information

General
Contract

The code that identifies the contract.

Description

The description or name of the contract.

Status

The contract status.

Contract Line

The code that identifies the contract line.

Description

The description or name of the contract line.

Contract Line Status

The contract line status.

Project

The code that identifies the project.

Description

The description or name of the project.

Project Status

The project status.

Scenario

The setting for the scenario, based on which the contract interim result is generated. You can use this to generate alternate data of the interim results. You can also compare the result of this scenario with the primary result for financial reporting purposes such as SAB 74 (accounting standard).

Allowed values

Alternate
Not Applicable
Primary
Date Range

Interim results are displayed according to the date range.

Result Revenue

If this check box is selected, Interim Results with Revenue are displayed.

Result Cost

If this check box is selected, Interim Results with Cost are displayed.

Result Balance

If this check box is selected, Interim results with Balance are displayed.

Totals by

Totals by is displayed if a record is selected: contract, contract line or project. The displayed totals are the totals for the selected contract, contract line or project.

Revenue

The total revenue for the selected interim result.

Currency

The currency used to express the total amounts for the project or contract.

Revenue Approved

The total approved revenue for the selected interim result.

Revenue Posted

The total revenues posted for the project or contract.

Cost

The total cost of the selected interim result.

Cost Approved

The total approved cost for the selected interim result.

Cost Posted

The total costs posted for the project or contract.

Balance

The total balance for the selected interim result.

Balance Approved

The total balance cost approved for the selected interim result.

Balance Posted

The total balance cost posted for the project or contract.

Hours Cost

The cost of the hours allocated for the project or contract.

Description

The description or name of the code.

Financial Result Revenue

The interim result type to which the revenues are posted.

Financial Result Cost

The interim result type to which the costs are posted.

Description

The description or name of the code.

Description

The description or name of the code.

Revenue - Exchange Rate Type

The exchange-rate type for revenues.

Cost - Exchange Rate Type

The exchange-rate type for costs.

Calculated

The amount specified for the revenue calculated .

Amount

The amount specified for the revenue calculated in home currency.

Currency

One of a company's base currencies in which LN registers and reports amounts. In a multi currency system, up to three home currencies can be defined.

Cost Calculated

The cost of sales calculated for the interim result.

Amount

The amount specified for the cost of sales calculated.

Amount

The amount specified for the cost of sales recognized in home currency.

Balance

The balance amount. LN calculates the balance using the following formula:

Note: 
Balance = (Actual Revenue - Recognized Revenue) + (Recognized Cost of Sales - Actual Costs)
Currency

The currency in which the amount is expressed.

Revenue - Exchange Rate Recognized

The revenue Currency Rate/Rate Factor.

Cost - Exchange Rate Recognized

The cost rate/ rate factor.

Registration Date

The registration date and time of the record.

Workflow Status

The status that is applicable for the business object requires authorization using ION Workflow.

When you perform a change that requires authorization, a checked-out version is created for the business object. These changes are effective only after the approval/check-in. You can also undo these changes, or recall the changes submitted.

Note: 
  • Checked-out and checked-in objects are displayed in the Checked-out Objects (ttocm9599m000) session.
  • From the appropriate menu of this session, select Workflow and then select the required action for the business object.

Allowed values

Draft

The object is checked out. It can be changed and saved multiple times until the user submits the changes.

Pending

Any changes made to the object are submitted. The object is pending for approval. The data of the object cannot be modified.

Recall Requested

The object was already submitted, but is recalled by the user. Approval will not take place anymore. If the recall is accepted, the object status becomes Draft (Revision). If the Recall is rejected, the object status becomes Pending.

Draft (Revision)

The object was recalled after it was submitted and the recall is accepted. The object can be changed and saved multiple times until the user submits the changes.

Rejected

The submitted changes to the object are rejected. The user can make changes to the object and submit these changes again, or discard all changes.

Approval Received

The submitted changes to the object are approved. The object will automatically be checked in. If the check-in fails, the status remains Approval Received. An administrator must decide what to do with the object.

Approved

The submitted changes to the object are approved and the object is checked in.

Not Applicable

The object is checked in. Instead of an Object status, an Approval status is applicable.

Note: For more information on setting up and using ION Workflow for business objects in LN, refer to the LN Content Guide for Infor ION guide at Infor Xtreme.

Status
Approved for Posting

If this check box is selected, the approved transactions are posted to the Financials and processed for interim results.

Posted

If this check box is selected, the revenues and costs are posted to the Financials and processed for interim results.

Balance Posted

If this check box is selected, the balance is posted to the Financials and processed for interim results.

Revenue and Cost Reported Completed

Indicates whether the revenue and cost posting is reported complete.

Balance Reported Completed

Indicates whether the budget balance posting is reported complete.

Text

The related text for the interim result.

Alternate Results Finalized

If this check box is selected, LN indicates that the alternate results are processed and the results cannot be modified.

Origin

The origin of the interim result type that helps distinguish between generated and manually inserted results.

Allowed values

Manual
Reversal
Generated
Cost Control Period

The year in which the transaction must be posted to the history for cost control. The default value of this field is the year of the date of input's cost-control period.

Cost Control Period

The period in which the transaction must be posted to the history for cost control. The default value of this field is the date of input's cost-control periods.

Financial Control Period

The fiscal year in which the transaction is posted to Financials .

Financial Period

The period in which the transaction is posted to Financials .

Last Modified by

The user who last modifies the record.

Description

The description or name of the code.

Transaction Time

The date when the record is last modified.

Approver

The name of the approver.

Description

The description or name of the code.

Approval Date

The date when the approval is made.

Rate Date

The date when the currency exchange rate is valid.

Rate Date

The date when the currency exchange rate is valid.

Currency Rate/Rate Factor

The currency rate to convert the transaction currency to the home currency.

Rate Date

The date when the currency exchange rate is valid.

Rate Date

The date when the currency exchange rate is valid.

Base for Profit Percentage

The basis for calculation of profit percentage.

Percentage of Completion

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

Earned Revenue Factor

The Earned Revenue Factor. You must multiply this factor with the cost to calculate the revenue to be recognized.

Profit Percentage

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

Registration Date

The registration date of the record.

Text

If this check box is selected, a text is present.

Run Date

The execution date of the processing run.

Run

The sequence number generated when the Process Transactions (tpppc4802m000) session is run.

Run Date (Report Completed)

The date on which the processing run is completed.

Run Sequence No. (Report Completed)

The sequence number generated after the processing run is completed. The number is system generated.

Extension

The code that identifies the extension linked to the project.

Description

The description or name of the code.

Element

The code that identifies the element.

Description

The description or name of the code.

Activity

The code that identifies the activity.

Description

The description or name of the code.

Sequence

The sequence number code.

Revenue Recognition by

The level at which the revenue recognition settings are defined, such as contract, contract line, or project level.

Base for Performance Obligation

The level based on which the interim results are calculated.

Allowed values

Transaction Price
Not Applicable
Contract Amount
Note: 

This field is not applicable for:

  • interim results of the origin, Manual and Reversal.
  • interim results for an extension.
Interim Result by

Indicates if the interim result is generated based on the project or the contract.

Allowed values

  • Project
  • Contract Line
Note: By default, the value is set to Project.
Method Revenue

The Revenue Recognition Method.

Method Cost

The costs of goods sold method used for the project.

Calculation

The method to calculate the percentage of the work completed.

Base for Earned Revenue Factor

The method based on which the Earned Revenue Factor Method is calculated.

Allowed values

Estimate at Completion
Budget
Manual Entry
Not Applicable
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.
Revenue Recognition Limit [%]

The limit on the revenue to be recognized.

Note: 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.
Contract Amount

The total contract amount.

Transaction Price

The transaction price of the contract line that is used as the base to calculate the interim result.

Note: 

This field is enabled only if the Base for Performance Obligation is set to Transaction Price.

Manual
Reversal
Generated
Home Currency

The transaction price in the home currency.

Billed to Customer

The WIP balance of invoices sent to customers.

Expected Revenue

Expected revenue for the project/contract.

Forecast Additional Revenue

The revenue which is over and above the project/contract amounts.

Budgeted Amount

Budgeted amount for the project/contract.

Budgeted Hours

The number of budgeted hours for the project or contract.

Unit Code for Hours

The time unit in which labor is expressed.

Cost Incurred

The costs incurred for the project/contract.