Insert Sales Taker/ sales Responsible name to Customer Invoice Transaction

(0) Share

Report

Posted on by Community Member

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();

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?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Mea_ 60,284 on at

Like (0)

Report
Hi rihanarika,

Try this

HcmWorker hcmWorker = HcmWorker::find(custInvoiceJour.WorkerSalesTaker); if (hcmWorker) { salesTakerName = hcmWorker.name(); }

Was this reply helpful? Yes No
Verified answer

Faqruddin 1,883 on at

Like (1)

Report

Hello Rihanarika,

//First create following static method on CustInvoiceJour Table;

public static CustInvoiceJour findFromInvoiceId(InvoiceId _invoiceId)
{
CustInvoiceJour custInvoiceJour;

if (_invoiceId)
{
select firstonly custInvoiceJour
where custInvoiceJour.InvoiceId == _invoiceId;
}

return custInvoiceJour;
}

//Second create display method on CustInvoiceJour table and find the worker with each invoice id...

public display Name workerSaleTaker()
{

return HcmWorker::find(CustInvoiceJour::findFromInvoiceId(this.InvoiceId).WorkerSalesTaker).name();
}

Now you can use above method form or report as per your requirement..

Regards,

Faqru

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi ievgen Miroshnikov,

still doesn't work :(

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Could you please tell us what you have done and what "does not work" ? We can't help you if we don't know what code do you have.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank You So Much!!!

It Work For me

:D

Was this reply helpful? Yes No