0 unit price on sales order alert

(1) Share

Report

Posted on by Phoenix123

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,

All responses (9)

Answers (1)

Phoenix123 147 on at

Like (0)

Report

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 Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

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 147 on at

Like (0)

Report

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 Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

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 28,626 Super User 2024 Season 2 on at

Like (0)

Report

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 4,836 Super User 2024 Season 2 on at

Like (0)

Report

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 15,786 Most Valuable Professional on at

Like (0)

Report

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 147 on at

Like (0)

Report

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 Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

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.