Sorting SalesInvoice report by ExternalItemId

maria_iva81

Hi there i have problems with sorting SalesInvoice report by ExternalItemId wich is a field not from the first table,but from CustInvoiceTrans, i added the field in the sorting property of the datasource table CustInvoiceTrans but it just won't work. Any idea what else must be done?Thanks in advance,

susana2

Hello! Records are printed from the overwritten fetch() method, using the CustInvoiceJour.queryCustInvoiceTrans() query. You shoud modify it, or use an own query in fetch() instead.