Setting a max stock threshold and sending notifications

[sidsonrexa]

Hello. New to ServiceNow and so far I really like the tool. Quick question regarding stock rules within inventory management.

ServiceNow lets you create stock rules to manage items that fall below a certain threshold by automatically either sending a notification or create transfer orders to replenish the stock. Our company leases a large portion of their assets and so don't have a large on-site stockrooms, instead we keep a small number on hand and bigger inventory is maintained at a vendor managed warehouse.

In addition to the existing stock threshold functionality the users would like the ability to specify a 'max threshold' as well. If the number of items in a stockroom reaches or exceeds the max threshold the stockroom manger should get a task to ship the excess inventory to the vendor warehouse. Is this already handled by ServiceNow? If not what would be the best way to provide this functionality?

[brian_quinn]

Siddharth,

If all you need is a simple email notification, you can create a new Notification by going to "System Policy -> Notification" and then clicking on the "New" button.

If you want the notification to go out when the stock level goes above 10 for instance, you could configure the following:

Table: Consumable [alm_consumable]

When to send: On Inserted, On Updated

Conditions: "Quantity" "greater than" "10"

If you had a different maximum for different types of items, you could add a notification for each type of item and add a condition to filter based on Model, or display name or something similar.   Another option would be to add a new field "Maximum Quantity" field to the alm_consumable table, and use the notifications "Advanced condition" to use javascript to compare the quantity field to the new maximum quantity field.

Thanks

Brian

[Surendar_M]

Hi @sidsonrexa ,

We have a similar requirement to introduce max threshold for the stockroom and would like to know the approach that helped in implementing the solution.