How to link REQ # to PO# in Lawson Tables

 1 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Laurie DeSantis
New Member
Posts: 3
New Member
New Poster
New Poster
Congrats on posting!

We have a report to run for a specific company and cost center.  The report needs to contain REQ# and PO#.  Which table(s) will obtain this information? Is there a current PO table that contains REQ# ?  We've tried REQLINE AND PORECLINE along with REQHEADER but are unable to link to get a PO#.  

 

Joe Carfagno
New Member
Posts: 5
New Member
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
Hi Laurie,
Please look at POLINESRC. The Origin_CD should be 'RQ'. The Source_Doc_N field contains the Requisition Number. The Requester field has the requester ID.