35
Hi, I have to create a business alert when a new account is created in a specific range. I need to know the formula I have to use (table, constant, etc.) to trigger it (today's date)
Thanks,
Michel
*This post is locked for comments
Thanks for your fast response, I will check if they want to know who create the account or not.
They only want to know when a new account is created in the system. Only some people are supposed to created new accounts, they want to be sure nobody else is doing it. No problem for time zone, only one server to check.
Regards,
hi Michel
it depends on what you want to have reported back to you.
GL account master = GL0010
created date = CREATDDT
consider modified date as well to know when people are changing things = MODIFDT
to get the server date convert(date,GETDATE()) Do you have any time zone issue that would need you to add or remove time from the server date? Originally my server was two time zones away and I had to subtract two hours. It's much simpler now the server is in my office.
I have my business alert going off at 23:59 so I have 1 minute of exposure. The likelihood of someone being in GP at that time of night is very small.
Also consider making use of activity tracking. The business alert is handy in finding out what was added but it there is no added by field on the tables. Activity tracking can tell you who added it however.
ian
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (