Do the comments on a PO line get stored in a backend table somewhere? I'm looking for a way to pull a report via ODBC and include this info. If possible, which table and field would it/they be in?
Thanks,
Kyle
Here is the quick code I wrote. It duplicates records right now, but gives you a starting point:
SELECT DISTINCT lawson.purchorder.COMPANY,
lawson.purchorder.PO_NUMBER,
lawson.purchorder.PO_RELEASE,
lawson.purchorder.PO_CODE,
lawson.L_HPLI.OBJECT AS PO_HEADER_OBJECT,
LAWSON.L_DPLI.FILENAME,
LAWSON.L_DPLI.SEQNBR,
LAWSON.L_DPLI.OBJECT AS PO_LINE_OBJECT,
LAWSON.L_DPLI.ATCHNBR,
LAWSON.L_DPLI.L_INDEX
FROM lawson.purchorder
INNER JOIN lawson.poline
ON lawson.purchorder.COMPANY = lawson.poline.COMPANY
AND lawson.purchorder.PO_NUMBER = lawson.poline.PO_NUMBER
AND lawson.purchorder.PO_RELEASE = lawson.poline.PO_RELEASE
AND lawson.purchorder.PO_CODE = lawson.poline.PO_CODE
INNER JOIN LAWSON.L_DPLI
ON lawson.poline.L_INDEX = LAWSON.L_DPLI.L_INDEX
INNER JOIN lawson.L_HPLI
ON lawson.purchorder.L_INDEX = lawson.L_HPLI.L_INDEX
WHERE lawson.purchorder.PO_NUMBER LIKE '%9001007'
AND LAWSON.L_DPLI.FILENAME LIKE '%POLINE%'
GROUP BY lawson.purchorder.COMPANY,
lawson.L_HPLI.OBJECT,
LAWSON.L_DPLI.OBJECT,
ORDER BY lawson.purchorder.COMPANY,
LAWSON.L_DPLI.SEQNBR
I am also attaching a screen shot of the PO with comments. Please note that our former Capital director used to have his staff copy entire emails into comments!
Well I wrote that last line before I realized there isn't an upload file option! Let me know if you want the screen shot.
