Go to previous topic
Go to next topic
Last Post 01/30/2009 5:56 PM by  John Henley
AP Invoice Comments
 3 Replies
Author Messages
Meghan
Private
Private
New Member
(1 points)
New Member
Posts:1


Send Message:

--
01/30/2009 2: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
    Private
    Private
    Veteran Member
    (3402 points)
    Veteran Member
    Posts:1130


    Send Message:

    --
    01/30/2009 3: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.

    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    TimF
    Private
    Private
    Basic Member
    (10 points)
    Basic Member
    Posts:4


    Send Message:

    --
    01/30/2009 3: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
    Private
    Private
    Senior Member
    (9812 points)
    Senior Member
    Posts:3288


    Send Message:

    --
    01/30/2009 5: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.com/Articles/View/tabid/346/ArticleId/549/Comment-Attachments-in-Lawson-v8.aspx
    Thanks for using the LawsonGuru.com forums!
    John


    ---