I want to Custom at Customer Invoice Transaction Report and Insert Sales Taker or Sales Responsible Name
i using this code
recId = HcmWorker::find(SalesTable.WorkerSalesTaker).Person;
select * from hcmWorker
where hcmWorker.Person == wrIdRec;
tmp.SalesResponsible = hcmWorker.name();
or
recId = HcmWorker::find(custInvoiceJour.WorkerSalesTaker).Person;
select * from hcmWorker
where hcmWorker.Person == wrIdRec;
tmp.SalesResponsible = hcmWorker.name();
but it doesn't work to display sales worker/sales responsible
i think because query dataSourceTable using custInvoiceJour Table not SalesTable/SalesLine
but at Customer Invoice Transaction Report must using custInvoiceJour, any body help me to insert sales taker in this report?