Who's On?

	Membership:
	Latest: Hitman
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5208

	People Online:
	Visitors: 466
	Members: 0
	Total: 466

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

smart notification condition/calculation help

2 Replies

0 Subscribed to this topic

14 Subscribed to this forum

Sort:

Author

Messages

Ruma Malhotra

Veteran Member

Posts: 412

2/8/2011 4:19 PM

I am trying to build a smart notification using the activity management piece in Lawson, and I was wondering if anybody can think of a better way to do this:

My infoset has a budget, a commitment and actual amount. I am supposed to notify a user when the expense spent on a project reaches a threshold value which is 5% of a budget.

My expense equals the actual and commitment amount. I have added an calculation column in my sql which is called the remaining amount which is ( budget – (actual
+ commitment).

When this amount reaches 5% of the budget the user should get notified. This has completely stumped me and I have tried different ways but cannot get this to work. A combination of condition calculation will just not work.

Any ideas ?

Ruma Malhotra

Veteran Member

Posts: 412

2/8/2011 8:34 PM

SInce I could not get the combination/calculation to work, I added a field in my SQL which tells me whether the Remaining budget is equal to the 5% thereshold value and is populated by a value if this is true or is blank(when false).

I then added this as a "key" when I define the fields. However on my condition when I use " New Keys", I am not seeing the right results.

The only issue I can think of is when you define a string column as a key does this work the right way ?

Matthew Nye

Veteran Member

Posts: 514

2/11/2011 8:06 AM

I dont trust "Has New" condition. Its always been so unreliable for me. If you get rid of the Has New Items you could schedule the note to delivery every hour but create a condition that only shows items >= 5%.