Financial Transactions (tpppc2100m100)
Use this session to view the financial transactions for a specific project.
- 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.
- You can use the Revenue Document Lines option to view the Revenue Document Lines (cirrc1110m000) session. This option is enabled only if the Posting Type is set to Cost of Sales Recognition or COS Invoiced (Project).
Field Information
- Project
-
The project code.
- Description
-
The description or name of the code.
- Project Status
-
The 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.
- Variation Line
-
The variation line number.
- Call-Off Line
-
The call-off line number.
- 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
-
The 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
- Additional Calculation Office Variance
- Shipment Variance Intercompany (Project)
- General Costs Intercompany
- Material
- Material Intercompany
- Value Correction
- Repair Warranty Costs
- WIP Hours
- Warranty Costs
- WIP Costs (through Financials)
- WIP Transfer Issue
- WIP Transfer Receipt
- WIP Transfer Receipt Intercompany
- Warehouse Surcharge Issue
- Warehouse Surcharge Receipt
- Cost of Sales
- Goodwill
- Tool Costs
- Tool Costs Intercompany
- Issue Intercompany (Project)
- Adjustment
- Landed Costs
- Landed Costs Variance
- Landed Costs Invoiced
- Landed Costs Variance Invoiced
- Invoiced WIP
- Issue (Project)
- Loan Result
- Sales Order Price Variance
- COS Intercompany
- Planned Stage Payment
- Released Stage Payment
- Receipt (Stage Payment)
- Loan
- Borrow
- Payback Result
- Receipt Variance (Stage Payment)
- Cost Peg Reallocation (Stage Payment)
- Currency Variance (Stage Payment)
- Approval (Claim)
- Expense Tax (Stage Payment)
- Loan Reversal
- Borrow Reversal
- Currency Variance
- WIP Quarantine Issue
- Quarantine Adjustment
- Currency Variance (Landed Costs)
- Revenues Intercompany
- COS Price Variance
- WIP Costs Intercompany
- WIP Hours Intercompany
- Expenses Intercompany
- Landed Costs Intercompany
- Landed Costs Invoiced Intercompany
- Receipt Intercompany (Stage Payment)
- Direct Receipt Intercompany
- Variance Intercompany
- COS Variance
- Work Order Price Variance
- Cost of Sales Recognition
- COS Invoiced (Project)
- Soft Commitment (Project Control)
- Soft Commitment (Project Control) - Rev
- Receipt (Project Warehouse)
- Matched Receipt
- Project Control
- Inventory
- Cost Invoice
- Price Variance - Rev
- Expense Tax
- Landed Costs Expense Tax
- Purchase Invoice
- Landed Costs without Invoice
- Field Service Cost
- Labor Cost
- Hours (Subcontracting)
- Manual Sales
- Surcharge on Soft Commitment
- Surcharge on Hard Commitment (Project)
- Surcharge on Cost
- Applied Overhead
- Direct Delivery Issue
- Stage Payment Invoice
- Cost Peg Reallocation (Expense Tax)
- Currency Gain and Loss
- Direct Delivery Issue Intercompany
- Direct Delivery Variance
- Direct Delivery
- Issue Result
- Expenses
- Variance Adjustment
- Freight Price Variance
- Field Change Order Costs
- Freight Costs
- General Costs Variance
- General Costs (through Financials)
- General Costs
- General Costs Work Order
- Interim Result
- Issue
- Issue Intercompany
- Item Surcharge Receipt
- Item Surcharge Issue
- On Order
- Operation Costs
- Price Variance
- Transfer from Service WIP
- Contract
- Quarantine Receipt
- Purchase Price Variance
- Receipt
- Rejection
- Revaluation
- Revenues
- Revenues Analysis
- Reverse Interim Result
- Receipt Intercompany
- Shipment Variance
- Subcontracting
- Subcontracting WIP
- Rejection Intercompany
- Subcontracting Intercompany
- Operation Costs Intercompany
- General Costs Work Order Intercompany
- AFP Commitment
- Standard Cost Result
- Origin
-
The source document type.
Allowed values
- Production Order
- Not Applicable
- Warehouse Order
- Service Order
- PRP Purchase Order
- PRP Warehouse Order
- Purchase Order
- Service Call
- Service Contract
- Financial Document
- Warehouse Transfer
- Production Batch
- Sales Order
- Assembly Part Demand
- Purchase Order (Manual)
- Warehouse Transfer (Manual)
- Maintenance Sales Order
- Maintenance Work Order
- Freight
- Cycle Counting Order
- Adjustment Order
- Revaluation Order
- Production Schedule
- Production Kanban
- Project
- Project (Manual)
- Purchase Schedule
- Warehouse Transfer (Distribution)
- Sales Schedule
- Inventory Ownership Change Order
- Buy-From BP Transfer (Purchase)
- Buy-From BP Transfer (Schedule)
- Sold-To BP Transfer (Sales)
- Sold-To BP Transfer (Schedule)
- Sold-To BP Transfer (WH Manual)
- Sold-To BP Transfer (Manual)
- ASC Production Order
- Sold-To BP Transfer (WH Distribution)
- Planned Cost Peg Transfer
- Cost Peg Transfer
- Contract
- Services Procurement Order
- Document
-
The code that identifies the order number.
- Order Line
-
The position number of the order line.
- Cost Rate
-
The standard cost per unit.
- Cost Amount
-
The total cost amount for the transaction.
- Cost Currency
-
The currency code.
- Original Document Amount in 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 Rate and Rate Factor
-
The project currency rate.
- Rate Factor
-
The rate factor
- Amount of Time
-
The number of time units. For example, the number of days that a crane is used for a project.
- Time 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
- Document Date
-
LN uses the rate that is valid on the date and time on which the documents are created. The Document Date rate determiner applies to all types of transactions. You can manually change the rate.
The rate is updated by Invoicing when the invoice is posted.
- Manually Entered
-
You can manually enter the rate. By default, LN uses the rate that is valid on the date and time on which the documents are created. The Manually Entered rate determiner applies to all types of transactions.
- Delivery Date
-
If the goods are not yet delivered, LN uses the rate that is valid on the order date. However, if this order date is in the past, LN uses the rate that is valid on the current date.
If the goods are delivered, LN uses the rate that is valid on the actual delivery date.
The Delivery Date rate determiner only applies to sales orders, service orders, and sales invoices. You cannot manually change the rate.
- Receipt Date
-
LN uses the rate that is valid on the date and time on which you expect to receive the goods. The Receipt Date rate determiner only applies to purchase orders and purchase invoices. You cannot manually change the rate.
- Expected Cash Date
-
LN uses the rate that is valid on the date and time at which payment of the sales invoice or purchase invoice is expected.
Expected cash date = expected delivery/receipt date + payment period
The payment period is specified in the Payment Terms (tcmcs0113s000) session. The Expected Cash Date rate determiner applies to all types of transactions. You cannot manually change the rate.
The rate is updated by Invoicing when the invoice is posted.
- Fixed
-
You can use this rate determiner only for a dependent currency system or a single currency system. The Fixed rate determiner applies to all types of transactions.
If you manually enter the rates between the transaction currency and the reference currencies, the rate is fixed. If you do not manually enter the rates, the rate is not fixed and LN uses the rate that is valid on the date and time on which the documents are created.
- Fixed Hard
-
You can use this rate determiner only for an independent currency system. The Fixed Hard rate determiner applies to all types of transactions.
If you manually enter the rate between the transaction currency and the reporting currencies, the rates are fixed. The local currency rate is based on the document date of the actual document.
If you do not manually enter the rate between the transaction currency and the reporting currencies, the rates are not fixed and LN uses the rates that are valid on the date and time on which the documents are created.
- Fixed Local
-
You can use this rate determiner only for an independent currency system. The Fixed Local rate determiner applies to all types of transactions.
If you manually enter the rate between the transaction currency and the local currency, the rate is fixed. The other rates are based on the document date of the actual document.
If you do not manually enter the local currency rate, the rate is not fixed and LN uses the rate that is valid on the date and time on which the documents are created.
- Fixed Local and Hard
-
You can use this rate determiner only for an independent currency system. The Fixed Local and Hard rate determiner applies to all types of transactions.
If you manually enter the rate between the transaction currency and the home currencies, the rates are fixed. The local currency rate is based on the document date of the actual document.
If you do not manually enter the rates between the transaction currency and the home currencies, the rates are not fixed and LN uses the rates that are valid on the date and time on which the documents are created.
- 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.
- Extension 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
-
The effectivity unit code.
- 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.
- Sales Currency
-
The currency used to express the sales price.
- Sales Currency Rate and Rate Factor
- Rate Factor (Sales)
-
The rate factor
- Sales Amount in 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
-
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: 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
-
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)
- Receipt Expense Tax
-
Indicates if the financial transaction is related to expense tax.
Note: This check box is displayed only if the At Receipt check box is selected in the Consume Expense Tax in Inventory / WIP section of the ACP Parameters (tfacp0100m000) session. - 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 Financial Transaction
-
The transaction type of the financial document.
- Financial Transaction
-
The status of the financial transaction.
- Old-fashioned Flow
-
LN selects this check box to indicate that the transaction processing is not based on pegging.
- Borrow/Loan
-
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.
- Settlement Origin
-
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
-
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 / Shipment Line
-
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
-
The invoice-from business partner code.
- 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
-
LN selects this check box to indicate that the transactions are approved for invoicing.
- Transferred to Invoicing
-
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.
- Transaction Type
-
The code of the invoice type.
- Invoice Document
-
The invoice document number.
Note:- The Invoicing module identifies an invoice by this field.
- 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 Invoice Amount when you create a credit note for a specific invoice line..
- 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.
- Sales Invoice Line
-
The sequence number of the invoice line.
- Financial Document
-
The code of the financial document.
- Document Financial Transaction
-
The code of the financial document for invoicing.
- Line Number Financial Transaction
-
The line number of the financial document.
- Sequence Number Finance
-
The sequence number of the financial document.
- Holdback
-
LN selects this check box to indicate that holdback is applicable.
- Holdback Sequence Number
-
The code of the holdback number.
- Billable
-
LN selects this check box to indicate that the transactions are billable.
- Company
-
- Entity
-
The type of entity for the transaction.
Allowed values
- Sales Office
- Shipping Office
-
shipping office
- Project Management Office
- Production Department
-
production department
- Purchase Office
- Not Applicable
- Service Department
- Work Center
- Warehouse
- Project
- Accounting Office
-
accounting office
- Contract
- Inventory Management Department
-
Inventory management department
- 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
-
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.
- Cost Control Year
-
The cost control year in which the transaction is posted to cost history.
- Cost Control 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 Year
-
The year of the period in which the transaction is posted to Financials .
- Fiscal 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. - Year Hours Accounting
-
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. - Period Hours Accounting
-
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 of the company.
Note:- This is a display field.
- LN populates this value based on the:
- The Financial company that is linked to the Sales Office of the contract line.
- The Tax country linked to the contract line.
- The Reference date from which the tax is applicable. Usually, the invoice date is considered as the reference date.
- 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.
- Exemption Certificate
-
The tax exemption certificate number, if tax is exempted for the transaction.
- 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.