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.
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
- 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
-
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
-
Extra Intrastat info
- 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
-
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.
- Shipment Line
-
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.