We currently have saved search report that generates the outstanding sales order dollar amount to be delivered/invoiced by applying the criteria:
- Type = Sales order
- Status is one of Pending Fulfillment or Partially Fulfilled
- Item Type is Inventory Item or Discount (we care only about the dollar value of merchandise)
- Formula field where we narrow down the item to be qualified to "CASE WHEN {quantity}-{quantitybilled}=0 THEN 1ELSE 0 END" and consider the item if the quantitybilled is 0
Result screen has Sum(Amount)
In our use case we realized that a specific line item could be partially delivered/invoiced. Example: If line item may have 10 items ordered, but we delivered/invoiced 5 but 5 are pending.
Our backlog sales order must consider the 5 items as part of the total dollar value of the backlog.
How can we achieve that?
Any pointer would be greatly appreciated.
Many thanks in advance.