When you set the rule to “available at location” it is going to email you every time a part is used because the rule will run when the part is used and then since the part is available it will fire off and email you.

I have similar rules to what you are trying to do and they are set up as follows.  Under parts use the trigger of when “Used.”  For When these conditions are met I used two filters.  Filter one is Part Name and filter two is Quantity Available.  I then set the quantity to Less then or equal to: X where X is the number that I want to get emailed about.

This rule will now trigger when the defined part is used and then look at the quantity available at the building.  If the quantity remaining is X or lower it emails me.

Hope that makes sense and clears it up for you.

Thanks Scott. Do you have individual filters for each part? I have about 30 different parts across 4 locations, all with various min levels. Do I need to do this for each part and each location?

I do have a filter for each part I want an email about.  This is because I only want an email for about 10 different parts (the rest of our parts are not used enough for us to stock at each building) and have a different remaining quantity that I want email about based on how quickly we go through those parts.

If you want an email any time a part gets to something like 5 remaining you could use just the quantity available filter and it should email you any time any part gets to that quantity.

OK that’s good to know. Thanks Scott for your help.

@Scott-CCS Love that you have shared your insight in our Community! Way to be a rockstar!!