Prev
Next
Forums Lawson S3 Procurement

Purchase Order Comments

Sort:
You are not authorized to post a reply.
Author
Messages
Keogh
New Member
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
    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
      You are not authorized to post a reply.