Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

Comment Code

Sort:
You are not authorized to post a reply.
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
    Senior Member
    Posts: 3348
    Senior Member
    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
      You are not authorized to post a reply.