Sage 100

v4.4 - Is there a way to print SO invoices by customer #? I don't see this as a sort option under invoice printing. Since a wrk file controls the printing, I am think a custom Crystal report. Thoughts? TIA

Yes. Or 1) you could add a prompt or additinal sort grouping to the standard invoice, or 2) if you know there will be no changes to the invoices, update and use Invoice History Printing.

We have done an additional group on the invoice.

Yep, if you just want to group invoices by customer number an additional group works. Otherwise as Bill said you could add a runtime parameter and filter. System would mark all invoices as printed though.

So just add the grouping to the report that you want to use and the sort will work. I didn't think that was possible since the data source is a work file and all the sorting was done there.

Sorting is controled by fields in the work table that Crystal uses for group and sorting. The original order is inmatierial. It will work to add a new group to the top or replace Group 1 to subordinate any existing sorting.