Prev
Next
Forums Lawson S3 Financials

Contracts and Purchase Orders

Sort:
You are not authorized to post a reply.
Author
Messages
Chesca
Veteran Member
Posts: 490
Veteran Member
6/2/2015 4:52 PM
    Hello, hope someone can help me. NYS is requesting contracts and POs executed from x date to x date, what Lawson tables can I pull this data from? Thanks in advance for your help!
    JonA
    Veteran Member
    Posts: 1162
    Veteran Member
    6/4/2015 11:38 AM
      POLINE will have your PO detail including the agreement reference.
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      Chesca
      Veteran Member
      Posts: 490
      Veteran Member
      6/5/2015 5:07 PM
        Hi JonA, should the data from the PURCHASE AND POLINE tables or just the POLINE alone? I need purchase order, contract description (line description), PO date, Extend line amount, invoice date, total payments, purchase order amount, expense account, accounting unit, PO status, and tax ID.
        JonA
        Veteran Member
        Posts: 1162
        Veteran Member
        7/6/2015 5:57 PM
          I know this is late but I'll answer anyway. For PO date you'll need the PURCHORDER table. Invoice Date is in APINVOICE. For total payments you'll need MAINVDTL. Tax ID is in the APVENMAST table. Contract description is in the POVAGRMTHD table. Accounting Unit and Account (expense code) is in MMDIST.
          Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
          You are not authorized to post a reply.