How can I export/ produce report of sales order lines and scheduled demand/shipments for let's say a week.
I already know how to export sales order lines and then make a pivot table to show what's shipping next week..
But is it possible to just combine these two on one report or screen?
I just want to see how many on hand we have and how many are going out together on same screen. It's just a pain to create two separate reports. Is there an easier way?
Help?