Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

Crystal for Financial Reporting

Sort:
You are not authorized to post a reply.
Author
Messages
Julia
Basic Member
Posts: 18
Basic Member
5/28/2009 1:34 PM

    We have a bunch of RW reports that are data sources for Crystal.  Crystal is then used to write reports such as balance sheet; income statement etc with the RW as the data source.  Modifications are a huge problem and I am proposing that we rewrite the reports in Crystal going directly to LAWSON data specifically the GLAMOUNTS, GLUNITS and FBDETAIL tables.  Most likely to have a view.  However I have noticed that there a bunch of RW data tables in LAWSON such as RWGRPDET and RWROWDET etc.  Could I use these as a basis for the grouping for my Crystal reports?  Has anyone used these tables?

    Julia

    Milo Tsukroff
    Veteran Member
    Posts: 47
    Veteran Member
    7/1/2009 4:52 PM
      We (re)created our financial reports in Crystal, using the GLAMOUNTS, GLUNITS, and FBDETAIL as you indicated. We didn't use RWGRPDET and RWROWDET, we just created the new reports "from scratch". Of course, the first report that worked, we used as the basis for the next report, and so on.

      The important thing to watch out for is to link GLAMOUNTS and FBDETAIL so that you get both sides whenever one side is missing. I had to create a special extract to some custom tables to do that. However somewhere I've seen code to do the linkage without needing special processing.
      mark.cook
      Veteran Member
      Posts: 444
      Veteran Member
      7/2/2009 11:49 AM
        You can also try GLCONSOL. It holds both Actuals and Budget in the same table. You have to use the tran_type field to tell the difference. It can sometimes be easier depending on how many other tables you are linking to.
        John Henley
        Senior Member
        Posts: 3348
        Senior Member
        7/2/2009 2:17 PM
          However, it is only for summary accounting units, not posting level.
          Thanks for using the LawsonGuru.com forums!
          John
          You are not authorized to post a reply.