I need to create a concise list of all open Sales Orders that have 1 or more fillable/committed items on it. The problem I've found so far is, I can create a search of Open orders, but that includes all the backorders as well. It's hard to tell which orders we should prioritize because of all the clutter from the backorders. Alternatively, if I make the Main Line false, then it brings up every line item that is committed, which can cause a single order to take up 50+ lines on the report (i.e. not concise). If I group these by Document # (i.e. Sales Order #), then all I get is a list of Sales orders with no customer names, dates or any other helpful information.
What I'm looking for is a clean/concise list of Sales Orders (1 order/line) that have at least one item that can be shipped immediately. I'd like to have the results shows the typical customer information such as Date, Sales Order #, Customer Name, memo, etc.
The context for this report is, whenever we receive a shipment of various products, there are often a number of pre-orders or existing backorders for some of the products. Thus, there will suddenly be a whole bunch of orders that can now be filled/shipped, often for customers that have been waiting for awhile.