Hi - I’m interested in this also - did you find a solution?

Hi @gianni.neves and @ChrisKnight ,

I know if you use MRP that an MRP message will appear in the action proposals telling you the Available Quantity < Safety Stock.  Your buyers would see this message in their MRP Action Proposals  Workbench.   

Another option would be to create a custom event that trigger on perhaps inventory transaction history when inventory reduced.  You could retrieve the total available inventory for the part and retrieve the safety stock and perform a check in the event action to so an email is sent when the available is less than safety stock.  

We have a trigger on the transaction history when a new entry is added.  The event action only fires when the SOURCE_REF_TYPE=PUR ORDER and TRANSACTION_CODE = ARRIVAL.

Regards,

William

Hi ​@gianni.neves and ​@ChrisKnight,

what about using SAFETY_STOCK from INVENTORY_PART_PLANNING_TAB (short IPP→ joined with IP via CONTRACT and PART_NO) and the fields from INVENTORY_PART_IN_STOCK (short IPIS)?
There ist QTY_ONHAND, QTY_RESERVED and QTY_IN_TRANSIT.
The Warehouse Management > Quantity in Stock > Inventory Part in Stock - mask shows these fields and also a “combi” field “Available Qty” = QTY_ONHAND - QTY_RESERVED.
The System Info shows the View &AO.INVENTORY_PART_IN_STOCK_UIV which goes down to INVENTORY_PART_IN_STOCK_TAB. 

So use “PartKey” CONTRACT+PART_NO to group your IPIS (IPAC if necessary) by part.
Join that to your “DIM_Part” and compare SafetyStock with AvailableQty. 
But what about PurchaseLeadTime and your “horizon”?

Last week we developed a solution for “ToolManagement”.
The company use a lot of drills, milling cutters and other tools to handle metals. 

So we took “OrderEntry” from CustomerOrderLines and CustomerScheduleLines (because they use the ASC module) and calculate the need for tools the next 6 months. 
The outcome is SafetyStock compared with a new field SafetyStockCalc.
Then you can see: 
A) my SafetyStock is to low (danger of production shutdown because of lack of tools) 
or
B) to high. (could result in problems with warehouse resources + tied-up capital to high) 

No problem to use that solution for calculation of any SafetyStock of all IPs.
It will also show candidates with no SafetyStock!

HTH
BR
Michael