PDA

View Full Version : Report Showing Shipped Sales by Product Code



Mike R
02-07-2017, 08:25 AM
Has anyone run a report, or know how to create one, that shows shipped sales by product code? I figure you would want shipped sales and not just orders because we get a lot of orders created and immediately deleted due to credit card declines.

Total dollar amount of sales would be nice, but I'm really looking more for total number of units sold for each product code. We're about to make an order with a new distributor in China, and I need some numbers to get a good idea of projected demand.

Thanks,

Mike

Mike R
02-08-2017, 04:48 PM
Ignore that post. I poked around here and found a report that was close. Although I don't know the first thing about SQL, I managed to figure out enough to tweak it and get the data I needed.

Mike