Invoices (cisli3105m000)

Field Information

Financial Company

The financial company in which the invoice exists.

Sales Invoice Transaction Type

The transaction type of the sales invoice.

If this field is empty, the original invoice has not yet been printed and the invoice is identified by a temporary sequence number.

Invoice Number

The invoice document number.

On Hold

Not Applicable

Canceled

Confirmed

Ready to Submit

Pending Approval

Ready to Print

Submitted to External System

Rejected by External System

Approved by External System

Printed

Posted

Invoice Status

On Hold

Not Applicable

Canceled

Confirmed

Ready to Submit

Pending Approval

Ready to Print

Submitted to External System

Rejected by External System

Approved by External System

Printed

Posted

Default value

On Hold

QR-bill

Indicates if the invoice is a QR-bill with IBAN or QR-IBAN. This is used for QR-billing for Switzerland.

Workflow Status

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

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

• 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 execute the required action for the business object.

Allowed values

Note: For more information on setting up and using ION Workflow for business objects in LN, refer to the Infor LN Integration Guide for Infor ION Workflows and Monitors.

Series

The invoice sequence number.

Related Invoice Number

The financial company from which the related invoice originates.

Related Transaction Type

The transaction type of the related invoice.

Related Invoice Number

The document number of the related invoice.

Link to Monthly Billing Invoice

If this check box is selected, LN includes the invoice in a monthly billing invoice.

If the Send MBI check box in the Invoice-to Business Partner (tccom4112s000) session is selected, this check box is selected by default.

Asset Disposal

If this check box is selected, the invoice is related to the disposal of an asset.

ABC Transaction

If this check box is selected, the invoice applies to trade of type Direct Delivery or External Material Delivery Sales.

Self-Billing

If this check box is selected, self-billing applies.

Receive Invoice

If this check box is selected, self-billed invoices are electronically received and its data is automatically entered in the self-billed invoice tables.

Tax Invoice Data Exists

If this check box is selected, tax on separate invoice tax code is used. This indicates there is a corresponding tax invoice.

Bank Relation

The code of the bank relation. The default value is retrieved from the Billable Lines (cisli8110m000) session, if specified, and otherwise from the Default Bank Relations (tccom1551m000) session.

Note: 

• • This field is can be maintained if the Invoice Status field is set to a status other than Ready to Submit or Ready to Print, and the field Allow Change Invoicing Data is set to Yes for the user
• The value of the bank relation is not allowed if the currency defined in the Bank Relations (tfcmg0510m000) session differs from the invoice currency, and the field Other Currencies allowed is set to No.

Document Type

Invoice

Credit Note

Advance Invoice

Advance invoice installments must be invoiced and paid for by the customer before goods can be delivered.

The following applies to an advance invoice:

• The invoice is a legal document and therefore the amount is posted as recognized revenue through the applicable integration document type
• It is included in the sales listing and the tax declaration
• The sales statistics are updated; the type of revenue is qualified as intermediate revenue

Advance Payment Request

A request to a business partner to pay a certain amount or percentage in advance before goods can be delivered.

The following applies to an advance payment request (APR):

• The invoice is not a legal document and therefore the APR amount does not affect the revenue.
• An open entry is created for the amount, which is posted to the Control Account (Advance Invoice/Payment Request) as specified in the Control Accounts by Business Partner Group (tfacr0515m000) session. The transaction type and series used to create the financial document for the Advance Payment Request invoicing scenario, are retrieved from the Invoicing Transaction Types (cisli0101m000) session.
• No VAT is calculated, printed, and posted and the amount is not included in the sales listing.
• The APR amount is settled with the goods deliveries after the VAT is calculated for the delivered goods.
• No recognized, temporary, or intermediate revenue is available for the APR amount. Therefore, the sales statistics cannot be updated.
• No link exists between the APR line and invoice related data such as monthly billing invoicing, and late payment surcharges.

Pay-from Receipt

Correction

Sales Invoice Company

The financial company in which the sales invoice was generated.

Invoice Line Type

The invoicing scenario that was linked to the source type in the Invoicing Transaction Types (cisli0101m000) session.

Invoicing Scenario

The invoicing scenario that was linked to the source type in the Invoicing Transaction Types (cisli0101m000) session.

Stamp Tax Applies

If this check box is selected, the stamp tax is applied to the invoice line. The stamp tax is applied only if:

