I used SAGE, but this might be a bit over the top for purely Stock/ Inventory Control as it does this and Finance stuff too.
Whatever you end up using you'd be wise to control all tooling and or stock using issue numbers as well as discrete drawing numbers- ie if you buy 100 M5 Screws asign it a discrete Stock number AND an issue number- things change like designs so if you have 100 off at issue 001 in stock and 100 off at issue 002 (say due to a material change) you can issue the correct part to the shop. Same with manufactured parts- control them using a discrete drawing/ stock number AND an issue number.
Also- make sure the description field is searchable- it's no use having just "M6 screw"- better to have "Screw, Cap Head, M6 X 12mm passivated".
Might seem over the top, but we were doing this for military stuff which needs full traceability. A record of the Purchase Order/ Works Order number should accompany the part in stores- this gives you traceability to incomming Certificate of Conformities.
That's a big job you're taking on! good luck man!