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

HOLD CODE Query Assistance

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


Katfra











Advanced Member



Posts: 30




Advanced Member



5/9/2012 12:27 PM
    Hello,

    Could someone give me a little assistance in writing a query in AP that would give me HOLD CODES?  I've tried different combinations with tables to achieve this but failed each time.  I'm trying to produce a query that give me the following:

    Company, Invoice, Invoice DTE, Invoice Description, Process Level, Vendor, Vendor-Vname, Vendor Group, Tran Inv Amt. 

    I've used the APINVOICE and APPAYMENT tables and was able to pull in the HOLD CODE fields due to relationships but each time i have no results for that field.
    If i run an AP240 report which shows hold codes for invoices, i receive results.  The reason i don't use the AP240 is i have to enter each company and we have 50 companies.  If I can create a query, this would eliminate a lot of time.

    Thank you,

    Frank


    JonA











    Veteran Member



    Posts: 1163




    Veteran Member



    5/18/2012 10:47 AM
      How about starting with the APHLDINV table? That will get you Company, Invoice, Process Level, Vendor, Vendor Group and also the Hold Code. Then relate to APINVOICE for Invoice DTE, Invoice Description and Tran Inv Amt; and relate to APVENMAST for the Vendor Name. I did attempt this with addins and was not able to get all the information from the related tables though. But when I tried the same query in Crystal (ODBC) the data was correct.
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health