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) / How to create a busine...
Microsoft Dynamics GP (Archived)

How to create a business alert properly

(0) ShareShare
ReportReport
Posted on by Mayra Humprey 3,125

Good day, License Microsoft Dynamics GP 10.0 Business Solution The procedure i want to do is be notified if the item's price or cost is being modified. So I tried the following steps = microsoft Dynamics GP =Tools> configuration>system> business alert When i get to the point I have to define the formula of the alert i don't how to define it,because i want to be notified for whatever reason it's modified. Thanks in advance, Mayra

*This post is locked for comments

I have the same question (0)
  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    This is a bit of a strange request. An item cost will most likely change due to your purchasing invoices. If you are constantly buying and prices are constantly fluctuating you will end up with tons of emails. Now, as for the item pricing, are you referring to the Price List or you are referring to the pricing provided to customers?

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    Although you did not say, most people when they ask for this want to know when a user has changed the price of an item on a sales order.  Unless your pricing scheme is simple, this can be a complex formula.  You need to compare the unit price on the sales order with the proper unit price for the customer.  While the unit price on the sales order is easy, it is the calculation of the proper unit price for the customer that is often difficult. 

    You need more assistance than can be provided in a forum to accomplish this.  You should contact your partner.

    Can this be done?  Maybe. Probably.  I would create a view that constantly creates a price book with current/correct pricing per customer.  Then compare the value in this view with the sales order and determine if an alert needs to be raised.

    To keep down the number of emails, you might consider printing a report daily listing these price changes and automatically generate that report.

  • Ron Wilson Profile Picture
    Ron Wilson 6,010 on at

    Mariano and Richard,

    I think she is using Standard Cost and is wanting to know if someone changes the standard cost on an item.  It is a very similar question to what she asked earlier but in a different form.

    Mayra...you will not be able to accomplish this with Business Alerts because you have no "original" price to compare to the new price.  If you have an item that costs $1.00 and someone changes it to a $1.10, you have no history to show that the original price was $1.00.

    You will have to use a solution that was provided in your last post.  My option with SQL would be extremely similar to business alerts but with an audit table.  Since you do not have anyone who can create anything like this in house, you will need to talk with your partner or one of the other companies that posted in your last question.

    Sorry this can't be done with Business Alerts out of the box.

    Ron

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    You can get a copy of KnowledgeSync from Vineyardsoft ( http://www.vineyardsoft.com/ ).  This is business alerts on steriods and does much more than simple business alerts.  It can do this and much more.

  • Ron Wilson Profile Picture
    Ron Wilson 6,010 on at

     Richard,

     I have trialed KnowledgeSync and I chose to go with TaskCentre.  I think it is a much more full featured alerting platform and use it for all of my alerting scenarios.  I also use it to monitor price changes like Mayra has requested and other auditing features.  However, I don't think KnowledgeSync or TaskCentre will audit for her out of the box.

    If I have a cost of $1.00 and then someone changes it to $1.10 then there is no history there to say 

    select * from iv00101 where item_old_cost <> item_new_cost

    Does that make sense?

    On another note, you really should take a look at TaskCentre.  It blew KnowledgeSync out of the water.

    Ron

  • Ron Wilson Profile Picture
    Ron Wilson 6,010 on at

     Sorry forgot the link (www.orbis-software.com/)

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