Saved Search Criteria tab.
Type: is Sales Order
Main Line: is false.
COGS Line: is false.
Tax Line: is false.
Shipping Line: is false.
Status: is any of Sales Order: Pending Fulfillment, Sales Order: Partially Fulfilled
Subsidiary: Select the required Subsidiary.
Results tab:
Internal Id: Summary Type (Group)
Document Number: Summary Type (Group)
Item: Summary Type (Group)
Status: Summary Type (Group)
Formula Numeric: Summary Type (Sum), Formula: CASE WHEN {status} = ‘Partially Fulfilled’ THEN NVL({quantitycommitted}, 0) ELSE {quantity} END
Available Filter tab:
Filter: Item, check the checkbox of Show in Filter region.
On the results page based on the selected filter item, the total quantity of that particular item in all open sales orders will be obtained.