Hello everyone! When creating a saved search, how ...
# general
k
Hello everyone! When creating a saved search, how can we show the total quantity by sales orders? Also, we have created a 'Total Qty' saved search which totals purchase orders and sales orders quantity in a 'Total Qty' field.
n
Set your criteria to main line = T, and then reference your custom field. If you experience issues with your custom field, set criteria to main line = F, and group your SO# and sum your QTY by item.
k
Nick, the second solution provides the total quantity by sales order. However, no other field such as total amount, are not showing.
I was able to set the Amount field to a Sum Summary type. Thanks for your help!