Let’s Talk
Let’s Talk

Cloudy Revenue Inventory Knowledge Base

Order Product

The Order Product object represents an individual product or service line within a customer Order. Each Order Product stores information such as the selected Product, Stock Item, quantity, pricing, Unit of Measure (UOM), inventory details, and fulfillment status.

An Order can contain multiple Order Products, enabling businesses to manage inventory allocation, product fulfillment, delivery, returns, and inventory tracking for each line item independently.

Why is it Used?

The Order Product object is used to:

  • Add products to a customer Order.
  • Define ordered quantity, pricing, and Unit of Measure.
  • Associate the appropriate Stock Item.
  • Track inventory allocation and committed quantities.
  • Monitor fulfillment, delivery, purchase, and return quantities.
  • Support warehouse picking and shipping.
  • Integrate with inventory management and fulfillment processes.
  • Maintain detailed product-level order history.

Key Features

📦 Product Line Management

Represents individual products or services within an Order.

🛒 Product Association

Links each Order Product to a Product and the parent Order.

📍 Stock Item Selection

Associates the correct Stock Item for inventory allocation and fulfillment.

📏 Unit of Measure Support

Supports both Sales UOM and Inventory UOM with Conversion Factor.

💰 Pricing Management

Stores List Price, Unit Price, Unit Purchase Price, and Total Price.

📦 Inventory Tracking

Tracks Inventory Quantity, Available Quantity, and Remaining Quantity to Allocate.

🚚 Fulfillment Monitoring

Monitors Committed, Delivered, Fulfilled, Purchased, Issued, Reserved, and Returned quantities.

📊 Allocation Tracking

Tracks Total Allocated Amount for inventory reservation.

🔄 Quote Conversion

Supports creation from Quote Line Items during Order generation.

Key Field Functionality

The Order Product object includes key fields that control processing behavior.

FieldPurpose
OrderParent customer Order containing this line item.
ProductProduct being sold to the customer.
Stock ItemPhysical inventory item selected for fulfillment.
QuantityOrdered quantity.
Available QuantityAvailable inventory for allocation.
Inventory QuantityQuantity maintained in inventory units.
Conversion FactorConverts Sales UOM into Inventory UOM.
Quantity Unit of MeasureSales Unit of Measure.
Inventory UOMInventory Unit of Measure.
List PriceStandard selling price.
Unit PriceFinal selling price per unit.
Unit Purchase PricePurchase cost of the product.
Total PriceTotal value of the Order Product.
Remaining Quantity to AllocateQuantity still awaiting inventory allocation.
Stock Product StatusDisplays stock evaluation status (Matched, Not Matched, etc.)
Total Allocated AmountTotal monetary value of allocated inventory.
Total Quantity CommittedQuantity committed for fulfillment.
Total Quantity DeliveredQuantity delivered to the customer.
Total Quantity FulfilledQuantity successfully fulfilled.
Total Quantity PurchasedQuantity procured for the Order.
Total Quantity IssuedQuantity issued from inventory.
Total Quantity ReservedReserved inventory quantity.
Total Quantity ReturnedQuantity returned by the customer.

Example Business Scenario

Scenario: Customer Orders Sedan Car

ABC Manufacturing receives a confirmed customer Order for 10 Sedan Cars.

An Order Product is created with the following details:

  • Order: ORD-2026-0001
  • Product: Sedan Car
  • Stock Item: Maruti Dzire
  • Quantity: 10
  • Sales UOM: Each
  • Inventory UOM: Each
  • Unit Price: ₹9,50,000
  • Conversion Factor: 1

After the Order Product is saved:

  • Inventory is evaluated.
  • Matching Stock Item is assigned.
  • Inventory is allocated.
  • Reserved quantity is updated.
  • The warehouse fulfills the order.
  • Delivery quantities are updated after shipment.

System Behaviour :

  • Product pricing is inherited from the Price Book.
  • Inventory allocation reserves available stock.
  • Warehouse uses the Stock Item for fulfillment.
  • Inventory Transactions update stock quantities.
  • Delivery and fulfillment quantities are automatically updated.

Outcome:

  • Accurate inventory reservation.
  • Product-level fulfillment tracking.
  • Complete visibility of ordered, allocated, delivered, and returned quantities.
  • Improved warehouse efficiency.

 SEE ALSO :

_____👉Order Product Creation