Inventory

Track material using append-only transactions + derived balances.

Append View (Source of Truth)

This view is computed from transactions (append-only log).

⚠️ This is a working model — automatic syncing to the current inventory table is not implemented yet.

For now, this is used to validate the new workflow before replacing the existing system.

Every change = a new transaction (add, remove, adjust)
No overwriting values → prevents mistakes + preserves history
This is the “real” inventory state