Comments

Welcome to LawsonTalk. We hope you enjoy your visit.

You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free. After registration, please check your e-mail within 24 hours for an message from us, read it, and reply to it.

Join our community!

If you're already a member please log in to your account to access all of our features:

Comments; Comments in reporting
Topic Started: Jul 15 2009, 11:55 AM (162 Views)
soxfan625	Jul 15 2009, 11:55 AM Post #1
Newbie Posts: 5 Group: Members Member #14,775 Joined: April 15, 2009	Has anyone out there figured otu a way to get comments into a report or query? We are using Process flow and writing approval comments into the requisition display comments and I have not been able to find a way to get them out of the system. I know they are stored in quasi-tables which don't show up in DME or any other tool I have seen. Any help would be appreciated.



dczarny	Jul 16 2009, 04:21 AM Post #2
Member Posts: 19 Group: Members Member #14,855 Joined: June 8, 2009	If you query the table using the native database drivers, you can get the information. If you are using the Lawson tools, you might have to try an IDA or Drill query. This is an example of where you can find them with a SQL Server driver. select * from dbo.L_HPCR where L_INDEX in (select L_INDEX from PURCHORDER WHERE PO_NUMBER = ' 67452')


« Previous Topic · Reporting (NEW!!) · Next Topic »