Financial Transactions (tpppc2100m100)

Use this session to view the financial transactions for a specific project.

Note

The field in the Sales and Invoice tab are applicable only for the extension transactions and contracts of the type Cost Reimbursement and Time & Materials.

 

Project

The project code.

Description

The description or name of the code.

Project Status
Cost
Transaction Time

The date and time when the transaction line is created.

Element

The code of the element linked to the project.

Description

The description or name of the code.

Work Authorization Status

The work authorization status of the element linked to the transaction.

Activity

The code of the activity linked to the project.

Description

The description or name of the code.

Work Authorization Status

The work authorization status of the activity linked to the transaction.

Cost Type

The cost type linked to the project.

Cost Object
Quantity

The quantity of the cost object linked to the transaction.

Note

LN considers the number of labor hours (instead of quantity), for the cost component of the cost type Labor, when calculating the cost and revenues for the project.

MAUH = total hours/inventory quantity
  • LN defaults this value of the Moving Average Unit Hours (MAUH) from Warehousing, and is used to calculate the number of labor hours.
  • The number of labor hours are required for the accurate cost calculation of Overheads and considered for Invoicing.
Unit

The unit used to express the quantity of the cost object.

Project Cost in Home Currency

The project cost amount expressed in the home currency. The home currency amount (debit) contains the home currency amounts expressed using the exchange rates of the financial company linked to the project.

Cost Amount in Home Currency (Debit)

The cost amount expressed in the home currency (debit).

Posting Type

The posting type for the cost object.

Allowed values

Posting Type - Costs

Origin

The source document type.

Allowed values

Document Type

Document

The code that identifies the order number.

Position Number

The position number of the order line.

Cost Rate

The cost price per unit.

Cost Amount

The total cost amount for the transaction.

Currency

The currency code.

Original Document Amountin Home Currency

The cost amount of the original document expressed in the home currency. The home currency amount (credit) contains the home currency amounts expressed using the exchange rates of the financial company of the origin of the transaction (for example, the financial company of the purchase office for a purchase order).

Home Currency

The home currency (credit) for the transaction.

Project Currency Rateand Rate Factor

The project currency rate.

Rate Factor
Amount of Time

The number of time units. For example, the number of days that a crane is used for a project.

Unit

The unit used to express the time.

Labor Type

The labor type code.

Stage Payment

The supplier stage payment line number linked to the order line of the type Purchase Order.

Rate Date (Costs)

The date on which the exchange rate is valid.

Exchange Rate Type (Costs)

The exchange rate type.

Description

The description or name of the code.

Rate Determiner (Costs)

The method to determine which date is used to determine the exchange rates.

Allowed values

Rate determiner

Hours Surcharge %

The surcharge percentage used for the transaction.

Note

This field is applicable only for the transactions of the cost type Labor.

Sequence

The sequence number of the transaction.

Source
Extension

The code that identifies the extension linked to the transaction.

Description

The description or name of the code.

Status

The status of the extension.

Cost Component

The cost component linked to the project.

Description

The description or name of the code.

Employee

The code that identifies the employee.

Employee Name

The name of the employee.

Description

The description or name of the code.

Effectivity Unit
Description

The description or name of the code.

Phantom Item

The code of the phantom item that is a part of the bill of material.

Description

The description or name of the code.

Phantom Quantity

The quantity of the phantom item.

Unit

The unit of measure used to express the phantom item quantity.

Effectivity Unit Phantom

The effectivity unit code for the phantom item.

Description

The description or name of the code.

Cost Component for Mapping

The code of the cost component for mapping.

Description

The description or name of the code.

Description

The description or name of the code.

Plan

The code that uniquely identifies the plan to which the transaction is linked.

Original Item

The original item linked to the transaction.

Description

The description or name of the code.

Hours Accounting Sequence

The sequence in which the project hours are accounted.

Commitment Sequence

The sequence number of the corresponding commitment.

Text

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

Integration Transaction GUID

The generated internal code (GUID) used for the integration of the financial transaction.

Unique ID

The unique ID of the integration transaction.

Sales
Sales Price

The sales price of the cost object.

Sales Amount

The total sales amount.

Currency

The currency used to express the sales price.

Sales Currency Rate and Rate Factor
Rate Factor
Sales Amountin Home Currency

The sales amount in the home currency.

Currency

The currency used to express the amounts for the transactions.

