Hello all. We are currently about to roll out the Request and Requisiton process for Purchase Orders. I’ve been trying to figure out how to link the Requested By of the Request to the PO. We want to see who submitted the request on the Purchase Order screen and the Purchase Order Report. But I am having a hard time figuring out the connections. Has anyone does this before?
Answer
Linking a Request to a Purchase Order
Best answer by ricoybanez
See screenshot, please take note that this is up to Purchase Receipt, so just stop until the 5th line on the relationship:
Output: Note I made a detailed Inquiry.
Hope it helps.
Hi
Can you provide a few screenshots of the 2 things you would like to connect? And are you referring to the PO Layout Document from Report Designer?
-RJ
At a high level, I’m trying to show on PO641000, the field RQRequest.EmployeeID. But I’ve been playing around in a Generic Inquiry and looking at DACs, and I’m not seeing a clear link,
Ideally, I would also create a Generic Inquiry that would show all Requests, the Requestion Ref number and the PO Order Number to show the link all the way through.
+3
See screenshot, please take note that this is up to Purchase Receipt, so just stop until the 5th line on the relationship:
Output: Note I made a detailed Inquiry.
Hope it helps.
Rico P. Ybanez
Yes, but I can’t see what you are using the link the different tables, which I think is the piece I am missing. Could you provide that, or the XML of the GI?
+3
attaching the xml file for your reference.
Thanks
Rico P. Ybanez
Thanks. That works like a charm!!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.