Invoice - Lines (cisli3110m000)

Use this session to view invoice lines and their details.

 

Invoice Number

The financial company in which the invoice exists.

/

The transaction type and series used to generate document numbers for the invoices.

The transaction category must be Sales Invoices.

LN generates the invoice document numbers when you print the original invoices. Until that moment, the invoicing data is identified in Invoicing by a temporary sequence number.

/

The sales invoice document number.

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.
Invoice Status

Invoicing Status

  • On Hold
    • Billable lines
      The invoicing data cannot be selected for invoicing. You must confirm the invoicing data before you can generate the invoices.
    • Invoices
      The status of the original invoice when an invoice with status Posted is reversed using the Credit and Rebill command in the Invoices (cisli3105m000) session.
    Note
    • If Workflow is implemented, the On Hold status applies to all transferred billable lines with negative amounts.
    • A billing request with the On Hold status can be processed in the Compose/Print/Post Invoices (cisli2200m000) session. For more information, refer to Billing request status.
  • Canceled

    The invoicing data line has been canceled. If you undo the cancellation, the invoicing data status is set to On Hold.

  • Confirmed

    The invoicing data can be selected for invoicing when you process a billing request in the Compose/Print/Post Invoices (cisli2200m000) session.

    Note

    If Workflow is implemented, a billable line will receive status Confirmed only after approval through the workflow process.

  • Ready to Submit

    Applicable if Workflow is implemented.

    This status matches the Ready to Print status, except that the invoice must first be approved.

    You can print a draft invoice to check the invoice. If the draft invoice is not correct, you can undo the composition of the invoice. The invoicing data status is then reset to Confirmed.

  • Pending Approval

    Applicable if Workflow is implemented.

    This status indicates that the invoice has been submitted for approval. As a result, the invoice can no longer be changed.

    An invoice with status Pending Approval is excluded from any processing in Invoicing.

  • Ready to Print

    The invoice is ready for printing. LN has generated a temporary sequence number to identify the invoice. You can change the invoice date to the current date or to another date in the past, as required. The invoice will then be recalculated.

    You can print a draft invoice to check the invoice or you can print an original invoice and send it to the invoice-to business partner. If the draft invoice is not correct, you can undo the composition of the invoice. The invoicing data status is then reset to Confirmed.

  • Printed

    An original invoice has been printed that you can send to the customer. LN has replaced the temporary invoice sequence number with the original invoice document number.

    The invoice is final and you must post the invoice. You cannot undo the composition and change the invoicing data. You can reprint the original invoice if this is necessary.

    Note

    For tax invoices, the invoice number assigned during composing is also the final invoice number.

  • Posted

    The invoice has been sent to the customer and posted to Financials. An open entry has been created in Accounts Receivable.

    You can reprint the original invoice if this is necessary, or you can use the Purge Sales Invoice Data (cisli3210m000) session to remove the invoice data from Invoicing.

    Note

    The Posted status does not apply to billable lines, because these are removed when the related invoice is posted.

Line

The invoice line number.

Source Company

The source company.

Source Type

The source document type.

Order Number

The source document number.

Order Line

The line number of the order data.

Source Document

The source company.

Order
Order
Item
Description

The item description.

Line Description

A description of the invoice line.

Lot

A number of items produced and stored together that are identified by a (lot) code. Lots identify goods.

Serial Number
First Reference

A text used to identify the invoice.

Second Reference

An additional text used to identify the invoice.

Delivery
Warehouse

The warehouse in which delivered goods are received.

Delivery Point
Shipment

All goods that are transported to a specific address on a specific date and time by using a specific route. An identifiable part of a load.

/

An entity that provides information about one of the items listed on a shipment, such as the weight, the quantity, or the additional costs.

Delivered Quantity
Weight

If a delivery note is present, this is the weight of the load as stated on the delivery note. Otherwise, the weight of the shipment.

The unit in which the weight is expressed.

Delivery Terms
Point of Title Passage
Business Object Details
Business Object Name

In the context of financial integration transaction processing, a business object is a logistic entity or event such as an item, a purchase order, a business partner, or a warehouse issue.

Business Object ID

The unique code that identifies a specific business object. For example, the business object ID of a Purchase Order business object is the purchase order number.

Business Object Reference

A transaction identification more detailed than the business object, for example, a receipt number or an order number. You can use the reference during reconciliation to match transactions if the business object alone does not provide enough information, for example, during GRNI reconciliation.

Note

The business object reference is not the same as a reference link.

Business Object GUID

The generated internal code of the business object.

Business Object Name

