Using Lawson Queries to pull the transmission type from PO20 data (EDI or FAX?)

Sort:
You are not authorized to post a reply.
Author
Messages


willz06jw











Basic Member



Posts: 24




Basic Member



    Thanks for your help,

    [I am using Lawson 9.0]

    I am trying to use Lawson Queries in Excel to pull the transmission type from the data for PO20.  

    For example: I need to know if the POs for last year were sent via fax, edi, or paper.  

    Thanks again for your help,
    Will


    Brad Schauer











    Veteran Member



    Posts: 76




    Veteran Member



      Will,

      I believe the field you are looking for is the PO Issue Method, it can be found on the PO20.2 (PO Header Options) screen, on the "Issue" tab.

      The field is stored on the PURCHORDER table, field name ISSUE-METH.

      Brad



      Brad Schauer











      Veteran Member



      Posts: 76




      Veteran Member



        Field values:

        F = Fax
        E= EDI
        D = Do Not Print
        P = Paper
        I = E-Mail

        Brad


        willz06jw











        Basic Member



        Posts: 24




        Basic Member



          Great that's perfect.  Thanks for your help!

          Will


          JonA











          Veteran Member



          Posts: 1162




          Veteran Member



            Sorry I didn't see this sooner.  But if you pull the PO issue method from PURCHORDER you will only return what the PO is set for at that time (the last revision). For example, if you have your PO10.2 record set to issue via EDI but your revisions are set to Paper or Do Not Print, your query may not return the kind of data you want. If you want to know how the PO initialy was issued (Revision 0) then query the POREVISION table and set your criteria to PO-REVISION=0. You can relate out to PURCHORDER to pull whatever other relevant data you need (but not POLINE- at least not with Addins, Crystal maybe).

            Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
            You are not authorized to post a reply.