PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/01/2017 6:57 AM by  John Beard
Purchase Order Cost Review Message (MA66.3) comments
 8 Replies
Sort:
You are not authorized to post a reply.
Page 1 of 212 > >>
Author Messages
pglibra
Supply Chain Revenue Coordinator
Private
Basic Member
(44 points)
Basic Member
Posts:20


Send Message:

--
06/29/2017 11:29 AM

    Good afternoon,

    I am trying to create a query in Access to look at closed cost messages to include the comments from "Has Comments" field.

    What table can I find the comment info?

    Thank you

    Paul

    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2285 points)
    Veteran Member
    Posts:779


    Send Message:

    --
    07/14/2017 4:26 PM
    The comments are in one of the L_DM tables but I'm at a loss which one. I thought it was L_DMIV (Message Invoice) but I can't find a table called that.
    brupp
    Mgr Supply Chain Systems
    UC Health
    Veteran Member
    (343 points)
    Veteran Member
    Posts:147


    Send Message:

    --
    07/21/2017 11:02 AM
    Our Crystal Report is pointed to L_HMAG.Object for the MA66.3 comments.
    pglibra
    Supply Chain Revenue Coordinator
    Private
    Basic Member
    (44 points)
    Basic Member
    Posts:20


    Send Message:

    --
    07/25/2017 9:27 AM

    Thanks for your response.

    What table can I find L_HMAG? I do not see it in MAINVMSG.

    Thank you

    Paul

    pglibra
    Supply Chain Revenue Coordinator
    Private
    Basic Member
    (44 points)
    Basic Member
    Posts:20


    Send Message:

    --
    07/25/2017 10:26 AM
    Ok...I found the L_HMAG table but unable to locate field that contains the actual text for the comments.
    R_NAME gets me the Title of the comment.
    You are not authorized to post a reply.
    Page 1 of 212 > >>