The Inventory of a Firm should be Open within an Organization. Searching with a browser, Integrateable with departmental webware/intranet. With a very easy readable non-programmer friendly API.
The Search must be based on Multiple Keywords, Filters or Tags. Dormant Inventory and Parts/Equipment/Furniture not on any live project anymore, Excess Inventory and Obsoleted Parts due to Tech Advancement; should be flagged. This enables other departments to use it, consume it for Maintenance or Research projects or integrate into new designs if not-obsolete.
If found to be valueless, damaged or worn-out by all departments and responsible engineers, then inventory should be sold or given away. The Employees can be the first customers for an inhouse Corporate Garage Sale. An un-organized, complexly-computerized and non-transparent/blocked Stores will end up in a Flea Market.