PO64 query

Sort:
You are not authorized to post a reply.
Author
Messages
pglibra
Veteran Member
Posts: 76
Veteran Member

    Good morning all,

    I am trying to write a query in Access pulling data from PO64...specifically, the transaction types listed at the bottom of PO64 of either REC, INV and RET. What Lawson table can I find these item types listed?

    Thanks

    pg

    Ragu Raghavan
    Veteran Member
    Posts: 468
    Veteran Member
      Looks like it is build in the logic. Look at PO64PD to see how it is coded:
      MOVE "REC" TO LIH-DOC-TYPE.
      MOVE "SUB" TO LIH-DOC-TYPE
      MOVE PJL-DOC-TYPE TO LIH-DOC-TYPE
      MOVE "RJ" TO LIH-DOC-TYPE
      MOVE "AC" TO LIH-DOC-TYPE
      MOVE "CB" TO LIH-DOC-TYPE
      MOVE "INV" TO LIH-DOC-TYPE.
      MOVE "CB" TO LIH-DOC-TYPE
      MOVE "INV" TO LIH-DOC-TYPE.
      MOVE "CB" TO LIH-DOC-TYPE
      MOVE "INV" TO LIH-DOC-TYPE
      MOVE "CB" TO LIH-DOC-TYPE
      MOVE "INV" TO LIH-DOC-TYPE.
      MOVE "CB" TO LIH-DOC-TYPE
      MOVE "INV" TO LIH-DOC-TYPE.
      MOVE "RET" TO LIH-DOC-TYPE.
      153954 MOVE PTH-VEN-CLAIM-TYPE TO LIH-DOC-TYPE
      pglibra
      Veteran Member
      Posts: 76
      Veteran Member
        Good morning,
        Not sure I know what you mean when you say it is built in the logic.
        I have access to Lawson tables, such as PORECLINE, etc.
        I am looking for the Field name that contains the text transaction type of REC/RET/INV, etc.
        Is there such a table/field?

        Thanks
        JonA
        Veteran Member
        Posts: 1162
        Veteran Member
          It depends on how much detail you need. You can find the line quantities in the POLINE table. REC is the receipt quantity; RET is the return quantity; INV is the matched quantity. But these are totals. If you need transaction detail like document numbers, dates and each transaction quantity (if there are multiple receipts or invoices for instance) you need to link POLINE to PORECLINE, PORETURNLN, and MAINVDTL.
          Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
          You are not authorized to post a reply.