Who's On?

	Membership:
	Latest: Wojo
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5265

	People Online:
	Visitors: 265
	Members: 0
	Total: 265

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

Variance report

3 Replies

0 Subscribed to this topic

43 Subscribed to this forum

Sort:

Author

Messages

Chandra

Basic Member Send Private Message

Posts: 6

3/30/2009 8:03 PM

I am creating a budget variance report in reporting services. I am looking for (1) Revenue -- Acutal / Budget and (2) Expenditure - Acutal / Budget. I was able to go after some tables like GLTRANS, FBDETAILand etc.

Can some one help me please identifying what table should I go after for my requirements (1) and (2) above for Acutals and Budget ?

Thanks

Matthew Nye

Veteran Member Send Private Message

Posts: 514

3/31/2009 7:58 PM

i dont think this can be addressed as a standard answer since depending on how you implemented Lawson and your COA is set up will differentiate how to successfully accomplish this. A few things to remember are:

-You cant join FBDETAIL and GLAMOUNTS/GLUNITS directly since Budget is by account and actuals are by account and date
-Revenue and Expenditure will be based on the account mappings that relate to the those roll ups
-it may be possible that your company is using summary accounts that hold the mappings

you may get better response if you post this in the Lawson EPM (Enterprise Performance Management)>Lawson Business Intelligence/Reporting/Crystal

John can probably move this for you too.

hth
matt

k-rock

Veteran Member Send Private Message

Posts: 142

3/31/2009 8:33 PM

I always used a union query to view the tables by account, then calculated a variance in whatever tool I was using.

John Henley

Posts: 3351

3/31/2009 9:09 PM

I have a couple in the store (https://www.lawsonguru.com/store.aspx) that do budget vs actual. Have you looked at those to see if they come close to your needs?