AP Invoice Comments

 3 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Meghan
New Member Send Private Message
Posts: 1
New Member
I am trying to set up a query that will pull down AP invoice information including any comments attached to the invoice.  Since invoices are included as an attachment, is there any way to include them in the query?
JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
I've wanted to pull comments in a query on the PO side for a long time.  The problem is that comments aren't stored in any table.  The way I understand it is the comments are an XML attachment.  Maybe somebody more fluent in XML/Database lingo can explain better.  Suffice it to say, you can't use Addins to query comments.

Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
TimF
Basic Member Send Private Message
Posts: 4
Basic Member
I believe you can link them using SQL or perhaps MS Access query common field is L_INDEX - link the AP invoice record to the same field in the L_DAPI table - - I had to do this to find some corrupt comment records awhile back and it worked.
John Henley
Send Private Message
Posts: 3351
Here's an article on how comments/attachments work, with some SQL to show how to join--it's related to POs, but same concepts apply.
https://www.lawsonguru.co...ts-in-Lawson-v8.aspx
Thanks for using the LawsonGuru.com forums!
John