I'm trying to make a saved search for Sales Orders that filters to orders with only one line item on it. The item itself can have as high a quantity it wants, I just want to pull the orders that only have a singular line item on it. Any suggestions on achieving this would be wonderful.
k
KevinJ of Kansas
05/05/2020, 6:08 PM
Summary criteria count({lineid (select it from the drop down)}) equal to 1 - note that you may have to exclude tax/shipping/cogs/mainline
r
Robert Forbes
05/05/2020, 6:22 PM
Tried this. In the results it splits up the orders to shown by separate items but it still is showing orders with multiple line items.
j
Jay
05/05/2020, 7:17 PM
hmmm perhaps sales order: item, summary type=count? then filter for the 1?
r
Robert Forbes
05/05/2020, 7:32 PM
Count item is equal to 1 does the same thing. Splits up the orders by line item instead of only giving me orders with a singular line item.