In the context of financial integration transaction processing, a business object is a logistic entity or event such as an item, a purchase order, a business partner, or a warehouse issue.

Business Object ID

The unique code that identifies a specific business object. For example, the business object ID of a Purchase Order business object is the purchase order number.

Business Object Reference

A transaction identification more detailed than the business object, for example, a receipt number or an order number. You can use the reference during reconciliation to match transactions if the business object alone does not provide enough information, for example, during GRNI reconciliation.

Note

The business object reference is not the same as a reference link.

Business Object GUID

The unique code that identifies a specific business object. For example, the business object ID of a Purchase Order business object is the purchase order number.

Business Object Name

In the context of financial integration transaction processing, a business object is a logistic entity or event such as an item, a purchase order, a business partner, or a warehouse issue.

Business Object ID

The unique code that identifies a specific business object. For example, the business object ID of a Purchase Order business object is the purchase order number.

Business Object Reference

A transaction identification more detailed than the business object, for example, a receipt number or an order number. You can use the reference during reconciliation to match transactions if the business object alone does not provide enough information, for example, during GRNI reconciliation.

Note

The business object reference is not the same as a reference link.

Business Object GUID

The generated internal code of the business object.

Amounts
Invoice Currency
Net Line Amount

The line amount in the invoice currency.

Tax Base Amount

The net order amount or the net invoice amount in the invoice currency.

LPS Amount
Line Discount Amount

The total discount amount of the invoice line.

Order Discount Amount

The total of order line discount amount for the order.

Customs Value

The total value of all items in your shipment which determines the amount of import duty and other taxes.

First Invoice Discount

The discount amount that applies to the first invoice.

Second Invoice Discount

The discount amount that applies to the first invoice.

Third Invoice Discount
Home Currency
Amount in

The invoice amount in the home currency.

Tax Base Amount in

The net order amount or the net invoice amount in the home currency.

LPS Amount in
Line Discount Amount in

The discount amount in the home currency.

Order Discount Amount in

The total discount amount of the order in the home currency.

Customs Value in Home Currency

The total value of all items in your shipment which determines the amount of import duty and other taxes.

First Discount Amount in
Second Discount Amount in

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

Third Discount Amount in

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

Dates
LPS Date
First Invoice Discount Date

The date of the first invoice discount.

Second Invoice Discount Date
Third Invoice Discount Date
Exchange Rate
Rate
Rate Factor
Rate Date

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

Exchange Rate Type
Variable Composing Criteria
Tax Code
Business Partner Tax Country

The business partner's tax country.

ABC Transaction

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

Department

The department with which the invoice line is associated.

Sales Representative

The sales representative dealing with the invoice.

Manual Sales Invoice
Line of Business

The line of business of the business partner.

Area

The area of the business partner.

Delivery Note

A transport document that provides information on a consignment contained in one truck (or other vehicle) and refers to an order or a set of orders for one consignee at a delivery address. If the truck load contains shipments for various business partners, the load includes more than one delivery note. The information on a delivery note includes the delivery date and address, the customer's name, the contents of the consignment, and so on. In Italy, a delivery note is a legally required document, where it used to be called BAM (Bolla Accompagnamento Merci). Currently it is called DDT (Documento di Trasporto). In Portugal and Spain delivery notes are also used, but there they do not have the same legal status as in Italy.

Sold-to Business Partner
Sold-to Address

The address of the sold-to business partner.

Ship-to Business Partner
Ship-to Address

The address of the ship-to business partner.

Interest Invoice

The document number of the original invoice.

Original Invoice Line

The line number of the original invoice.

Original Invoice Due Date

The due date of the original invoice.

Invoice Receipt Document Number

If the invoice was already paid or partially paid, this is the transaction type of the receipt for which the interest invoice is generated.

Invoice Receipt Line

The line number of the receipt.

Invoice Receipt Date

If the invoice was already paid or partially paid, this is the receipt date.

Invoice Receipt Amount

If the invoice was already paid or partially paid, this is the receipt amount in the invoice currency.

Schedule Line

If a payment schedule is attached to the invoice, this is the schedule line number for which the interest invoice was generated.

If no payment schedule is attached to the invoice, sets this field to 100. If no more interest invoices related to the invoice will be generated, creates a record with the sum total of the interest invoices and for this record, sets the schedule line number to zero.

Number of Days for Interest

The number of days over which interest is calculated.

Interest Percentage

The percentage used to calculate the interest.

Manual Sales
Manual Sales
Operational Company
Gross Amount

