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 standard cost 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.
Note

You can only specify a cost component for which the Component Type is set to Detail or Collect in the Cost Components (tcmcs0148m000) session.

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.