Finance | Project Operations, Human Resources, ...

Relation between RFQ table and PR table x++

(1) Share

Report

Posted on by Menna Allah Ahmed

169

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

All responses (4)

Answers (0)

Sort by

Suggested answer

Waed Ayyad 9,222 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @Menna Allah Ahmed,

What are the names of the tables?

Regards,

Waed Ayyad
Menna Allah Ahmed 169 on at

Like (0)

Report
Copy link

Link copied!

PurchReqLine and PurchRFQCaseLine relation ?

PurchReqLine and PurchLine relation ?
Suggested answer

Waed Ayyad 9,222 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!
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
Layan Jwei 8,421 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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