Quantity sold from sales orders and stand alone invoices in Saved Search

To create quantity sold from sales orders and stand alone invoices in Saved Search

In Filter Subtab,

• Select Type
  • Type: Select Sales Order and Invoice
• Select Tax Line
  • Tax line: Select False
• Select Shipping Line
  • Shipping line: Select False
• Select Status
  • Status: None of  Sales Order: Pending Approval, Sales Order: Cancelled, Sales Order: Closed, Invoice: Pending Approval, Invoice: Rejected, Invoice: Voided
• Select Created from Fields: Type
  • Type: Select None
• Select Cogs Line
  • Cogs line: Select False

In Results Subtab,

In Fields select

• Select Item
  • Select Group as summary
• Select Amount
  • Select Sum as summary
• Select Formula Numeric
  • Select Sum as summary
  • Formula: Set NVL({quantity},0)
  • Label: Set Quantity Sold

Click Save and Run.