OOB Scheduled Job - Stock Rule Runner

SNOW User8 · ‎07-11-2018

Hi All,

Want to know the flow/process of OOB Scheduled Job - Stock Rule Runner..

If anyone know about this, kindly share your comments

Jaspal Singh · ‎07-11-2018

Threshold as name suggests is a level where something would/should happen. In Stockroom's case it is used in Stock rule created so that if the quantity is less than Threshold a notification should be triggered.

For e.g. Stock rule for Laptop is created with threshold 5. Whenever quantity is less than 5 notification would be triggered to Stock room manager so as to refill the stock with necessary laptop.

Order would mean refilling the number of items so as to reach atleast the threshold level. This is further invoked by Script include StockRuleTransfer which has various functions that are triggered accordingly.

Hope that helps.

Thanks,

Jaspal Singh

Hit Helpful or Correct on the impact of response.

View solution in original post

Chuck Tomasi · ‎07-11-2018

I don't see this on my baseline instance. Did you activate any plugins, like Facilities Management, to get this?

SNOW User8 · ‎07-12-2018

Hi Chuck,

There is a plugin called - Procurement. We need to activate that to get this Scheduled Job

Jaspal Singh · ‎07-11-2018

Hi,

Not sure if you are expecting to help you understand entire script. If so, I don't think it is that complicated as it has necessary comments added at each step. Also, it runs daily 1:00 PDT time.

In short, script checks for Stock rule (alm_stock_rule) table to look if it has some rules set up in accordance with Restocking option as Vendor or Stock room & then runs appropriate function accordingly. Which then creates a task in (task) table & assigns it to Stockroom manager (set if any).

Thanks,

Jaspal Singh

Hit Helpful or Correct on the impact of response.

SNOW User8 · ‎07-11-2018

I want to know about
threshold & Order Size

& based on these parameter how system executing the Scheduled Job