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 ?