Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Need prior quarter year to date

 6 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Diane G
Basic Member
Posts: 11
Basic Member
6/5/2009 1:42 PM

    I need a report that has current balance (balance sheet accounts)

    and current year prior quarter balances. I cannot find a data dictionary

    item for the curr yr prior qtr balances.

     

    Char
    Veteran Member
    Posts: 62
    Veteran Member
    6/5/2009 2:27 PM
      GLAmounts holds the data, GLChartDtl will tell you which are balance sheet
      k-rock
      Veteran Member
      Posts: 142
      Veteran Member
      6/5/2009 2:41 PM
        I used to just do an offset. Current year less 3 periods. Inform users that it is an offset and not always just a quarter end.
        Diane G
        Basic Member
        Posts: 11
        Basic Member
        6/5/2009 2:49 PM

          I tried doing an offset current period minus 3, but it wouldn't

          take that parameter. Can you tell me exactly what I should be entering? I'm really new to this.

          Thanks

          k-rock
          Veteran Member
          Posts: 142
          Veteran Member
          6/8/2009 3:10 PM
            I don't have access to Lawson anymore to see exactly what the syntax is, but I think it is something like Prior Period with a parameter for how far back to go. It is a data dictionary item.
            Diane G
            Basic Member
            Posts: 11
            Basic Member
            6/8/2009 3:24 PM
              I think that will do it...thank you!
              Milo Tsukroff
              Veteran Member
              Posts: 47
              Veteran Member
              7/1/2009 4:47 PM
                If you are creating a Crystal Report, you can run a dbdoc on GLAMOUNTS and see what fields to use ... but ... watch out for "Derived" fields. Run the Derived Field Report 'derfldrpt' to see how the derived fields are calculated, then create your own formulas to match. Or, even better, create a Database View with the Derived fields in it.