• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Enterprise Resource Planning & Manufacturing Lawson S3 Procurement

Purchase Order Comments

 1 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Keogh
New Member Send Private Message
Posts: 3
New Member
5/13/2010 3:28 PM
Hello,

I am trying to create a file showing purchase order numbers and all PO comments entered for each PO.

L_HPCR holds comments but I do not see how I can show the PO number.

thank you,
Diane
sea2sky
Basic Member Send Private Message
Posts: 15
Basic Member
7/2/2010 1:00 AM
I suspect that you want more than L_HPCR, but I'm new to the data structures and am not entirely sure what you want. It might look something like this if you were on the MS SQL Server backend:

SELECT top 100 [NAME], PCR.*
,[ATCHNBR]

,[TYPE]
,[CRTDATE]
,[CRTTIME]
,[MODDATE]
,[MODTIME]
,[R_SIZE]
,[HEADSIZE]
,[OBJECT]
FROM [PROD].[dbo].[PURCHORDER] PCR
LEFT join [PROD].[dbo].[L_HPCR] L_HPCR ON PCR.L_INDEX = L_HPCR.L_INDEX
WHERE [FILENAME] = 'PURCHORDER'
ORDER BY COMPANY, PO_NUMBER DESC

Just two cents worth. If you have more details I might be able to cook up something more...

Cam