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 Send Private Message
Posts: 3
New Member

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 Send Private Message
Posts: 5
New Member
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.