Low Stock BPM

[kp11 (kyle)]

I am trying to set a data directive BPM to email me when stock for a certain part gets under a certain quantity level (100 units). This is currently how I have it set on the PartWhse table , but it is sending me emails when any part goes from a qty over 100 to under 100 units. Where am I going wrong?!

[Jason_Woods]

Check that the onhandqty has changed from Any to Any
and
the changed value is less than 100

[TobyLai]

When dealing with Minimum Quantity notification. You can consider using the Kanban Implementation in Epicor.

There is a Min On-Hand Quantity in the Part itself under Part Maintenance -> Sites -> Detail

Maybe you can use that Min On Hand Quantity rather than hard coding the 100 in your BPM.

[A.Baeisa (Al)]

what type of Data Directive are you using ? change your row status in both conditions to changed row instead of updated to cover both cases (new and updated), i have created yours in my Test environment as standard and it is working fine

[kp11 (kyle)]

I am using a Standard Directive on PartWhse.
Odd thing is this BPM keeps firing on other partnums, not just the ones listed in the BPM condition.

[timshuwy (Tim Shoemaker)]

Try changing the “Updated Row” clause to “Any Row” and see if it helps. The problem is that there is not a changed row anymore in the dataset when it is a standard directive.