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
Nicholas LaHara
10/13/2022, 12:27 AM
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
Kenneth Jules
10/13/2022, 1:35 PM
Nick, the second solution provides the total quantity by sales order. However, no other field such as total amount, are not showing.
Kenneth Jules
10/13/2022, 1:46 PM
I was able to set the Amount field to a Sum Summary type.
Thanks for your help!