RE: Odd saved search request for parent/child items
So – I need to have an ITEM saved search that gives me a list the items that appear on sales orders BUT ONLY if all of the variants/child items are on the sales order. Is this possible? I feel like it should be possible.
I can make this work if I do a TRANSACTION saved search, but that summary condition then doesn’t work in the next steps for how the data is used.
Hi MossIT,
Please set the search criteria for Transaction search as below,
Type = Sales Order
Main Line = False
In the results tab you can add the below columns,
Item
Item fields >> Item Name
Rate
Quantity
Amount
