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

Comment Code

 1 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Kevin Hagan
Advanced Member
Posts: 30
Advanced Member
7/23/2010 4:47 PM
    I am working on creating a report that extracts various information on the PO based on the comment code. The code can be attached at the header or the line level. While I can see information on the comment code on table STCOMMCODE(PO). Unfortunetly this table has no links to a specific PO. in looking in various table like POLINE or PURCHORDER I have hade no luck in tracking the field to a specific table.

    Has anyone out there had any luck tracking down the table the comment code resides in.
    John Henley
    Posts: 3353
    7/23/2010 5:40 PM
      The are converted to the comment/attachment tables associated with the PURCHORDER (PCR) tables, L_HPCR/L_DPCR.
      See https://www.lawsonguru.co...ts-in-Lawson-v8.aspx
      Thanks for using the LawsonGuru.com forums!
      John