Inventory management project

I need a sheet or set of sheets to control our inventory. sheets would include a data base of our hard goods, a BOM data base of material needed for all of our SKUs. A form to input PO data, a way to convert it to received when items are received. all connected together to give as live data as possible.