• one or more invoice lines have a tax code that is specified in the Tax Codes for Stamp Tax (tcmcs1133m000) session.
• an effective stamp tax detail is available in the Stamp Tax for Invoices (tcmcs1131m100) for the specified tax country.
• the invoice amount exceeds the threshold amount specified in the Stamp Tax for Invoices (tcmcs1131m100) session.

Customer Invoice

The invoice number used by the customer. This number is used in the Composing Reference field in the Billable Lines (cisli8110m000) session.

Bank Account Code

bank account

bank account

international bank account number

Rate Determiner

The currency exchange rate used to convert the invoice currency to the home currency.

/

The invocing batch to which the invoice belongs.

Currency Rate

rate factor

Exchange Rate Type

exchange-rate type

Financial Department

The financial department of the order.

Dimensions

Dimension Code 1 - 12

dimension

Tax Code

tax code

Department

The department with which the invoice line is associated.

Sales Representative

The sales representative dealing with the invoice.

Manual Sales Invoice

The number of the sales invoice which is generated manually.

Line of Business

The line of business of the business partner.

Area

The area of the business partner.

Positive Amount

The value displayed depends on the Combine Positive and Negative Order Lines setting in the Invoicing Methods (tcmcs0155s000) session.

Setting	Displayed Value
Cleared	Yes for positive amounts
Cleared	No for negative amounts
Selected	Not applicable

Delivery Note

delivery note

Sold-to Business Partner

sold-to business partner

Sold-to Address

The address of the sold-to business partner.

Ship-to Business Partner

ship-to business partner

Ship-to Address

The address of the ship-to business partner.

Source Type

The source document type.

Invoice-to Business Partner

invoice-to business partner

Order Number

The source document number.

Service Type

service type

Installation Group

The installation group to which the invoice refers.

Sales Order

The sales order number.

Sales Order Type

sales order type

Installment

installment

Rebate

rebate

Invoice-to Address

The address to which the invoice is sent.

This is the address of the invoice-to business partner, or your own company's address.

Shipment

The shipment of the sales component line to be invoiced.

Freight Order

freight order

Contract

The code that identifies the contract.

Contract Line

The contract line number.

Project

The code that identifies the project.

Project Document

The project document number.

Service Order

service order

Invoice Date

The date and time when the invoice was created.

Note: 

• If the status of the line is Ready to Print, you can change the invoice date to the current date or to another date in the past, as required.
• If material pricing data exists, you cannot change the invoice date.

Service Order Type

service type

Service Order Installation

configuration

Maintenance Sales Order

maintenance sales order

MSO Type

service type

MSO Installation

configuration

Service Contract

The code of the service contract.

Service Contract Type

contract type

Service Call

call

Service Call Installation

configuration

Tax Date

The tax date. The tax date is determined based on the value you set in the Tax Date parameter in the Invoicing Parameters (cisli0100m000) session.

Note: If the order date or delivery date is not specified on the billable lines, this value is determined based on the invoice date.

Due Date

due date

Settlement Tax Date

This setting determines if and how tax on installment invoices is corrected in the settlement invoice.

Risk Transfer Date

risk transfer date

Note: The number of days that this date can be shifted either forward or backward compared to the invoice date, depends on the Risk Transfer Time Fence setting in the Invoicing Parameters (cisli0100m000) session.

Blocked for Posting

If this check box is selected, the invoice line cannot be posted to the General Ledger .

Store Advance Payments

If this check box is selected, LN stores the advance payments when the payments are processed for the revenue invoice document.

Note: 

This field is applicable only if :

• either the Project (TP) check box is selected for the logistic company or installment is implemented for Sales Order, Service Order or Maintenance Sales.
• Invoice Line Type is set to either Advance Invoice or Advance Payment Request

Use Advance Payment Rates for Revenue

If this check box is selected, LN considers payment rates as defined by IFRS for revenue recognition .

Note: 

This field is applicable only if:

• Store Advance Payments check box is selected.
• either the Project (TP) check box is selected for the logistic company or installment is implemented for Sales Order, Service Order or Maintenance Sales.
• Separate Account for Paid Advance Installments check box is selected in the Finance Company Parameters (tfgld0503m000) session.

Update Tax Register

If you use a tax provider and this check box is selected, the data in the tax register for the tax provider interface has been updated.

Source Line Amount

The amount on the original invoice line.

EDI or Print Invoice

Indicates whether the invoice was sent through electronic data interchange (EDI) or printed.

Bank Reference Number

If you use bank reference numbers, this is the bank reference number of the invoice.

Payment Slip Reference Number

The bank reference on the payment slip.

Private Key Version

A key used to generate the signature required by the Portuguese tax authorities.

RSA Signature

A signature based on the RSA asymmetric encryption algorithm.

For this signature, the following concatenated data is used:

• Financial Company
• Invoice Date
• Transaction Entry Date
• Transaction Type
• Document Number
• Gross Amount
• Previous signature for the transaction type and series in printable single-byte characters, size 172.

External UUID

The external invoice document ID which indicates the ATCUD number for Sales Invoices and Receipt Acknowledgements (for Portugal).

Note: This value is defaulted from the External UUID field of the Document Identifiers and Signatures (tcgen1500m000) session.

Rate Date

The currency rates valid on this date apply to the invoice line.

Deduction Amount

The sum of the total order discount amount, total line discount amount, and total invoiced amount variance.

LPS Date

The date of the late payment surcharge that applies to the invoice.

First Discount Date

The date of the first invoice discount.

Second Discount Date

The date of the second invoice discount.

Net Amount

The net amount in the invoice currency.

Third Discount Date

The date of the third invoice discount.

Invoiced Installments

The amount of installments that were already invoiced.

Installments to be Invoiced

The amount of installments that must be invoiced.

Advance Amount

The advance amount already invoiced.

Overpaid Amount

The overpaid amount in the invoice currency.

Fiscal Year

The fiscal year in which the invoice is generated. When composing the invoice, the fiscal year is determined based on the value set in the Date for Fiscal / Reporting Periods parameter in the Invoicing Parameters (cisli0100m000) session.

Note: 

• If the order date or delivery date is not specified on the billable lines, this value is determined based on the invoice date.
• This field is applicable only if the Date for Fiscal / Reporting Periods field in the Invoicing Parameters (cisli0100m000) session is not set to Transaction Entry Date.
• You can modify the year/period on the header level if the year/period is Open and the Invoice Status is set to Printed. The changed year and periods are used when invoice is posted for the open entry batch. However, the integration transactions does not use the modified year and period.

Fiscal Period

The fiscal period in which the invoice is generated. When composing the invoice, the fiscal period is determined based on the value set in the Date for Fiscal / Reporting Periods parameter in the Invoicing Parameters (cisli0100m000) session.

Note: 

• If the order date or delivery date is not specified on the billable lines, this value is determined based on the invoice date.
• This field is applicable only if the Date for Fiscal / Reporting Periods field in the Invoicing Parameters (cisli0100m000) session is not set to Transaction Entry Date.
• You can modify the year/period on the header level if the year/period is Open and the Invoice Status is set to Printed. The changed year and periods are used when invoice is posted for the open entry batch. However, the integration transactions does not use the modified year and period.

Reporting Year

The reporting year in which the invoice is generated. The reporting year is determined based on the value set in the Date for Fiscal / Reporting Periods parameter in the Invoicing Parameters (cisli0100m000) session.

Note: 

• If the order date or delivery date is not specified on the billable lines, this value is determined based on the invoice date.
• This field is applicable only if the Date for Fiscal / Reporting Periods field in the Invoicing Parameters (cisli0100m000) session is not set to Transaction Entry Date.
• You can modify the value in this field on the header level if the Invoice Status is set to Printed. The modified year/period must be an open year/period, else the change is not allowed. The changed year and periods are used when invoice is posted for the open entry batch. However, the integration transactions does not use the modified year and period.

Reporting Period

The reporting period in which the invoice is generated. The reporting period is determined based on the value set in the Date for Fiscal / Reporting Periods parameter in the Invoicing Parameters (cisli0100m000) session.

Note: 

• If the order date or delivery date is not specified on the billable lines, this value is determined based on the invoice date.
• This field is applicable only if the Date for Fiscal / Reporting Periods field in the Invoicing Parameters (cisli0100m000) session is not set to Transaction Entry Date.
• You can modify the year/period on the header level if the year/period is Open and the Invoice Status is set to Printed. The changed year and periods are used when invoice is posted for the open entry batch. However, the integration transactions does not use the modified year and period.

Tax Year

The tax year in which the invoice is generated.

Note: 

• If the order date or delivery date is not specified on the billable lines, this value is determined based on the invoice date.
• This field is applicable only if the Tax Period Derived From field in the Invoicing Parameters (cisli0100m000) session is not set to Transaction Entry Date.
• You can modify the year/period on the header level if the year/period is Open and the Invoice Status is set to Printed. The changed year and periods are used when invoice is posted for the open entry batch. However, the integration transactions does not use the modified year and period.

Tax Period

The tax period in which the invoice is generated.

Note: 

• If the order date or delivery date is not specified on the billable lines, this value is determined based on the invoice date.
• This field is applicable only if the Tax Period Derived From field in the Invoicing Parameters (cisli0100m000) session is not set to Transaction Entry Date.
• You can modify the year/period on the header level if the year/period is Open and the Invoice Status is set to Printed. The changed year and periods are used when invoice is posted for the open entry batch. However, the integration transactions does not use the modified year and period.

Tax Amount in Tax Currency

The total tax amount expressed in the tax currency.

Tax Currency

The currency in which the tax reporting is processed.

Tax Currency Rate Type

The exchange rate type used for converting the invoice currency tax amounts to tax reporting currency amounts.

Rate to Tax Currency

The rate used for converting the invoice currency tax amounts to tax reporting currency amounts.

Rate Factor to Tax Currency

The rate factor determined based on the exchange rate type and rate date for conversion of invoice currency to tax reporting currency. If the tax currency is a home currency, the rate factor on billable line for this home currency is considered.

Tax Currency Rate Determiner

The rate determiner used for the tax currency rate conversion.

Tax Currency Rate Date

The rate date that is used for converting the invoice currency taxable amount to tax reporting currency.

Tax Amount

The tax amount in the invoice currency.

LPS Amount

The late-payment surcharge amount in the invoice currency.

First Invoice Discount

The discount amount that applies to the first invoice.

Second Invoice Discount

The discount amount that applies to the second invoice.

Third Invoice Discount

The discount amount that applies to the third invoice.

Invoice Amount

The invoice amount in the invoice currency.

Rounding Difference Amount

The rounding difference of the invoice, in the home currency.

The amount on the original invoice line in the home currency.

home currency

The discount amount in the home currency.

The net amount in the home currency.

Tax Amount in Home Currency

The tax amount in the home currency.

LPS Amount in Home Currency

The late-payment surcharge amount in the home currency.

First Discount Amount in Home Currency

The discount amount that applies to the first invoice expressed in the home currency.

Second Discount Amount in Home Currency

The discount amount that applies to the second invoice expressed in the home currency.

Third Discount Amount in Home Currency

The discount amount that applies to the third invoice expressed in the home currency.

Invoice Amount in Home Currency

The invoice amount in the home currency.

Rounding Difference Amount in Home Currency

The rounding difference of the invoice, in the home currency.

Pay-by Business Partner

The pay-by business partner of the invoice.

Original Pay-by Business Partner

If the invoice is factored with recourse, this field contains the pay-by business partner that is linked to the invoice-to business partner of the invoice.

Pay-by Address

The address of the pay-by business partner.

Payment Terms

payment terms

Late Payment Surcharge

late payment surcharge

Payment Method

payment method

Invoicing Method

invoicing method

Invoice Layout

An invoice layout configured in the Invoice Layouts (cisli1150m000) session.

Invoice Delivery Method

invoice delivery method

Sales Type

The sales type of the sales order.

Tax Country

tax country

Tax Country

The business partner's tax country.

Tax Period

financial period

Approval Date

The date that the invoice was approved.

Composing Reference

Technical field used for combining multiple lines.

Transaction Type

The transaction type of the sales invoice.

If this field is empty, the original invoice has not yet been printed and the invoice is identified by a temporary sequence number.

Intercompany Trade Scenario

The intercompany trade scenario.

Allowed values

External Material Delivery Sales

The ownership of the goods changes from an internal financial entity to an external business partner (or affiliated company) based on an order of another internal financial entity, which invoices the external customer.

Example

Sales office S1 and warehouse W1 are part of organization A, but are located in different countries. To fulfill a sales order to an external customer, S1 instructs W1 to deliver the goods to the customer. The warehouse W1 sends an internal invoice to sales office S1 to cover the costs for the goods and the delivery.

Supported price origins

