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 Send Private Message
Posts: 11
Basic Member

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 Send Private Message
Posts: 62
Veteran Member
GLAmounts holds the data, GLChartDtl will tell you which are balance sheet
k-rock
Veteran Member Send Private Message
Posts: 142
Veteran Member
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 Send Private Message
Posts: 11
Basic Member

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 Send Private Message
Posts: 142
Veteran Member
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 Send Private Message
Posts: 11
Basic Member
I think that will do it...thank you!
Milo Tsukroff
Veteran Member Send Private Message
Posts: 47
Veteran Member
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.