PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 01/10/2019 8:30 AM by  JonA
PO64 query
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
pglibra
Supply Chain Revenue Coordinator
Private
Basic Member
(44 points)
Basic Member
Posts:20


Send Message:

--
01/03/2019 7:31 AM

    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
    Private
    Private
    Veteran Member
    (924 points)
    Veteran Member
    Posts:322


    Send Message:

    --
    01/03/2019 3:24 PM
    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
    Supply Chain Revenue Coordinator
    Private
    Basic Member
    (44 points)
    Basic Member
    Posts:20


    Send Message:

    --
    01/04/2019 6:57 AM
    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
    Private
    Private
    Veteran Member
    (3033 points)
    Veteran Member
    Posts:1067


    Send Message:

    --
    01/10/2019 8:30 AM
    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 - Supply Chain Analyst - Materials Management - MidMichigan Health
    You are not authorized to post a reply.