• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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
Send Private Message
Posts: 3351
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 Send Private Message
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 Send Private Message
Posts: 9
Basic Member
3/7/2014 7:19 PM
Got it, thanks to all.