how i will know which sales order is tagged with which Sales taker?

(0) Share

Report

Posted on by @rp@n

hi All,

how i will know which sales order is tagged with which Sales taker? in report, sales taker drop down , i have select the sales taker name.

based on the sales taker name, i have to dipsplay the lines.

kindly let me know the exact table relation.

please give me more shed on this.

thanks

I have the same question (0)

All responses (8)

Answers (2)

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

You forgot to give us enough details. We can't help you unless you do your part.

Please tell us what kind of report it is and what problem do you have with applying the filter.

Also, notice that you ask for a table relation, but you forgot to mention what table you're talking about. And your requirement above is filtering a table by a value, not about relations between two tables.

Was this reply helpful? Yes No
Verified answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi @rp@n,

You can check field name if you go the sales table form and open personalization and found needed control there. In this case it's WorkerSalesTaker field on SalesTable and it's Rec id reference to worker table.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

In SalesTable there's field WorkerSalesTaker which points to HcmWorker.RecId. So if you have a lookup of workers, you can find all SalesTable records where WorkerSalesTaker is the same than the RecId of the selected worker.

Then you need to find all SalesLine where SalesId is same than on the SalesTables above.

These are the table relations (which you also find in AOT by looking at Relations node of the tables).

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

see, user will put from date and to date i.e mandatory. and sales taker

the from date and to date is filter with custPackingSlipJour.DeliveryDate. based on the transaction i need to search the sales id which is tagged with the sales taker. those lines need to display.

so, my question is how i will found, which sales order is tagged with which sales taker ?

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

So what's your question? How to filter a field? It depends on your implementation, that you still didn't mention, but I assume you'll a query object somewhere. Have you learnt how to use QueryBuildDataSource?

Or is your actual question how to join CustPackingSlipJour with SalesTable?

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

no martin,

suppose i select sales taker = aba, then how i will filter sales id's which is tagged aba only. those i need to consider only which is belongs to sales taker = aba only.

let me know the logic please... how i will get?

'

Was this reply helpful? Yes No
nmaenpaa 101,162 Moderator on at

Like (0)

Report

Didn't I just explain it? Was it unclear or did you even read my message?

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

sorry, nikoloas

i missed, thanks for your reply

Was this reply helpful? Yes No