Querying Lawson Drill Around Comments


WHER ARE MY COMMENTS?!  Many Lawson screens have comment buttons that open a drill-around screen with different comment types.  If you have ever wished to query these comments for reporting or other user interfaces, you may have noticed that they are difficult to find.  Infor has “hidden” them in tables with the “L_H” prefix.  The naming convention is “L_HXXX” where “XXX” is the prefix of the table that feeds screen where you add the comments.  For instance, Requisition Header comments can be found in “L_HRQH”.  And APINVOICE comments can be found in “L_HAPI”.  Join the comments to your main record using the “L_INDEX” column.

I hope this tidbit has saved you some time!!