Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

PO Comment database location

 3 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
dukeslater
Basic Member
Posts: 9
Basic Member
3/7/2014 6: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
    Posts: 3353
    3/7/2014 6:58 PM
      https://www.lawsonguru.co...ent-Attachments.aspx
      https://www.lawsonguru.co...ts-in-Lawson-v8.aspx
      Thanks for using the LawsonGuru.com forums!
      John
      Kat V
      Veteran Member
      Posts: 1020
      Veteran Member
      3/7/2014 7: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
        Basic Member
        Posts: 9
        Basic Member
        3/7/2014 7:19 PM
          Got it, thanks to all.