News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Business alert

Microsoft Dynamics GP (Archived)

Business alert

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

How do I create a business alert to notify a user when a transaction gets posted to a specific GL account?

Thanks!

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

26P2ER 1,773 on at

Like (0)

Report
RE: Business alert

This can be done via Setup>System>Business Alerts in GP.

You will require 2 tables (Year to date open a.k.a GL20000 and Account Index Master a.k.a GL00105).

Pick Actindx to join these tables.

And in the business alert formula pick the Account Index Master column named Account Number String-

add "=" operator and type the full GL code in the constant box and add.

You should see the syntax as GL00105_t2.ACTNUMST = your GL code in the bottom.

Add a datetime field filter (pick dex_Row_ts >= getutcdate()-1 and dex_Row_ts < getutcdate +1

Click next and complete the notification section of the wizard as needed such as send an email

A business alert created this way will be added to the SQL Agent jobs. Be mentally prepared to be questioned by the DBA if and when he/she sees a new SQL Agent job added to the server.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2

Martin Dráb 231,287 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans