Having asked a question about a simple inventory system in Access I was offered the following
1. A item Master table
2. A Inventory Movement table (your Inventory Transactions/Ledger table). This records all the in's and out's of inventory and why it was done.
3. A lot tracking table. This is the actual on-hand qty's.
I would like to find out more about this sort of approach.