Our Maintenance Manager wants to track material shortages in the storeroom for unplanned maintenance orders. If a maintenance craftsman goes to get a part from the storeroom for an unplanned order, and that material is out of stock, how do you track that? They currently track this using an Excel spreadsheet.
He wants to run a report that shows Material; # needed, # in stock; # out of stock, date, etc
This will enable the storeroom to adjust re-order points in the future.