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

AP40.1 query (ADDINS) on Comments

 2 Replies
 0 Subscribed to this topic
 78 Subscribed to this forum
Sort:
Author
Messages


Elmer Madarang











New Member



Posts: 4




New Member



12/19/2019 4:32 PM

    I am building a query to indentify invoices that were put on hold in AP40.1 and pull out the comments under invoice notes(reason why the invoice was put on hold). 

    I don't know where those comments reside and I can't map it to pull out of the query. Please help

     

    thanks!

     

     



    JimY











    Veteran Member



    Posts: 510




    Veteran Member



    12/20/2019 6:41 PM
      The comments are stored in the L_HAPI table. You can use the L_INDEX field in the table APINVOICE to find them in the L_HAPI table. Good Luck.


      Elmer Madarang











      New Member



      Posts: 4




      New Member



      12/26/2019 5:54 PM
        Thanks Jim!!! I appreciate the response.
        Unfortunately I am only using a DME and don't have access to the L_ Tables.
        I put in a ticket to our Analyst team to pull the comments for our team.