I need to produce a Saved Search which shows only Sales Orders that are fully committed with no back orders. I can easily do this using Summary Criteria and Results… however, I have a fulfillment partner who uses this Saved Search with Web Services to pull the results into their system and their module cannot read a summarized Saved Search. So, I need to create a search that filters out Sales Orders with back ordered quantities.
The search, as it's set up today per guidance from the fulfillment partner is as follows.
Criteria:
Type is Sales Order
Date Created is before 1 hours ago
Status is any of Sales Order:Partially Fulfilled, Sales Order:Pending Billing/Partially Fulfilled, Sales Order:Pending Fulfillment
Item : Type is any of Inventory Item, Assembly, Kit/Package
Results:
Internal ID
Type
Document Number
Status
Date
Note: I do realize and understand that this search will display duplicate lines… one line per line of the sales order + mainline… this was the requirement handed to us by the partner and when I attempted / tested with them grouping or main lining the search, it broke their system…
If I use Summary Criteria and Results, I can achieve what I need but I need a solution that does -not- use summary per the above.