PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/26/2019 5:54 PM by  Elmer Madarang
AP40.1 query (ADDINS) on Comments
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Elmer Madarang
AP prgrm governance Specialist
Private
New Member
(6 points)
New Member
Posts:4


Send Message:

--
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
    Private
    Private
    Veteran Member
    (1438 points)
    Veteran Member
    Posts:510


    Send Message:

    --
    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
    AP prgrm governance Specialist
    Private
    New Member
    (6 points)
    New Member
    Posts:4


    Send Message:

    --
    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.
    You are not authorized to post a reply.