Rate Date (Sales)

The date on which the exchange rate was valid.

Transaction
Project Costs

Infor LN selects this check box to indicate that the project costs are included in the transaction and that the transaction adds cost to the project.

Note

Infor LN clears this checkbox to indicate that another transaction is created to nullify the costs added to the project by this transaction.

Post to Finance

Infor LN selects this check box to indicate that the costs are posted to Financials. However, all the transactions may not be posted to Financials.

If this check box is selected, the costs are posted to the Project WIP in Financials. You can view the integration transaction in the Integration Transactions (tfgld4582m000) session. The default value of the Integration Document Type is Project Costs & Commitments. These costs are generated from various origins, such as purchase orders, warehouse orders, inventory transfers, project hours, and other types of financial variances such as price and currency variances and surcharges. When the project is closed, these cost transactions are transferred from the project WIP costs to the final project costs using the Project Costs and Commitments/Completion postings.

If this check box is not selected the costs are assigned to the project, but are yet to be posted to the Project WIP. From a financial perspective the costs are still part of one of these ledgers in Financials:

  • Inventory
  • Production WIP
  • Service WIP
  • Goods Delivered Not Invoiced (GDNI)
Run Date

The date when the financial transactions are processed.

Note

This field is applicable only for the transactions originating from Project and that are also approved and processed in Project.

Processing Run

The number generated when the transactions are processed.

Note

This field is applicable only for the transactions originating from Project and that are also approved and processed in Project.

Transaction Origin

The transaction origin.

Transaction Type

The transaction type of the financial document.

Financial Transaction

The status of the financial transaction.

Old-fashioned Flow

Infor LN selects this check box to indicate that the transaction processing is not based on pegging.

Borrow/Loan

Infor LN selects this check box to indicate that the cost peg transfer type of the transaction is borrow/loan (that is temporary transfer of inventory between cost pegs).

In Warehousing, you can transfer the inventory from one project cost peg to another, temporarily, wherein, the inventory that is pegged to a specific project cost peg is borrowed ( Borrow/ Loan - Payback) from one project cost peg and used for another project cost peg during the warehouse outbound procedure. The borrowed items are replenished to the lending cost peg using Payback and generated on receipt of the inventory actually ordered for the borrowing project cost peg.

Document

The code of the document that contains the transaction details.

SettlementOrigin

Infor LN selects this check box to indicate that the transaction is posted as a result of a fluctuation settlement.

Project Completion
Completion Transaction in Finance

Infor LN selects this check box to indicate that the financial result of the transaction is processed in Project using the Process Transactions (tpppc4802m000) session.

Completion Run Date

The date when the financial transactions are completed.

Completion Run

The number generated when the transactions are completed.

Financial Registration Date at Completion

The financial registration date on which the transaction is processed in Project using the Process Transactions (tpppc4802m000) session.

Document
Contract

The code that identifies the contract.

Description

The description or name of the code.

Contract Line

The contract line number.

Description

The description or name of the code.

Purchase Receipt

The sequence number of the purchase receipt.

Warehouse Receipt / Shipment

The warehouse receipt number.

Warehouse Receipt Line Number

The warehouse receipt line number.

Warehouse

The code of the project warehouse.

Warehouse

The code of the warehouse.

Intercompany Trade Order

The company in which the intercompany trade order is created.

Intercompany Trade Order Number

The order number of the intercompany trade order.

Intercompany Trade Order Line Number

The line number of the intercompany trade order.

Employee Company

The logistic company specified for the employee department.

Note
  • This field is mandatory if an employee is linked to the cost transaction.
  • The value of the employee company is zero for transactions that originate from earlier versions.
Description

The name of the company.

Logistic Company of Document

The logistic company that stores the original document.

Description

The description or name of the code.

Reason

The reason code.

Description

The description or name of the code.

Invoice Batch Number

The invoice-sequence number that LN assigns when an invoice is processed based on the corresponding order line.

Buy-from Business Partner

The buy-from business partner for the transaction.

Description

The description or name of the code.

Invoice-from Business Partner
Description

The description or name of the code.

Subcontracting

The code that identifies the subcontracting cost object.

Business Object Name

The business object linked to the transaction.

Business Object Reference

The business object reference linked to the transaction.

Overhead
Overhead Base

The code that identifies the overhead base.

Version

The version number that LN generates based on the unique base code.

