Finance | Project Operations, Human Resources, ...

Simple Query - SalesLine and SalesTable relation

(0) Share

Report

Posted on by ShawnDEV

678

Hi All,

It seems that there is a 1:N relation between SalesTable.SalesId and SalesLines.SalesId.

When I create a simple query, can I also add SalesLine as a child data source of SalesTable ? or should it be always the case that the SalesTable is the child data source of the SalesLine in the query if I want to relate these two tables each other?

Thank you.

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Shawn,

You can add SalesTable as a child datasource to SalesLine in your query. You can check the query SalesLineSRS as an example.

Was this reply helpful? Yes No
ShawnDEV 678 on at

Like (0)

Report

Hi Sorry,

the other way round.. can we add Sales Line as a child data source of Sales Table?

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Yes, you can.

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Shawn,

Yes, you can always do that. You can check the query SalesTableListPagePartiallyPicked as am example. If you are looking to loop through all the data, you should change the Fetch mode for "SalesLine" datasource to "OneToN".

Was this reply helpful? Yes No
ShawnDEV 678 on at

Like (0)

Report

Thank you.

I would like to make a relation btw ReqTrans and InventTrans.

I have ReqTrans as a main data source and added SalesTable as a child data source.

Then I wonder if I have to add SalesLine as a child data source of SalesTable or add it under ReqTrans data source directly and add a relation.

what is the preferred way of working?

Thank you.

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

Like (0)

Report

It depends of what you want to achive. Joining a table with an order header or an individual order line are two different things.

Was this reply helpful? Yes No
ShawnDEV 678 on at

Like (0)

Report

In my case, the latter is the purpose.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Shawn,

If your requirement is to join ReqTrans with InventTrans, Why don't you join ReqTrans with InventTransOrigin and join InventTrans to InventTransOrigin? Or do you need the data from sales orders as well?

Was this reply helpful? Yes No
ShawnDEV 678 on at

Like (0)

Report

Yes. I need data from Sales order as well.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (1)

Report

If you need sales order line details only you can try joining SalesLine to InventTransOrigin based on the field InventTransId.

Was this reply helpful? Yes No