Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Smart Notification
Information for acactivity
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Wayne Willis
Past 24 Hours:
1
Prev. 24 Hours:
1
Overall:
5190
People Online:
Visitors:
262
Members:
0
Total:
262
Online Now:
New Topics
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1351
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Smart Notification
Information for acactivity
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Ruma Malhotra
Veteran Member
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
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
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
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
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
Senior Member
Posts: 3348
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
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
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
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
Senior Member
Posts: 3348
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
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.
You are not authorized to post a reply.