Description

The description or name of the code.

Overhead Percentage

The overhead percentage as defined in the Overhead Application Bases (tppdm2100m000) session.

Description

The description or name of the code.

Landed Cost
Landed Cost

The code that identifies landed costs.

Landed Cost Line

The landed cost line number.

Description

The description or name of the code.

Invoice
Approved for Invoicing

Infor LN selects this check box to indicate that the transactions are approved for invoicing.

Transferred to Invoicing

Infor LN selects this check box to indicate that the transactions are transferred to invoicing.

Suppressed for Next Billing Cycle

If this check box is selected, the selected transaction is not invoiced to the business partner.

Note

By default, this check box is cleared.

Financial Document (Sales Invoicing)

The code of the financial document for the sales invoice.

Invoice Type

The code of the invoice type.

Invoice Document

The invoice document number.

Note
  • The Invoicing module identifies an invoice by this field.
  • Infor LN updates this value with the number of the new invoice that is created when you cancel and regenerate the invoice, in Invoicing. When you cancel the invoice, you can only modify the invoice data such as reference, address, and tax number, if required.
  • You can also modify the Billable Amount when you create a credit note for a specific invoice line..
  • Infor LN updates this value with the number of the new invoice that is created when you cancel and regenerate the invoice, in Invoicing.
  • When you cancel the invoice, you can modify the invoice data such as reference, address, and tax number. However, you can also modify the Billable Amount if you create a credit note for a specific invoice line. Only the authorized users (in Invoicing) can modify the amount.
  • The invoice must not be linked to an installment.
  • The status of the project must not be Closed.
Invoice Line

The sequence number of the invoice line.

Financial Document

The code of the financial document.

Document

The code of the financial document for invoicing.

Line Number

The line number of the financial document.

Sequence Number

The sequence number of the financial document.

Holdback

Infor LN selects this check box to indicate that holdback is applicable.

Holdback Number

The code of the holdback number.

Billable

Infor LN selects this check box to indicate that the transactions are billable.

Company
Entity

The type of entity for the transaction.

Allowed values

Entity type

Entity

The code of the entity type.

Enterprise Unit

The enterprise unit responsible for the delivery specified on the transaction line.

Description

The description or name of the code.

Project Financial Company

The code of the receiving company.

Description

The description or name of the code.

Intercompany

Infor LN selects this check box to indicate that intercompany transactions are linked to the transaction line.

Financial Company Transaction Origin

The code of the financial company in which the transaction is originally created.

Description

The description or name of the code.

Period
Cost Control Period

The code that identifies the cost control period for the transaction.

Year

The cost control year in which the transaction is posted to cost history.

Period

The period in which the transaction is posted to cost history for cost control.

Financial Control Period

The code that identifies the financial period for the cost transaction.

Fiscal Period

The year of the period in which the transaction is posted to Financials.

Period

The period in which the transaction is posted to Financials.

Hours Control Period

The period code used for the hours control period.

Note

This field is applicable only for the transactions with the cost type set to Labor.

Period for Actual Hours Control

The period that identifies the actual hours control period.

Note

This field is applicable only for the transactions with the cost type set to Labor.

Year

The year together with the period number, identifies the actual hours control period.

Note

This field is applicable only for the transactions with the cost type set to Labor.

Registration Date

The date and time when the transaction line is registered.

Financial Registration Date

The financial registration date on which the transaction is processed in Project.

Tax
Tax Classification

The tax classification for the transaction.

Description

The description or name of the code.

Exempt

If this check box is selected, the tax code represents tax exemption.

Tax Country

The tax country for the transaction.

Description

The description or name of the code.

Own Tax Number

The tax number allotted by the government.

Tax Code

The tax code for the transaction line.

Description

The description or name of the code.

BP Tax Country

The tax country defined for the business partner.

Description

The description or name of the code.

BP Tax Number

The tax number allotted by the government to the sold-to business partner.

Tax Exemption Certificate

The tax exemption certificate number, if tax is exempted for the transaction.

Tax Exemption Reason

The code that identifies the reason for tax exemption.

Description

The description or name of the code.

Cost Text

The additional text related to the transaction.

 

Cost Transactions

Displays all cost transactions.

Ledger Transactions

Displays all ledger transactions.

Borrow/Loan Balance

Displays all the borrow/loan transactions.

All Transactions

Displays all transactions.