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.