Information for acactivity - LawsonGuru.com

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

Ruma Malhotra

Veteran Member Send Private Message

Posts: 412

1/27/2009 6:04 PM

I am trying to create a smart note for activity management that notifies a user whenever a new activity in the project and activity management system is created. Looking at the ERDs on this site for activity management, there is a table acactivity that has all activity information for each activity created in the system. Looking at the technical documentation for this table there is a field that says acv_date_created which gives the date the activity was created in the system. However when you connect through OLEDB to this table this field is not present. Is the technical documentation updated or is it for an older version and is there any field that gives the date a new activity was added to the system. this date cannot be the begin date and the end date because these 2 dates gives the dates when an activity can begin and end accepting transactions.

Ruma Malhotra

Veteran Member Send Private Message

Posts: 412

1/27/2009 6:11 PM

I will not be able to use acaudit since we did not have audit history turned on.

Matthew Nye

Veteran Member Send Private Message

Posts: 514

1/27/2009 6:21 PM

Ruma, What if you connect directly to the database? Do you see it then? acactivity is a standard table and you should be seeing it from the OLE DB Query Builder. Are you sure you have rights to see it?

Ruma Malhotra

Veteran Member Send Private Message

Posts: 412

1/27/2009 6:28 PM

Hey Matt, I first connected through ODBC and I have access to all tables in lawson and I was not able to see it. then I used the schema browser on toad to look at all the fields and I could not see it there. Finally I looked through OLEDB and I cannot see it. Are you able to see it?

David Williams

Veteran Member Send Private Message

Posts: 1127

1/27/2009 6:58 PM

If you look up the ACV table with MS Add-Ins, what table does it indicate the field belongs to? Do the other fields for these records also belong to the ACV table?

John Henley

Posts: 3351

1/27/2009 7:02 PM

There are ERDs specific to various major versions (8.0, 8.1, 9.0). ACV-DATE-CREATED is a new fields in 9.0 apps, so if you are running an older version that would explain why you can't see it. BTW, I think you're using the wrong tool for this--you should be using ProcessFlow. There is already a service defined that can be triggered when an activity is added.

Matthew Nye

Veteran Member Send Private Message

Posts: 514

1/27/2009 7:03 PM

Yes, Im seeing that table from both the schema browser and Lawsons OLE DB query builder. What specific build of AC apps are you on?

Ruma Malhotra

Veteran Member Send Private Message

Posts: 412

1/27/2009 7:17 PM

We are on version 8.1 for apps but 9.0 for environment and maybe that is why i am not able to see the field. If this is in processflow and since we have a backlog for processflow I may just create the smart note till we have the processs flow in place. I don't know what else field to use for 8.1 apps. Any other ideas?

Matthew Nye

Veteran Member Send Private Message

Posts: 514

1/27/2009 7:34 PM

you could do a select statement of your Project and Activity and whatever other information, then in Step 2 you can do a condition to look for New Items. This operator can be a little tricky but used right it may give you what youre looking for.

John Henley

Posts: 3351

1/27/2009 7:58 PM

I'm not aware of any other place it is stored in the database. You can do a differences approach in LSN to send notifications for new records in the infoset. Not sure how/what your requirements are, of course.

Ruma Malhotra

Veteran Member Send Private Message

Posts: 412

1/30/2009 4:49 PM

Thanks Matt and john for your replies. We may not be able to use "The new items" in the second round since any change to an activity will also generate a smart note. We would be flooded with smart notes since we have more than 2000 activities built and there are constant changes to these activities as fas as the date range status, budget etc. I may just wait till we upgrade to 9 apps before creating this sn unless someone cries louder. Thanks anyway for all the help.