6
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
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?
'
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?
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 ?
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).
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.
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.
#1
André Arnaud de Cal...
293,278
Super User 2025 Season 1
#2
Martin Dráb
232,000
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
