Prev
Next
Forums User Experience Lawson Add-Ins for Microsoft Office

Query

 1 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages


Juarez











New Member



Posts: 1




New Member



2/18/2015 5: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











    Veteran Member



    Posts: 1163




    Veteran Member



    2/19/2015 7: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 - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health