PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/07/2014 2:19 PM by  dukeslater
PO Comment database location
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
dukeslater
Private
Private
Basic Member
(17 points)
Basic Member
Posts:9


Send Message:

--
03/07/2014 1:44 PM
    On PO20.1 there is a button labeled 'Add Cmt'. Clicking it brings up an Attachments window, and under 'Comments to Print on Purchase Orders' I need to find both the Title and Text fields. My usual methods of tracking this down don't seem to work for this one.

    Thanks in advance for any direction you can provide.

    John Henley
    Private
    Private
    Senior Member
    (9809 points)
    Senior Member
    Posts:3287


    Send Message:

    --
    03/07/2014 1:58 PM
    https://www.lawsonguru.com/Articles/View/tabid/346/ArticleId/412/Example-SQL-for-extracting-Comment-Attachments.aspx
    https://www.lawsonguru.com/Articles/View/tabid/346/ArticleId/549/Comment-Attachments-in-Lawson-v8.aspx
    Thanks for using the LawsonGuru.com forums!
    John
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2674 points)
    Veteran Member
    Posts:914


    Send Message:

    --
    03/07/2014 2:00 PM
    Comments are in a link table called lawson.L_HPCR or L_HPCH the "Title" is filename I think. The text field is OBJECT. You link to PURCHORDER or POLINE via the L_Index field.
    dukeslater
    Private
    Private
    Basic Member
    (17 points)
    Basic Member
    Posts:9


    Send Message:

    --
    03/07/2014 2:19 PM
    Got it, thanks to all.
    You are not authorized to post a reply.