Finance | Project Operations, Human Resources, ...

Relation between RFQ table and PR table x++

(1) Share

Report

Posted on by Menna Allah Ahmed

343

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)

Layan Jwei 7,349 Super User 2024 Season 2 on at

Like (0)

Report

Relation between RFQ table and PR table x++

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
Suggested answer

Waed Ayyad 6,408 Super User 2024 Season 2 on at

Like (0)

Report
Relation between RFQ table and PR table x++

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
Menna Allah Ahmed 343 on at

Like (0)

Report

Relation between RFQ table and PR table x++

PurchReqLine and PurchRFQCaseLine relation ?

PurchReqLine and PurchLine relation ?
Suggested answer

Waed Ayyad 6,408 Super User 2024 Season 2 on at

Like (0)

Report

Relation between RFQ table and PR table x++

Hi @Menna Allah Ahmed,

What are the names of the tables?

Regards,

Waed Ayyad