Pro Forma Invoice Lines (cisli3110m200)
Use this session to view pro forma invoice lines and their details.
- It is possible to select a consignment invoice line and create billable lines for the consignment credit. Amounts can be changed on these billable lines and invoiced to get a consignment credit note.
- Many attributes relevant for standard invoices are not relevant for pro forma invoices because pro forma invoices are not legal invoices and are never posted. For example: Tax Amount, Fiscal Year and Period, Due Date, … When values are present for these attributes, this is only for information.
- You can view the invoice data for the cumulative contract billing using the option from the menu. This option is enabled only if the Application For Payment Based Invoicing check box is selected in the Invoicing Methods (tcmcs0155s000) for the billable line.
Field Information
- Invoice Number
-
The financial company in which the pro forma invoice exists.
- /
-
The transaction type of the pro forma invoice.
- /
-
The pro forma invoice document number.
- Original Invoice Number
-
The invoice number of another original invoice.
- Invoice Date
-
Invoice date of the invoice. This is determined based on the Invoice Date settings in the Invoicing Parameters (cisli0100m000) session.
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
-
The status of the pro forma invoice.
Allowed values
- On Hold
- Not Applicable
- Canceled
- Confirmed
- Canceled After Invoicing
- Ready to Submit
- Pending Approval
- Ready to Print
- Submitted to External System
- Rejected by External System
- Approved by External System
- Printed
- Posted
- Line
-
The invoice line number.
- Source Company
-
The financial company of the original pro forma invoice.
- Shifted Tax Amount in Home Currency
-
The shifted tax amount in the home currency.
- LPS Amount
-
The late-payment surcharge amount in the invoice currency.
- LPS Amount in
-
The late-payment surcharge amount in the home currency.
- LPS Date
-
The date of the late payment surcharge that applies to the invoice.
- Line Discount Amount in
-
The total discount amount of the invoice line in home currency.
- Order Discount Amount in
-
The total discount amount of the order in the home currency.
- Customs Value
-
The total value of all items in your shipment which determines the amount of import duty and other taxes in invoice 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 in home currency.
- Source Type
-
The source document type.
- First Invoice Discount
-
The discount amount in invoice currency that applies to the first invoice.
- First Discount Amount in
-
The discount amount in home currency that applies to the first invoice .
- First Invoice Discount Date
-
The date of the first invoice discount.
- Second Invoice Discount
-
The discount amount in invoice currency that applies to the second invoice.
- Second Discount Amount in
-
The discount amount in home currency that applies to the second invoice .
- Second Invoice Discount Date
-
The date of the second invoice discount.
- Third Invoice Discount
-
The discount amount in invoice currency that applies to the third invoice.
- Third Discount Amount in
-
The discount amount in home currency that applies to the third invoice .
- Third Invoice Discount Date
-
The date of the third invoice discount.
- Rate
-
The currency exchange rate which is used to convert the invoice currency to the home currency.
- Order Number
-
The source document number.
- Rate Factor
- Rate Date
-
The currency rates valid on this date apply to the pro forma invoice line.
- Exchange Rate Type
-
The exchange-rate type.
- 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:
- The Sales Order / Revenue Analysis integration document is used instead of the Sales Order / Normal Installment and Sales Order / Settled Guarantee Installment documents.
- When sales order lines are invoiced, no currency difference postings are created for the reversal of installments.
- Taxable Amount
-
The amount on which the tax is applicable.
- Order Line
-
The line number of the order data.
- Reason Code
- Description
-
The description or name of the code.
- Intercompany Trade Scenario
- Order Date
-
The date when the good to be invoiced is ordered.
- Original Invoice
-
The transaction type part of the original invoice document number.
-
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.
- Source Document
-
The source company.
- Invoice Receipt Line
-
The line number of the receipt.
- Invoice Receipt Date
-
The date and time on which the invoice is fully or partially paid.
- 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.
Note: If no payment schedule is attached to the invoice, LN sets this field to 100. If no more interest invoices related to the invoice will be generated, LN creates a record with the sum total of the interest invoices and for this record, LN 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.
- Segments
-
The dimensions used for segment reporting.
- Item
- GL Code
- Operational Company
- Dimensions
- Item Description
-
The description or name of the code.
- Description
-
The description or name of the code.
- Dimension Description
-
The description or name of the code.
- Reference
- Gross Amount
- Log Intrastat
-
If this check box is selected, Intrastat data is logged for manual sales invoices.
- Add. Statistical Info Set
- Description
-
The description or name of the code.
- Carrier/LSP
- Description
-
The description or name of the code.
- Element
- Line Description
-
The description or name of the code.
- Activity
- Program
- Extension
- Lot
- Item
-
The item to be invoiced.
- Task
- Equipment
-
The equipment code.
- Subcontracting
-
The subcontracted work covered by the pro forma billable line.
- Serial Number
-
The serial number of the item to be invoiced.
- Sundry Cost
-
The sundry costs covered by the pro forma invoice line.
- Overhead
-
The overhead costs covered by the pro forma invoice line.
- Fee Type
-
The fee type for the pro forma invoice.
Allowed values
- 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.
- Customer Item Code
-
The item code used by the customer.
- Product Variant
- Customer Order
- Hold Back Percentage
-
The holdback amount expressed as a percentage.
- 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 amountThe wage part amount is calculated using this formula:
wage part amount = base amount * wage part of contract amountThe blocked amount is then calculated using this formula:
blocked amount = wage part amount * wage B-account percentageNote: This field is only relevant in the Netherlands. - No. of Points
-
The total number of points currently invoiced for the installment.
- Percentage
-
The tax percentage that applies to the pro forma invoice line.
- Revenue code
- Revenue Sequence number
-
The revenue sequence number.
- Ordered Quantity
-
The total ordered quantity.
- Amount of Time
-
The number of time units.
- Invoice-to Contact
-
The contact for the invoice-to business partner.
- Description
-
The description or name of the code.
- Contract Award Date
-
The date when the contract line was awarded.
- Warehouse
-
The warehouse from which the goods were shipped.
- Description
-
The description or name of the code.
- Delivery Point
- Description
-
The description or name of the code.
- Carrier/LSP
- Description
-
The description or name of the code.
- Kit Handling
-
If this check box is selected, a kit order applies.
- Packing Slip
- Packing Slip External
-
The number of an external packing slip.
- Shipment Reference
- Revision
-
The revision of a revision-controlled manufactured part.
- Customer Item Code
-
The item code used by the customer.
- Header Customer Order
-
The order number used by the customer.
- Customer Contract Reference
- Customer Order
-
The order number used by the customer.
- Order Discount Amount
-
The total of order line discount amount for the order.
- Customer Order Line
-
The order line number used by the customer.
- Customer Order Sequence
-
The order sequence number used by the customer.
- Discount Method
- Discount Percentage
- Discount Amount
- Ordered Quantity
-
The total ordered quantity.
- Weight
-
The weight of the goods or shipment which is invoiced.
- Unit
-
The unit for the weight.
- Product Variant
- Currency
- Conv. Factor Price Unit
-
The conversion factor applied to the price unit.
- Conv. Factor Quantity Unit
-
The conversion factor applied to the quantity unit.
- Conv. Factor Delivery Unit
-
The conversion factor applied to the delivery unit.
- SBI Correction
-
If this check box is selected, a correction applies to the amount of a self-billed invoice.
- Invoiced Amount Variance
-
Pro forma billable lines are never matched with received self-billed invoices. So, this is not applicable for pro forma invoices.
- Invoiced Amount Variance
-
Pro forma billable lines are never matched with received self-billed invoices. So, this is not applicable for pro forma invoices.
- Currency
- Matched SBI Relations Code
- Invoicing by Installment
-
If this check box is selected, invoicing is done by installments.
- Line Discount Amount
-
The total discount amount of the invoice line.
- Original Installment Line
-
The original installment line.
- Advances Applicable
-
If this check box is selected, advance payments apply.
- 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.
- Location Address
-
The location address where the service is performed.
- VAT Based on
-
For Service transactions, this field contains the type of delivery to which the invoice applies.
- Task
- Item
-
The code of the item which is invoiced.
- Serial Number
-
The serial number of the item which is invoiced.
- Warranty Claim
-
If this check box is selected, LN includes the claim number in the invoice data along with other service order data.
- Claim
-
The claim number. The value is defaulted from Service .
- Costs
-
The cost amount.
- Quotation Costs
-
Costs incurred for quotation.
- Travel Time Amount
-
The time-based 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 Travel Total Line for Distance and Time check box is selected in the Service Order Parameters (tssoc0100m000) session.
- Travel Distance Amount
-
The distance-based 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 Travel Total Line for Distance and Time check box is selected in the Service Order Parameters (tssoc0100m000) session.
- First Reference
-
A text used to identify the invoice.
- Conv. Factor Price Unit
-
The conversion factor applied to the price unit.
- Conv. Factor Price Unit
-
The conversion factor applied to the quantity unit.
- Installation Group
-
The installation group to which the invoice refers.
- Print on Invoice
-
If this check box is selected, the installation group is printed on the invoice.
- Tool Number
- Reference Activity
- Master Routing
- Routing Option
- Forecast Cost Amount
-
The forecast cost amount in the invoice currency.
Note: This field is used for posting costs to Financials . - Second Reference
-
An additional text used to identify the invoice.
- Forecast Cost Amount
-
The forecast cost amount in the home currency.
- Discount Percentage
- Serial Number
-
The serial number of the item which is invoiced.
- Installment Start Date
-
The start date and time of the installment period.
- Installment End Date
-
The installment end date and time.
- Installation Group
-
The installation group to which the invoice refers.
- Original Order Reference
-
The reference of the original order.
- Tax Country
-
The tax country of the business partner associated with the pro forma invoice.
- Description
-
The description or name of the code.
- Warehouse
-
The warehouse in which delivered goods are received.
- Tax Code
- Description
-
The description or name of the code.
- BP Tax Country
-
The tax country of the business partner associated with the pro forma invoice.
- Description
-
The description or name of the code.
- Tax Amount
-
The tax amount in the invoice currency.
- Tax Amount in Home Currency
-
The tax amount in the home currency.
- Type of Document
-
The type of the invoice receipt.
Allowed values
- Sales Invoice
- Unallocated Receipt
- Not Applicable
- Advance Anticipated
- Unallocated Anticipated
- Assignment
- Debit Note
- Trade Note
- Cash Journal
- Normal Receipt
- Purchase Invoice
- Credit Note
- Correction
- Currency Difference
- Payment Difference
- Anticipated Receipt
- Advance Receipt
- Original Invoice Transaction Type
-
The transaction type part of the original invoice document number.
- Description
-
The description or name of the code.
- Original Invoice
-
The series number of the original invoice document number.
- Original Invoice Line Number
-
The line number of the original invoice.
- Original Schedule No
-
The original schedule number.
- Due Date
-
The due date of the original invoice.
- Credit Analyst
-
The credit analyst linked to the pro forma invoice.
- Remittance Advice Raised Company
- Remittance Code
- Serial Number
-
The serial number of the item which is invoiced.
- Delivery Point
- Base Amount
-
The sales order amount on which the rebate is based.
- Rebate Percentage
-
The percentage to be paid to a sold-to business partner as a kind of discount for closing a sales order.
- Growing Percentage
-
If the rebate contains a growing percentage, this is the growth percentage.
- Fixed Amount
-
If the rebate consists of a fixed amount, this is the rebate amount.
- Description
-
The description or name of the code.
- Shipment
-
The shipment of the goods which are invoiced.
- /
-
The shipment line of the goods which are invoiced.
- Delivery Date
-
The delivery date of the goods which are invoiced.
- Delivered Quantity
-
The delivered quantity of the goods which are invoiced.
- Weight
-
The weight of the goods or shipment which is invoiced.
- Unit
-
The unit for the weight.
- Delivery Terms
- Description
-
The description or name of the code.
- Dimension Types
-
The description or name of the code.
- Point of Title Passage
- Description
-
The description or name of the code.
- Business Object Company
-
The financial company of the business object.
- Project
-
The project code.
- Description
-
The description or name of the code.
- Business Object Name
-
The business object name.
- Customer Order
- Business Object ID
-
The business object ID.
- Description
-
The description or name of the code.
- Business Object Reference
- Billable Employee
-
The code of the employee.
- Business Object GUID
-
The generated internal code of the business object.
- Holdback Amount
-
The holdback amount.
- Business Object Company
-
The financial company of the business object.
- Business Object Name
-
The business object name.
- Business Object ID
-
The business object ID.
- Business Object Reference
- Revenue Cost Component
-
The cost component of the generated revenue.
- Description
-
The description or name of the code.
- Project Cost Component
-
The cost component linked to the project.
- Description
-
The description or name of the code.
- Business Object GUID
-
The generated internal code of the business object.
- Net Line Amount
-
The line amount in the invoice currency.
- Tax Amount
-
The tax amount in the invoice currency.
- Shifted Tax Amount
-
The shifted tax amount in the invoice currency.
- Billing Sequence
-
The billing sequence number assigned to the pro forma billable line. Default value: 1
Note: Pro forma billable lines cannot be matched with received self-billed invoices. So only default value is applicable for pro forma billable lines. - 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
- Production Order
-
Production orders - functional overview
- Not Applicable
-
Not used in the current context.
- Forecast
-
forecast
- CTP Reservation
-
capable-to-promise
- Sales Quotation
- Purchase Contract
-
purchase contract
- Sales Contract
-
sales contract
- Warehouse Order
-
warehousing order
- Service Order
- PRP Purchase Order
- PRP Warehouse Order
- Purchase Order
- Warehousing Assembly Order
-
Warehousing assembly orders
- Warehouse Transfer
-
warehouse transfer
- Production Batch
- Sales Order
- Planned Distribution Order
-
planned distribution order
- Assembly Part Demand
- Production Order (Manual)
-
Production orders - functional overview
- Purchase Order (Manual)
- Sales Order (Manual)
- Service Order (Manual)
- Warehouse Transfer (Manual)
-
warehouse transfer
- Maintenance Sales Order
- Maintenance Work Order
-
maintenance order
- Maintenance Sales Order (Manual)
- Planned Production Order
-
planned production order
- Request for Quotation
-
request for quotation (RFQ)
- Sales Schedule Forecast
- Maintenance Work Order (Manual)
-
maintenance order
- Freight
- Stock
- Safety Stock
-
safety stock
- Assembly Order (Manual)
- Purchase Requisition
-
purchase requisition
- Production Plan
-
Job shop production planning in Enterprise Planning
- Planned Purchase Order
-
planned purchase order
- Purchase Plan
-
purchase plan
- Cycle Counting Order
-
cycle count order
- Adjustment Order
-
adjustment order
- Revaluation Order
-
revaluation
- Production Schedule
-
production schedule
- Production Kanban
- Project
- Project (Manual)
- Purchase Schedule
- Warehouse Transfer (Distribution)
-
transfer order
- Intercompany Trade Order
- Planned Subcontracting Order
- Subcontracting Schedule
- PCS Project
- Allocation Change Order
-
allocation change order
- Sales Schedule
- Inventory Ownership Change Order
-
inventory ownership change order
- Expected Supply
- Confirmed Supply
- Forecast from Customer
- Forecast to Supplier
- Buy-From BP Transfer (Purchase)
- Purchase Order Advice
-
purchase order advice
- 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)
- Assembly Order
- Sold-To BP Transfer (WH Distribution)
- Planned Cost Peg Transfer
- Cost Peg Transfer
- Project Contract
- Customer Claim
- Supplier Claim
- Planned Activities Service
-
planned activities
- Quarantine Inventory
-
quarantine inventory
- 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 billable line.
- Detail Text
-
Detail text attached to the billable line.
- Item Text
-
Text attached to a service item.
- Solution Text
-
Text attached to a solution.
- Footer Text
-
Descriptive text or comments attached to the footer.
- Additional Field
-
additional information field
- Invoice Line Type
-
The type of invoice line.
Note: At a moment, only one type of pro forma invoice or billable lines are shown.Allowed values
- Advance Receipt Request
- Material
- Not Applicable
- Labor
- Equipment
- Tooling
- Traveling
- Subcontracting
- Helpdesk
- Freight
- Interest
- WIP Transfer
- Installment
- Triangular
- Holdback
- Installment Additional Costs
- Pay from Receipt
- Other
- Warehouse Order
- Schedules
- Retrobilling
- Credit Note
- Cost-Plus
- Debit Note
- Freight Order
- Direct Delivery
- Rebate Lines
- PCS Order
- Expenses
- Triangular Purchase
- Extension
- Contract Delivery
- Rental
- Unit Rate
- Activity
- Progress Payment Request
- Progress
- Fees & Penalties
- Advance Invoice
- Advance Payment Request
- Manual Sales
- Sales Order
- Contract Installment
- Non-billable
- Sales Order Type
- Additional Field
-
additional information field
- Tax Country
- Tax Code
- Business Partner Tax Country
-
The tax country of the business partner.
- Department
-
The department with which the invoice line is associated.
- Sales Representative
-
The sales representative dealing with the invoice.
- Description
-
The description or name of the code.
- Line of Business
-
The line of business of the business partner.
- Area
-
The area of the business partner.
- Delivery Note
- Sold-to Business Partner
- Description
-
The description or name of the code.
- Sold-to Address
-
The address of the sold-to business partner.
- Ship-to Business Partner
- Description
-
The description or name of the code.
- Ship-to Address
-
The address of the ship-to business partner.
- Project
- Deliverable
- Schedule
- Installment Number
-
The installment number.
- Holdback Number
-
The holdback number.
- Progress Date
-
The registration date for the forecast deviation of revenues.
- 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.
- Amount in
-
The invoice amount in the home currency.
- Taxable Amount in
-
The taxable invoice amount in the home currency.
- Tax Amount in Home Currency
-
The invoice line tax amount in the home currency.