looking for a quick and easy way to print a report that:
a) is sorted by estimated ship date
b) lists customer name, item #, so#, qty to ship (or shipped), unit price and totals
c) included items that have shipped and been invoiced and items that have not shipped yet
 
I can make a report that is exactly what I want using SO-O-J, but for the lines that have already been invoiced it leaves a 0 qty which doesnt calculate out into the totals. I want that info so I have a master report to see what has shipped and what needs to ship.
 
For example, run SO-O-J, sort user defined as:
index 1: est ship date (break).
on second screen enter estimated ship date start and finish, anc select 'y' for include closed so's
 
if that report included the qty's for the shipped items it would be gold Jerry, gold!
 
now I have to run that report along with a sales analysis report to get totals of items already shipped and add the totals. its a pain in the rear.
 
am i missing a simple solution to this without having to edit the rtm to pull different data?
 
-mike
 
Evo - ERP Version 2007.1 Build 2/14/07