web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Business Alert for New...
Microsoft Dynamics GP (Archived)

Business Alert for New User Creation

(0) ShareShare
ReportReport
Posted on by Jim Lines 4

Greetings,
I feel like this question has probably been asked a million times, but I could not find anything in my searches so I'll ask...  Is there a way to set up a Business Alert to notify me when new users are created in GP?  I tried to create this myself but couldn't figure out how to build the formula.  Does anyone know if this is possible?

We do use Rockton's Auditor which is great for reviewing data, but I'd like to have an alert just the same.  Thanks in advance!

Jim

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Jothi Krishnan N Profile Picture
    Jothi Krishnan N 1,895 on at

    Select the Users Master table from system series and use the formula  SY01400_T1.CREATDDT  =  convert(varchar(10),getdate() , 101) ... 101 is the US date format. I havent tried it completely... but try and let us know if it works for u...

  • Jim Lines Profile Picture
    Jim Lines 4 on at

    Jothi,

    Thank you so much!  I've set up the BA and will see how it works.  Much appreciated!

    Jim

  • Jim Lines Profile Picture
    Jim Lines 4 on at

    Jothikrishnan.

    It's been some time since this advice, but I was just reviewing my business alerts and it appears this didn't work.  I'll try changing things up and see what happens.  Have you implemented this yourself? Any suggestions?

  • Suggested answer
    Jothi Krishnan N Profile Picture
    Jothi Krishnan N 1,895 on at

    Jim,

    I just tried and it worked like a charm. BA is nothing but a SQL Job. Did you look at you job and view history?  Is it failing? if so, try to address the errors. BA uses the Database Mail to send notifications. So, make sure you have one setup in SQL with a default profile and is working. Also when you setup a  BA thru Wizard, there is a Test mail option and make sure it sends a test mail. I chose Send Mail and Message with Report option and used the condition SY01400_T1.CREATDDT >= convert(varchar(10),getdate() , 101) .

    scheduled the job to run every 3 mins and it worked like a charm. I created a user and got an email with Text file containing new users.

    Regards,

    Jothikrishnan

  • Jim Lines Profile Picture
    Jim Lines 4 on at

    Jothikrishnan,

    I used the following condition and did get results.  Since I don't need to know realtime, I've set it to look a couple days back.  I'll give yours a try when I have some down time.  Thanks for getting back to me!

    SY01400_T1.CREATDDT > DATEADD(DAY, -2, GETDATE())

    Jim

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans