Finance | Project Operations, Human Resources, ...

Relation between RFQ table and PR table x++

(1) Share

Report

Posted on by Menna Allah Ahmed

163

I created report to get all RFQ and PR related to , but I can't find the right relation I found relation by RFQCaseId but doesn't work in all cases , So I need the right relation

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Menna Allah Ahmed,

What are the names of the tables?

Regards,

Waed Ayyad

Was this reply helpful? Yes No
Menna Allah Ahmed 163 on at

Like (0)

Report

PurchReqLine and PurchRFQCaseLine relation ?

PurchReqLine and PurchLine relation ?

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Menna Allah Ahmed,

PurchReqLine and PurchLine relation :

This is the relation between PurchReqLine and PurchLine, also there is a relation between PurchLine and PurchReqTable

As a note also there is a relation between purchReqTable and PurchReqLine.

PurchReqLine and PurchRFQCaseLine relation ?

From this method (In table PurchRFQCaseLine ) you can get the relation

PurchReqLine purchReqLine(boolean _update = false)
{
PurchReqLine reqLine;
reqLine.selectForUpdate(_update);
select firstonly reqLine
where reqLine.LineRefId == this.ReqLineRefId;
return reqLine;
}

Regards,

Waed Ayyad

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No
Layan Jwei 8,097 Super User 2025 Season 2 on at

Like (0)

Report

Hi Menna,

In general:

PruchReqLine.LineRefId == PurchLine.PurrchReqLineRefId

PruchReqLine.LineRefId == PurchRFQCaseLine.ReqLineRefId

But what were you trying to do when you said you found a relation with RFQCaseId? as this field doesn't relate to PurchReqLine -- so can you please explain more what are you trying to do?

Thanks,
Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No