Director of Software Development & Integration for Sta-home Health & Hospice, Inc.Chairman of the Board of Advisors for the Dynamics GP User Group (GPUG)
10+ years with Dynamics-GP (GL, AP, HR, Payroll, Maintenance, Training, Upgrades, Security) 15+ years as a Database Administrator (Maintenance, Performance, Warehousing, Validation, Correctness, Alerts, BI & Reporting)20+ years as a Developer (Written software for IBM, BCBS, Schools, Nursing Homes, & Home Health)
You can follow my blog here or my other networks below:
Any views contained within are my personal views and not necessarily Microsoft policy or the policy of Sta-home Health & Hospice, Inc.All posts are provided "AS IS" with no warranties, and confers no rights.
Blogs Outside of the Dynamics CommunityIn Recovery by Paul RandalSQL Skills by Kimberly Tripp
Post SeriesCreating an EDW for CBI SeriesGetting Data from Point A to Point B
For years I have been writing alerts to let either myself of someone else know that there is a problem somewhere so that it can be fixed before it becomes a major issue. Now, over the years I have boiled my alerts down into a few generic types. And while I will keep you guessing as to the types of alerts themselves, I will give you the code to one of them for your review.
Now, I can just about assure you that this code will not work on your system as is. You will need to modify it to fit your needs. Things like who gets the alert, your database names, the actual name of your 401k deduction and benefit codes, etc.
I hope that most of it is understandable for most people but as always if you have any questions feel free to drop me a line, (just remember to put GPUG) in the subject line.
Here is the link to the code on the GPUG Share My Code
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics