Where can I find PO Line Comments Within Infor Lawson Query Wizard for Microsoft Excel

I am looking for the Lawson Table and field that contains po line comments. I would like to view PO's that have comments in "Comments to Print on Purchase Orders." I am using Infor Lawson Query Wizard for Microsoft Excel. Thank you

Find more posts tagged with

Infor Lawson Supply Chain Management - Discussion

Comments

unknown

I believe the table is L_HPCR and you would have to join it to PURCHORDER on L_INDEX. You would have to use SQL Management Studio or MSACCESS via ODBC to see this table. I'm not sure you can use addins in excel with this table but I have not tried. Hope this helps.

wjoye

Yes, and the table for requisition line comments (in case you're interested) is L_HRLN. You'd also join with L_INDEX and the comment "Name" is CommentP.

I also don't believe these tables are accessible with add-ins. We use L_HRLN in our requisition approval flow to allow for lengthier comments on special/service items, and can query these tables with SQL Server Management Studio (SSMS).

greenj

Thank you for the info. I was afraid I could not access this info via add-ins.

Copyright © 2025 Infor. All rights reserved.