Frappe Cloud Support Partners Foundation

Report to see Items having qty below safety stock

I try to find report mentioning items having quantity below safety stock.
The client do not want to enable auto reordering, they just wants to see the report (they want to have more control on the material request creation, like mentioning User Name and Deparrtment , doc.status, the time of creation/ they sometime need to create the request immediately after the stock down below safety stock not the next day)

I try to simulate the situation, setting the safety stock below the actual qty.
Anybody knows what is the report to see the items having low qty in stock ?

I have try Item Shortage Report but it says ‘Nothing to show’.
When I check this report, I notice it check for projected qty. It is not the one to see ?

I realize I can create a simple query report to do this ( maybe duplicating item shortage report and modify a bit in the sql ), but is there something that already build for it ?

Best Regards,


1 Like

Hi Aditya,

Did you find a solution to this use case, I have been looking for the same but havent found anything useful as yet?

Any suggestions, anybody?


Hi Amit Sharma,

At the time I just made a simple query report to see item < safety stock, but I think my question not valid since safety stock is not what I thought it was. Its just a qty to be added when we order an Item ( base on some calculation I think).

It should be “Item below reorder level” since reorder level is the qty level where we will order an item.

I am looking for a way to set this reorder level and get a notification without automatic creation of item request but have not find yet.

Best Regards,

1 Like

hello team…

i too have the same requirement …Did you find a solution to this use case, I have been looking for the same but haven’t found anything useful as yet?

please tell me if you find a way for it

Thanks and Regards