The total amount from which taxes, rebates, discounts, and so on are to be deducted to reach the net amount. The gross amount is calculated by multiplying the order quantity with the (book) price.

Log Intrastat

If this check box is selected, Intrastat data is logged for manual sales invoices.

Add. Statistical Info Set
Carrier/LSP
Posting
Reference

Any informative description field used to refer to, for example:

  • The person or department with authorization to perform a specific task.
  • The business partner's contact.
  • The original invoice number.
GL Code

Represents a ledger account and the corresponding dimensions. GL codes are used to represent ledger accounts to users who are not familiar with the structure of the chart of accounts.

To specific logistic transactions, you can link a GL code. Such integration transactions are mapped directly to the ledger account and dimensions of the GL code, they are not included in the mapping process.

Dimension Types

One of up to twelve available analysis account bases for ledger accounts.

Dimensions

Analysis account for ledger accounts to get a vertical view on ledger accounts. Dimensions are used to specify ledger account information.

Contract
Contract
Deliverable

A contract deliverable is a tangible or intangible item that is produced or purchased as a result of a contract.

Schedule

The dates and quantities of an item that can be promised to a customer.

With this report you can determine how much volume can be delivered on time and how much is delivered late.

According to the item master plan, more chairs will be completed later that month. Some of those newly produced chairs have already been promised to other customers.

Example

A customer wants to order 80 office chairs, to be delivered on May 1. However, the CTP quantity on that day is only 30 chairs.

Program

A group of related projects managed in a coordinated way to obtain more benefits and control.

Element

The smallest part of an element structure. An element is used to define the (structure of the) work of the project, so that you can carry it out.

Activity

The smallest part of the activity structure used for a time-scaled budget. An entity that is used to represent a part of a project in an activity structure.

LN distinguishes these activity types:

  • WBS Element
  • Control Account
  • Work Package
  • Planning Package
  • Milestone
Extension

The specific agreements within or in addition to the initial contract. An extension falls outside the initial contract with the sold-to business partner. Extensions can be assigned to the bottom-up budget.

LN distinguishes four extension types:

  • Scope Change
  • Provisional Amount
  • Fluctuation Settlement
  • Quantities to be Settled
Project Line

The project line number.

Wage Part Amount

The percentage of the total contract amount which has been agreed upon with the main contractor that is formed by wage costs.

Note

The value displayed here originates from Project.

Blocked Amount

The amount to be transferred to the first blocked account maintained in Cash Management.

The base amount used to calculate the wage part amount:

base amount = (price * quantity) - discount amount - holdback amount

The wage part amount is calculated using this formula:

wage part amount = base amount * wage part of contract amount

The blocked amount is then calculated using this formula:

blocked amount = wage part amount * wage B-account percentage
Note

This field is only relevant in the Netherlands.

Customer Order

The number the sold-to business partner assigned to the order. In the automotive industry, it can represent the sold-to business partner's purchase contract number.

Amount of Time

The number of time units.

The unit that is used to specify the physical quantity time.

Invoice-to Contact

The contact for the invoice-to business partner.

Contract Award Date

The date when the contract line was awarded.

Contract
Item

The item to be invoiced.

Customer Item Code

The item code that is used by the customer on the billable line.

Product Variant

A unique configuration of a configurable item. The variant results from the configuration process and includes information such as feature options, components, and operations.

Example

Configurable item: electric drill

Options:

  • 3 power sources (batteries, 12 V or 220 V)
  • 2 colors (blue, gray).

A total of 6 product variants can be produced with these options.

Task

A specification of the type of work that is carried out by a service employee. You can use tasks to specify the labor required to carry out an activity. A specific labor rate can be linked to a task.

Equipment

The equipment code.

Subcontracting

The subcontracted work covered by the invoice line.

Sundry Cost

The sundry costs covered by the invoice line.

Overhead

The overhead costs covered by the invoice line.

Progress Date

The registration date for the forecast deviation of revenues.

Fee Type

Fee Type

  • Fixed Fee

    A fixed amount that you receive from your contractor.

  • Award Fee

    A percentage that you receive from your contractor for, for example, delivering on time.

  • Incentive Fee

    A percentage that you receive from your contractor for, for example, a first order.

  • Penalty

    A percentage that you must pay to your contractor in case of, for example, late delivery or a cost overrun.

Installment
Installment Number

An incremental payment method used to spread invoice payments over a period of time. Installments enable you to send invoices for a sales order before or after the ordered goods are actually delivered.

No. of Points

The total number of points currently invoiced for the installment.

Percentage

The tax percentage that applies to the invoice line.

