AP Invoice Comments - LawsonGuru.com - LawsonGuru.com Forums -

Meghan

New Member

Posts: 1

1/30/2009 7:34 PM

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

Posts: 1162

1/30/2009 8:30 PM

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.

TimF

Basic Member

Posts: 4

1/30/2009 8:56 PM

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

Senior Member

Posts: 3348

1/30/2009 10:56 PM

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