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

AP40.1 query (ADDINS) on Comments

 2 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Elmer Madarang
New Member Send Private Message
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 Send Private Message
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 Send Private Message
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.