Does anyone know where I can find good documentation on how to creat custom business alerts?
Thank you,
Donnette
*This post is locked for comments
Hi Donnette,
You can refer to the Business alerts in GP helps documentation. Open the Define Business Alert window and click the help icon on it or press F1
Here are some blog posts related to business alerts.
www.gpwindow.com/.../Business_Alerts
www.erpsoftwareblog.com/.../business-alerts
dynamicsgpblogster.blogspot.com/.../using-business-alerts-with-extender.html
mbsguru.blogspot.com/.../custom-business-alerts.html
Rubal,
http://dynamicsgphelp.com/
Hey Donnette,
I agree with Rubal on the documentation, but I also want to point out that you need to have the SQL server setup to send the emails as well. Besides what Rubal mentioned above here is some more information specifically on the SQL side. It also includes a link on how to switch Dynamics GP from the old SQL email to the new version of email that SQL uses. Sending emails from Business Alerts
Till later,
John
Thank you John and Rubal.
We have BA set-up and have implemented some of the canned alerts, but I'm wanting to define alerts with different criateria.
I appreciate the input!
What kind of criteria are you trying to setup?
Is it a specific module of Dynamcis GP?
And while I am asking questions what version of GP and SQL are you using?
GP2010 and SQL2008
Our supply chain manager wants several alerts on the inventory items, item resource planning, and bill of materials.
For example: SCM wants to know anytime an item is set-up, with a certain item type, that does not have a standard costs.
It's easy to design a report with this data, but he wants to know when it happens and he doens't want to be required to run a report or query to see if something is missing.
At present I am still on GP10 and my Test Upgrade Server to GP2010 is being rebuilt (I test multiple times before I upgrade production). But I do not think that Business Alerts between the two have changed that overly much. In addition, my company does not use Inventory so I do not have any real data to test with but try this and see if it helps to get you headed in the right direction.
First, as it has been a while for me, I clicked on the help button and searched for "alerts" and got a ton of hits on how to setup, create, and maintain Business Alerts to refresh my memory.
Then I started the Business Alerts wizard and selected create a new alert.
Selected my company database, gave it an alert id and description.
On the next screen, I choose Inventory for the series, and Item Master for the table.
On the screen after that I selected my Item Master Table, and the Item Type field and clicked the Add Column button. (And as I have no inventory in our system this is where I start to get vague.)
Then you will need to select an operator most likely "=" and then enter and add whatever constant you need for a specific Item Type, then select the operator AND select the Item Cost field and an operator, I am guessing actually two operators NOT and BETWEEN then enter the constant <some dollar amount for the lowest price> another operator BETWEEN and then the final constant <some dollar amount for the highest price>. Given that I used the Item Type of 21 and 21.00 dollars for the low amount and 25.00 dollars for the high amount I ended up the this in the BUSINESS ALERT FORMULA box.
IV00101_T1.ITEMTYPE = 21 AND IV00101_T1.CURRCOST NOT BETWEEN 21.00 AND 25.00
After that that I clicked the next button and filled out all the EMAIL and SCHEDULE screens and that should be that.
PLEASE keep in mind that my company does not use the Inventory part of GP so I do not have a way to really test this. Give it a try and let me know how it goes.
till later
Thank you JOHN!
resurrecting an old post hoping for assistance.
I need a business alert that will check for the same item number more that once on a sales order as the third party shipping company software will not accept that.
I have the sql
select sop10200.SOPNUMBE, sop10200.ITEMNMBR, count(sop10200.ITEMNMBR)
from sop10200, SOP10100
where sop10200.SOPNUMBE = SOP10100.SOPNUMBE
and sop10200. SOPTYPE = SOP10100. SOPTYPE
and SOP10100.SOPTYPE = 2
and SOP10100.VOIDSTTS=0 -- Assume that VOIDSTTS=0 means Normal
group by sop10200.SOPNUMBE, sop10200.ITEMNMBR
having count(sop10200.ITEMNMBR)>1
business alerts does not seem to have the group by however.
can someone translate this into T-SQL, or suggest a different way to get business alerts to identify sales orders where item number repeats / is on the order more than once?
thanks!
Further to Jon Lowther's post -
Did you try adding the count function in the Business alert formula?
I had the below and it worked for me
drop the count onto the business Alert formula from the operator group by clicking on it and
pick the SOP10200 table and ITEMNMBR COLUmn make sure the table name and column name both are enclosed in the count parentheses like count (SOP10200_T2.ITEMNMBR) > 1
Click next and click on Message and report radio button from the Send To and add a list of recipients (full email addresses). Message text is optional and do a quick test mail. and next to include the columns you want to see in the report alert (mine had SOP10200_T2.ITEMNMBR, SOP10200_T2.ITEMDESC AND SOP10200_T2.SOPNUMBE) click next and finish up the scheduling etc. Make sure you leave the Enable Business Alert checked.
Hope this helps.
Hi Ven
thanks for the reply
I did try that before posting. I think count (SOP10200_T2.ITEMNMBR) > 1 gives you the orders that have more than one line. Where as I need to find orders where the item number duplicates anywhere within the order, hence the group by.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