Holdback
Holdback Number

The holdback number.

Hold Back Percentage

The holdback amount expressed as a percentage.

Holdback Amount

The holdback amount.

Revenue
Revenue code

A way to categorize invoiced amounts of the same invoice type in order to analyze revenue history.

Revenue Sequence number
Sales / Warehouse
Sales / Warehouse
Warehouse

The warehouse from which the goods were shipped.

Delivery Point
Carrier/LSP
Kit Handling

If this check box is selected, a kit order applies.

Product Variant

A unique configuration of a configurable item. The variant results from the configuration process and includes information such as feature options, components, and operations.

Example

Configurable item: electric drill

Options:

  • 3 power sources (batteries, 12 V or 220 V)
  • 2 colors (blue, gray).

A total of 6 product variants can be produced with these options.

Revision

The revision of a revision-controlled manufactured part.

Original Invoice Company

The company for which the invoice line was created.

Original Invoice Transaction Type

The transaction type part of the original invoice document number.

Original Invoice

The invoice number of the original invoice.

Reference
Customer Item Code

The item code used by the customer.

Header Customer Order

The order number used by the customer.

Customer Order Line

The order line number used by the customer.

Customer Order Sequence

The order sequence number used by the customer.

Packing Slip

An order document that shows in detail the contents of a particular package for shipment. The details include a description of the items, the shippers or customers item number, the quantity shipped, and the inventory unit of the shipped items.

Packing Slip External

The number of an external packing slip.

Shipment Reference

Identifies a group of items that are called off at the same time.

Installment
Advances Applicable

If this check box is selected, advance payments apply.

Invoicing by Installment

If this check box is selected, invoicing is done by installments.

Revenue Recognition at Installments (Sales)

If this check box is selected, LN takes installment invoice amounts into account for revenue recognition.

Note

When selected, for Normal and Guarantee installments, the following applies:

Original Installment Line

The original installment line.

Self-Billing
SBI Correction

If this check box is selected, a correction applies to the amount of a self-billed invoice.

Matched SBI Relations Code

A number that identifies a set of matched (customer) self-billed invoice lines with billable lines.

Invoiced Amount Variance

The correction amount in case the self-billed invoice exceeds or falls short of the original amount.

Invoiced Amount Variance

The amount variance in the home currency.

Conversion Factor
Conv. Factor Price Unit

The conversion factor applied to the price unit.

Conv. Factor Quantity Unit

The factor used to convert the quantity in order unit into the quantity in inventory unit.

Conv. Factor Delivery Unit

The conversion factor applied to the delivery unit.

Discount
Line Discount Specification
Discount Method

A code that indicates the way in which discounts are calculated if multiple discount levels are used.

Discounts are calculated according to one of the following amounts:

  • Gross: the discount is calculated over the gross amount
  • Net: the discount is calculated over the net amount. The net amount is calculated from the gross amount minus discounts at previous levels
Discount Percentage

The percentage that you can subtract from the gross sales price or purchase price.

Discount Amount

The discount given to a business partner, calculated by unit and expressed as a value. For instance, 3 euro.

Service
Service
Location Address

The location address where the service is performed.

Task

The task to which the invoice refers.

Warranty Claim

If this check box is selected, LN includes the claim number in the invoice data along with other service order data.

The cost of goods sold amount for the service order is posted to Financials.

Claim

The claim number. The value is defaulted from Service.

Reference Activity

The smallest unit of work that is required to carry out maintenance.

Master Routing

A set of operations that can be carried out. The reference activities based on which operations are added to a master routing, must have the same characteristics, such as item, functional element, and service department.

Example

All the inspections, tests, cleaning activities, assembly activities, disassembly activities, and repair activities that you can carry out on an engine.

Routing Option

A subset of master routing. A predefined set of operations that can be carried out. Each operation is identified by a unique sequence number.

Print on Invoice

If this check box is selected, the installation group is printed on the invoice.

VAT Based on

For Service transactions, this field contains the type of delivery to which the invoice applies.

Item Identification
Item

If the invoice concerns a serialized item, this is the item code.

Serial Number

If the invoice concerns a serialized item, this is the item code.

Serial Number

The serial number of the item.

Installation Group

The installation group to which the invoice refers.

Tool Number

A number to identify a tool. The combination of a tool type, for example, hammer, and a tool serial number, for example, 1, is unique, and identifies a tool in LN.

Costs
Costs

The cost amount.

Quotation Costs

Costs incurred for quotation.

Forecast Cost Amount

The forecast cost amount in the invoice currency.

