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

    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
      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.