• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

How to create unapplied cash report for Lawson M3 database

 3 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Naresh
Basic Member Send Private Message
Posts: 7
Basic Member
12/16/2009 11:18 AM

i have experience with crystal but not with M3 database. I have LBI, M3 database(Oracle)

and crystal. I also have smart office client installed to access M3 and its programs.

User wants to see the Unapplied cash report of customers which doesn't include deposits by the customers.

 

What tables, fields, and conditions i should use to get this report?

Any help would be appreciated...

And , I have been reading lot about Lawson Apllication reports and Lawson Back office reports

what are these reports and how do i get them?

 

Rob Conrad
Veteran Member Send Private Message
Posts: 73
Veteran Member
12/17/2009 3:41 AM
Naresh -

Use the MDP (Metadata Publisher) - it's a great resource for providing the table relationships and fields necessary to create reports. You can enter a Program Name - ie: MMS001 and MDP will give you all of the tables/joins behind that program. You can also enter table name etc.

Hope that helps you out, drop me a note if you would like more info.

Rob
Naresh
Basic Member Send Private Message
Posts: 7
Basic Member
12/17/2009 12:09 PM
Thanks Rob... Metadata publisher is really helpful. I was able to get the relations and tables used.

Regarding my other questions:
Question 1) What are Lawson application reports and Lawson back office reports?

I was being asked in my project that do I know any of standard M3 reports...
Qeustion 2) where do i get these standart M3 reports?
Rob Conrad
Veteran Member Send Private Message
Posts: 73
Veteran Member
1/8/2010 7:18 AM
Hi Naresh -

Lawson application/back office reports are reports which are called from within the App - things like PMS230 etc. Lawson does provide standard SQL reports in the M3 Solutions Kit - it's downloadable from Products and installed using LCM.

I don't check this board too often - you can reach me on mobile if you need more info.

Rob
480.319.0559.