PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 02/19/2015 2:38 PM by  JonA
Query
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Juarez
lll
Private
New Member
(1 points)
New Member
Posts:1


Send Message:

--
02/18/2015 12:57 PM

    Hello everyone, I am new to Lawson add-ins. I need to download vendor information and other related information. I'm getting some info from the table APVENMAST and from another query from items and related vendors.
    In the items master table (itemmast) I have found all items and related information, but I cannot see any vendor info.
    How should I do for getting that info? That is: download all items with its related vendor.
    Another thing: is there a way to filter items only for my company? is there such link?

    JonA
    Private
    Private
    Veteran Member
    (2863 points)
    Veteran Member
    Posts:1007


    Send Message:

    --
    02/19/2015 2:38 PM
    Vendor information for items resides in a couple places. The POITEMVEN table will give you the items and their vendor(s) and vendor catalog numbers, which should be all active items. ITEMSRC will give you the specific vendors for an item for a specific location- par (IC81) or Item Location (IC12). Both tables relate out to APVENMAST and ITEMMAST in Addins so you can bring in item master and vendor master data in one query. Filtering by company will only work for the ITEMSRC table unless you have multiple Item Groups with a 1 Company to 1 Item Group ratio. Then you can just filter on the Item Group for your company if querying POITEMVEN.
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    You are not authorized to post a reply.