Skip to main content

Notifications

Announcements

No record found.

Supply chain | Supply Chain Management, Commerce
Answered

0 unit price on sales order alert

Posted on by 147
Hello community,
 
I want to have a product with 0 price on the sales order and also be alerted when that happens. 
I try setting up alert for order lines (from Backorder lines form) when unit price is set to 0. 
Nothing happens however.
 
Any suggestsions on what might be wrong? Alerts are happening for other rules, so that part is ok.
Any other suggestions on how to handle this?
 
Kind regards,
  • Phoenix123 Profile Picture
    Phoenix123 147 on at
    0 unit price on sales order alert
    Andre, your last suggestion does seem to work.
    I didnt know alert rule would apply to already filtered table.
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    0 unit price on sales order alert
    Hi Phoenix,
     
    You can first set a filter on the order lines having the unit price to zero. Then create a new alert rule with the alert Record has been created. The alert will then only trigger for created lines where the price is zero.
    In case you need to have an alert also if someone changes the price, you would need a second alert (Is set to) also.
  • Phoenix123 Profile Picture
    Phoenix123 147 on at
    0 unit price on sales order alert
    Hello all,
     
    Thanks for your willingness to help. 
    If I set "Event" to "is set to:" nothing happens. 
    I believe it only triggers alert if the user overrides say price of 100 to 0. 
    I would need an alert if a product doesnt have price by default, it is 0, and a line is inserted to the order line.
    Maybe my original question was not clear enough, apologies if that is the case.
     
    GuyUK, if I select Event to be "Record has been created" it immediately resets "Field" to All fields, I cant select specific field condition with Record is created or deleted.
     
    Kind regards,
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    0 unit price on sales order alert
    Hi Phoenix,

    Can you give us an update on the status, please? Have you solved your issue or do you still need help from the community?
  • Suggested answer
    Guy Terry Profile Picture
    Guy Terry 28,621 Super User 2024 Season 2 on at
    0 unit price on sales order alert
    To follow up on Andre's suggestion, when you create the Alert rule, set Event = Record has been created.
     
    Then hit the Alert rule condition button.
     
    On one of the lines on the Range tab, set Field to Net amount or Unit price. Set Criteria to 0. Press OK.
     
    On the Alert rule, you'll see that the rule becomes conditional on this condition being met.
     
    Note that this type of Alert could trigger when the user is still working on entering the sales order lines. For example, they may spot that one line has zero price, and then update it. By the time the Alert has been checked, the price may have been corrected. Depending on your process, it might be better to put the Alert on the Sales order confirmations > Lines. In this way, the zero price could be spotted after the user thinks they have finished with the order entry.
  • Suggested answer
    andreasraithel Profile Picture
    andreasraithel 4,823 Super User 2024 Season 2 on at
    0 unit price on sales order alert
    Hy Phoenix123,
    instead of unit price you can use LineAmount and the rule if value is set to 0. I created the rule on the saleline-Table using tablebrowser, works fine for me.
     
     
    Hope this helps.
  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 15,786 Most Valuable Professional on at
    0 unit price on sales order alert
    Hi,
    The issue in here is probablybecause you do not fill as 0 in the price.
    Maybe as a workaround you can try to use 100 percent discount if fits your process.
  • Phoenix123 Profile Picture
    Phoenix123 147 on at
    0 unit price on sales order alert
    Thank you Andre, 
     
    yes, I have created a rule where unit price "is set to" 0, and by this point I understand that it wont trigger any alert by itself, without change.
    If I understand your suggestion I would have two conditions in my rule, when a record is created and price is 0. 
    I dont see such an option in the system.
     
    Kind regards, 
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    0 unit price on sales order alert
    Hi Phoenix123,
     
    Can you tell us the detailed steps you performed for creating the alert rule via the Backorder lines page? What rule did you implement? When changing the field Unit price or when creating a new sales order line? In case you have a rule on changing the field value and the user is not touching the field, it will indeed not trigger an alert. Then try also having a rule for creating a new line where the unit price is zero.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans