Let’s Talk
Let’s Talk

Cloudy Revenue Inventory Knowledge Base

Invoice Line

The Invoice Line object in Cloudy Inventory represents the individual products, services, fees, and charges included within an Invoice. Each Invoice Line contains detailed billing information such as the product, stock item, quantity, unit price, discounts, taxes, subtotal, and net total.

Invoice Lines are automatically created from Order Products when an Invoice is generated, ensuring that each billed item is accurately represented. The object also supports customer and trade discounts, tax calculations, service periods, purchase pricing, and inventory tracking, providing detailed financial information for every item billed to the customer.

By using the Invoice Line object, organizations can accurately manage item-level billing, taxation, pricing, and financial reporting while maintaining traceability between Orders, Products, Inventory, and Invoices.

Why is it Used?

The Invoice Line object is used to:

  • Record individual products or services billed on an Invoice.
  • Capture product pricing, quantities, discounts, and taxes.
  • Calculate line-level subtotals and net totals.
  • Maintain links to Products, Stock Items, and Sales Order Line Items.
  • Support multiple billing line types such as Items, Fees, and Processing Fees.
  • Track service periods for subscription or service-based products.
  • Support financial reporting and invoice calculations.

Key Features

  • Stores detailed item-level billing information.
  • Supports multiple Invoice Line Types.
  • Calculates taxes and discounts automatically.
  • Maintains product and stock item relationships.
  • Supports trade and customer discounts.
  • Tracks service start and end dates.
  • Supports parent-child invoice line hierarchy.
  • Calculates purchase cost and sales totals.
  • Integrates with Sales Orders, Quotes, and Work Orders.
  • Supports external accounting integrations through External Invoice Line ID.

Key Field Functionality

The Invoice Line object includes key fields that control processing behavior.

FieldPurpose
Invoice Line NameUnique identifier for the Invoice Line.
InvoiceParent Invoice record.
ProductProduct being billed.
Stock ItemRelated Stock Item.
Sales Order Line ItemRelated Order Product.
QuantityQuantity billed.
Unit PriceSelling price per unit.
List PriceStandard product price.
Unit Purchase PricePurchase cost per unit.
Customer Discount %Customer discount percentage.
Customer Discount AmountDiscount amount applied.
Trade Discount %Trade discount percentage.
Tax %Applicable tax percentage.
Tax RateRelated Tax Rate record.
Line TypeType of invoice line.
Net TotalFinal amount after discounts and taxes.
Sub TotalAmount before taxes.
Service Start DateService start date.
Service End DateService end date.

Checkbox Functionality

The Invoice Line object includes checkbox fields that control billing behavior. 

Checkbox FieldPurpose / Use
Tax Inclusive? Indicates whether the Unit Price already includes applicable taxes. When selected, the system calculates tax as part of the entered price instead of adding it separately. 

Example Business Scenario

A customer, Test Customer Inc., purchases 10 Sedan Cars. After an Invoice is generated, the system creates Invoice Lines for each billed product.

  • Customer: Test Customer Inc.
  • Invoice: Generated from the Sales Order.
  • Product: Sedan Car.
  • Stock Item: Maruti Dzire.
  • Quantity: 10 Units.
  • Unit Price: USD 100.
  • Applicable customer discounts and taxes are applied automatically.
  • The system calculates the Sub Total, Tax Amount, and Net Total for the Invoice Line.
  • The Invoice Line is linked to the corresponding Sales Order Line Item, ensuring complete traceability from Order to Invoice.

Outcome:

  • Each billed product is represented as an individual Invoice Line.
  • Pricing, taxes, and discounts are calculated accurately.
  • Complete linkage is maintained between Orders, Products, Inventory, and Invoices.
  • Item-level financial reporting and invoice reconciliation become easier.

Best Practices

  • Verify the Product and Stock Item before saving the Invoice.
  • Review quantities and unit prices for accuracy.
  • Apply customer and trade discounts according to pricing agreements.
  • Ensure the correct Tax Rate is selected.
  • Use Tax Inclusive? only when product pricing already includes taxes.
  • Validate calculated totals before issuing the Invoice.
  • Maintain correct links between Invoice Lines and Sales Order Line Items.
  • Use External Invoice Line ID for integrations with external accounting systems.