+1
We need an generic inquiry that will show users statuses of their PO Requests all the way up to related PO Receipts.
Please help us to link the Request Line table to Requisition Line table.
There is a button on the Requests screen that will open up the Requisition detail. What fields should we use to link together Request Line to the related Requisition Line in the GI?
Many thanks in advance!
Best answer by hkabiri
View original
+5
You need to link Requisition Lines DAC/Table (RQRequisitionLine) to Requsition Content DAC/Table (RQRequisitionContent) using ReqNbr and ReqLineNbr as the link and OrderNbr and LineNbr on RQRequisitionContent will be your Request Number and Line Number.
SQL query can be something as followed:
SELECT * FROM
RQRequisitionLine R LEFT JOIN RQRequisitionContent C
ON R.ReqNbr=C.ReqNbr
AND R.LineNbr= C.ReqLineNbr
AND R.CompanyID=C.CompanyID -- Not necessary on GI
+1
Thank you very much Sam. That worked.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.