Management of invoice printing

Lope

Hi all.

I'm modifying standard invoice report (206), because I want to change the order in which the registered invoices are printed. Rather than no. I want to be sorted by bill-to name, e.g.:

Invoice no. 12 - Bill-to name A
Invoice no. 8 - Bill-to name B
Invoice no. 15 - Bill-to name B
Invoice no. 3 - Bill-to name C
Invoice no. 6 - Bill-to name D
Invoice no. 13 - Bill-to name D
.
.
.

The problem is always sorted by number. I've tried:

- Change the "Sales Invoice Header" Dataitemtable view property to "Bill-to Name". -> No success.
- Change the order property in all the tables of the layout. -> No success.

What else I can try? It is impossible?

Thanks in advance. Regards.

mrealm1

Hi,
You would need to change the sorting in the Report Layout. In the Row_Groups right click on the group and select Group Properties. You can change the values on the Sorting section. Depending on your needs it may be worthwhile adding the Bill-to Customer Name to the datasource.