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

PO Comments

 5 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Kevin Hagan
Advanced Member
Posts: 30
Advanced Member
5/5/2010 6:07 PM
    I am working on a report and looking to pull in the comments added from the PO20 screen. Originally I thought that they would be stored in either L_HPCR or L_DPCR but that turned out not to be the case. I am hoping that someone can point me to the table these comments are stored in.
    Arvin Ojales
    Advanced Member
    Posts: 24
    Advanced Member
    5/6/2010 12:09 AM
      Hi Kevin - Those are the correct tables, what version of env and app are you running?

      Arvin Ojales
      Kevin Hagan
      Advanced Member
      Posts: 30
      Advanced Member
      5/6/2010 1:25 PM
        We are on Env 9.0.0.8 and Apps 9.0.0.4

        I thought I would find the comments in L_DPCR linking the L_index though to PURCHORDER or to POLINE has not brought back the comments succesfully
        Arvin Ojales
        Advanced Member
        Posts: 24
        Advanced Member
        5/6/2010 1:57 PM
          L_INDEX is the correct link, it should return the Comments, I just tried it here and was able to retrieve the comments for a PO using SQL query.
          Arvin Ojales
          Advanced Member
          Posts: 24
          Advanced Member
          5/6/2010 2:10 PM
            You're linking the PURCHORDER L_INDEX to L_HPCR.L_INDEX and POLINE.L_INDEX to L_HPLI.L_INDEX right?

            Now, if the comments are full on these L_HPCR or L_HPLI, the system will write the continuation to L_DPCR and L_DPLI Tables depending if the comment is for PURCHORDER or POLINE.
            Kevin Hagan
            Advanced Member
            Posts: 30
            Advanced Member
            5/6/2010 2:29 PM
              The PLI tables was the piece I was missing,

              Thanks for the help