Display Customer Order Quantity
Hello All,
Just wanted to know how to create a reports that will show items quantity order by customer and the quantity invoiced using saved search or reports. Thank you!
Search type: transactions
Filters: type is Sales Order or Invoice (depending which one you want), mainline = F
Columns: Main Line Name, Item, Quantity, Amount (depends what you want)
You can add grouping on the columns to group by customer and/or type
Hello,
How do you do it in one search?

The above is already one search.
Hi, thanks but I need to show the items in one column, ordered in another column and invoiced in another column, all within one row. Is that possible?

You should just search on sales orders then, there are multiple quantity columns, sounds like you want quantity in one column and quantity billed in another.
That correct. I want quantity order in one column and quantity billed/invoiced in another. Very plain and simple, but might not be possible to display. See below for example.
Invoice #xxxx Item#xxxxxx Quantity Sold Ordered Quantity