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
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
    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
      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
        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.