• Cost-Plus
• Commercial Price
• Sales Order Price (Gross)
• Sales Order Price (Net)
• Sales Order Customs Value
• Profit Split (Gross)
• Profit Split (Net)

External (Material) Delivery Purchase

The ownership of the goods changes from an external supplier (which can be an affiliated company) to an internal financial entity based on an order of another internal financial entity, which is invoiced by the external supplier.

Example

A multinational organization has a central purchase office that buys materials for its production plants located in various countries. The purchase office buys the materials from external suppliers. The production plants are modeled as separate financial entities. The purchase office charges the production plants internally for the costs it made.

To charge the production plants, the central purchase office sends intercompany trade orders to the production plants. The charges can be based on various pricing rules, such as the purchase price paid to the external supplier.

Supported price origins

• Cost-Plus
• Commercial Price
• Purchase Order Price (Gross)
• Purchase Order Price (Net)

This scenario is applicable if Order Management and Service are implemented.

Project (PCS) Delivery

Invoicing between a project calculation office and a warehouse or other departments.

Supported price origin: Cost-Plus

WIP Transfer

In case of WIP transfers, work in progress is transferred from one work center to another work center. Each work center is defined as an entity. Each entity belongs to a different internal financial entity. The shipping work center invoices the receiving work center, because ownership changes directly from one internal financial entity to another internal financial entity. Supported price origin: Cost-Plus (without markup).

External Material Direct Delivery

The ownership of the goods changes from one external legal entity to an external business partner based on two orders, for example a sales order and a purchase order, from different internal legal entities.

Example

To fulfill a sales order for an external customer, sales office A instructs purchase office A1 to purchase goods from an external supplier. The supplier delivers the goods directly to the external customer. Sales office A invoices the external customer. The external supplier invoices purchase office A1. To be compensated for the costs incurred, purchase office A1 sends an internal invoice to sales office A.

Supported price origins

• Cost-Plus
• Commercial Price
• Sales Order Price (Gross)
• Sales Order Price (Net)
• Sales Order Customs Value
• Purchase Order Price (Gross)
• Purchase Order Price (Net)
• Profit Split (Gross)
• Profit Split (Net)

Internal Material Delivery

Goods and the related ownership are transferred from one internal financial entity to another internal financial entity. For example, a warehouse transfer in which goods are transferred from one warehouse to another. Both warehouses are defined as entities. In this scenario, the shipping entity incurs costs on behalf of the receiving entity, or invoices the receiving entity.

Supported price origins

• Cost-Plus
• Commercial Price

Note: 

Also used as Time and Material subscenario of the Subcontracting Depot Repair scenario, in which case the supported price origins are:

• Cost-Plus
• Commercial Price
• Zero Price

Freight

Freight costs are invoiced by a shipping office to a warehouse, sales office, or other department.

If a freight order is created for an order, such as a sales order, transfer order, or purchase order, the shipping office pays the freight costs. If specified, to be compensated for the freight costs the shipping office sends an internal invoice to the sales office, warehouse or purchase office on whose behalf the freight costs are incurred. The shipping office and the other departments are defined as entities.

In this scenario, a shipping office is the selling entity and a warehouse, sales office or other department is the buying entity on the intercompany trade order.

See Intercompany trade scenario Freight - process and setup and Internal and external freight invoicing.

Supported price origins

• Cost-Plus
• Commercial Price

Subcontracting Depot Repair

Operations or activities are carried out by one financial entity on behalf of another financial entity and costs are incurred, for example, material or labor, for these operations or activities.

Example

A work order to repair an item, linked to a maintenance sales order of another financial entity.

Supported price origins:

• Time and Material
• Commercial Price

Expenses

The intercompany trade scenario Expenses is used to determine the intercompany trade amount that the department of the employee who made the expenses charges internally to the department on whose behalf the expenses are made.

Supported price origins

• Cost-Plus
• Commercial Price
• Zero Price

Labor

The intercompany trade scenario Labor is used to determine the intercompany trade amount that the department of the employee who books the hours charges internally to the department on whose behalf the hours are booked.

This scenario is also used as a Time and Material subscenario of the Subcontracting Depot Repair scenario.

Supported price origins

• Cost-Plus
• Commercial Price

Other

Time and Material subscenario of the Subcontracting Depot Repair scenario.

Supported price origins

• Cost-Plus
• Zero Price