I manage a small company's warehouse and I have been tracking everything on paper. I have recently been given the go-ahead to purchase an inventory tracking software with no price cap. Which is best?

We keep track of each part that comes in by lot number and receive date (receive date is optional), each part then is put into an assembly that is given a serial number. We want to be able to track by serial number all the parts that went into an assembly and which lot they came from, and vice versa - by entering a lot number for a part, we want to be able to track which serial number each part went into. We have to have traceability for every part, backwards and forwards, because we make Class 1 medical devices and are getting ISO certified.

Am I asking too much? I tried Wasp Inventory Control but it just deducts parts from the total amount.

HELP!

Thank you in advance