Hello @jpatrick,
From a UI perspective it definitely looks achievable but this will only really cover the IN and OUT of items. You can setup your products as Data Elements (DE) and hard code the unit of measure then set the received quantity and issued quantity as CatCombos.
However, this will not cover your need to calculate the expiry date and quantity. I’m sure you can run an SQL query to calculate the dates but you won’t be able to display it on the form or pivot table.
Copying @Scott here as he’s been working on this type of use case.
John