Note

This field is used for posting costs to Financials.

Forecast Cost Amount

The forecast cost amount in the home currency.

Travel Costs
Travel Time Amount

The cost incurred for travel from the service center to location.

Note

The field is included in invoice data, along with the other service order data, if:

  • In the Invoices (cisli3105m000) session, Service Order Type is set to Service Order or Service Call.
  • The Consolidate Travel cost check box is selected in the Service Order Parameters (tssoc0100m000) session.
Travel Distance Amount

The cost incurred for travel from the service center to location.

Note

The field is included in invoice data, along with the other service order data, if:

  • In the Invoices (cisli3105m000) session, Service Order Type is set to Service Order or Service Call.
  • The Consolidate Travel cost check box is selected in the Service Order Parameters (tssoc0100m000) session.
Service Contract
Installment Start Date

The start date of the installment period.

Installment End Date

The installment end date and time.

Discount Percentage

The percentage that you can subtract from the gross sales price or purchase price.

Conversion Factor
Conv. Factor Price Unit

The factor used to convert the price unit.

Conv. Factor Price Unit

The factor used to convert the quantity in order unit into the quantity in inventory unit.

Freight
Freight
Original Order Reference

Any informative description field used to refer to, for example:

  • The person or department with authorization to perform a specific task.
  • The business partner's contact.
  • The original invoice number.
Debit/Credit Notes
Debit/Credit Notes
Type of Document

The transaction type of the original invoice.

Tax Country
Tax Code
BP Tax Country

The business partner's tax country.

Tax Amount

The tax amount in the invoice currency.

The currency in which the invoice amount is expressed.

Tax Amount in Home Currency

The invoice line tax amount in the home currency.

Original Invoice
Original Invoice Transaction Type
Original Invoice
Original Schedule No

The original schedule number.

Remittance
Remittance Code

The remittance advice code.

Serial Number

The sequence number of the remittance advice.

Credit Analyst
Rebate
Amounts
Base Amount

The sales order amount on which the rebate is based.

Fixed Amount

If the rebate consists of a fixed amount, this is the rebate amount.

Percentage
Rebate Percentage

If the rebate consists of a percentage, this is the rebate percentage.

Growing Percentage

If the rebate contains a growing percentage, this is the growth percentage.

Texts
Header Text

Descriptive text or comments attached to the header.

Additional Header Text

Additional text attached to the header.

Line Text

Text attached to the invoice line.

Detail Text

Detail text attached to the invoice line.

Item Text

Solution Text

Text attached to a solution.

Footer Text

Descriptive text or comments attached to the footer.

Initial Hidden
Reason Code

A user-defined description that is based on a transaction and its type. Reason codes assist in selecting data for inquiry and for reporting.

Segments

The dimensions used for segment reporting.

Ordered Quantity

The total ordered quantity.

The unit in which the quantity is expressed.

Ordered Quantity

The total ordered quantity.

Weight

If a delivery note is present, this is the weight of the load as stated on the delivery note. Otherwise, the weight of the shipment.

The unit for the weight of the load as stated on the delivery note. Otherwise, the unit for the weight of the shipment.

Original Invoice Line Number

The original invoice line.

Remittance Advice Raised Company

The company used to process and post the remittance advices.

Project

The project code.

Customer Order

The number the sold-to business partner assigned to the order. In the automotive industry, it can represent the sold-to business partner's purchase contract number.

Additional Field

User-defined fields that can be linked to LN tables.

The contents of additional fields can be transferred between LN tables. Additional information fields are meaningless to LN as no functional logic is linked to the contents of these fields.

Tax Amount

The invoice line tax amount in the invoice currency.

Billing Sequence

The billing sequence number assigned to the billable line. Default value: 1

Note
  • Only for a sales schedule-related self-billed invoice, the value can be greater than 1.
  • For billable lines that are split as a result of approving a partially matched self-billed invoice, a new billing sequence is created for the matched quantity and amounts.
Aggregation Sequence

Lines that share the same sequence number are printed as a single line on the invoice.

Kind of Order

The kind of order created for the billable line.

Allowed values

Kind of Order

Header Description

Invoice Type

The invoicing scenario that was linked to the source type in the Invoicing Parameters by Source Type (cisli0101m000) session.

Sales Order Type

The order type, which determines the sessions that are part of the order procedure and how and in which sequence this procedure is executed.

Tax Country

The tax country of the invoice line.

Project

The project code.

Charge Type

The type of delivery covered by the invoice line.

If the invoice refers to anything other than goods, service or costs, select Not Applicable.