Inventory db question

[7 of 9]

I have a simple form which allows me to keep an running
inventory of a specific item.
beginning inventory 200
items received 100
total available 300
total sold 50
ending inventory 250
each time I open the form, I would like the previous
[ending inventory value](250) to become my new [beginning
inventory].
If anyone could help me I would greatly appreciate it!

 

[Allen Browne]

There's no one-size-fits-all answer to the question of how to manage
inventory, because there are so many quirky aspects, e.g.:
- Stuff that has expiry dates.
- Managing FIFO (first-in, first-out).
- Tracking items by serial number.
- Managing losses/damages.
and so on.

For an introduction, see:
Inventory Control - Quantity On Hand
at:
http://members.iinet.net.au/~allenbrowne/AppInventory.html