unique sorting request for pick list

johnsogj

In my business, most sales orders only have 1 line. Therefore, for efficiency sake, I would like my pick list to be sorted by location. HOWEVER, I do get some multi-line orders. and I would need all of the lines for these multi-line orders to stay grouped together regardless of location. So my ultimate requirement is to sort the pick list by the location of the 1st line item of each sales order. And if multiple lines exist for a single sales order, I would display them sequentially by line number.

PS - I am running this report from the Warehouse Activity Line table (filtering on only Activity = Pick and Action =Take)

can anyone help?

awarn

Maybe add a new field to the sales line - called 'First Line Location'. When the location field is validated, fill this field either with the location from the first line or the location of the current line (of course depending on what line youa re on).

Then use that field to sort...

-a