• Search Forums
    Advanced Search Topics Posts
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