Skip to main content

Inventory

Why stock should be a ledger, not a number

If you can type a new quantity into a box, your stock figure is an opinion. If every change comes from a document, it is a fact.

Stock quantity built from a stack of movement documents

· 5 min read · By Proaqsa ERP

The problem with editable quantities

Stock on hand should be the sum of movements — purchases in, sales out, returns, transfers — each tied to a document. When software lets you overwrite the quantity directly, the number loses its history, and the next count becomes the only truth.

Every shop has seen it: the system says 40, the shelf says 32, and nobody can say which eight sales were never posted. Editable quantities hide the problem instead of surfacing it.

Movement-based inventory

In Proaqsa ERP, inventory is a movement ledger. A posted purchase writes a stock-in movement for its location; a posted sale writes a stock-out; a return reverses; a revision reverses and re-posts. On-hand quantity per item and location is derived, never typed.

  • Movements carry the source document, unit cost, batch and expiry.
  • Packaging conversions are stored on the line, so a carton sold is twelve pieces moved.
  • Physical count differences are posted as adjustment documents with a reason — still a movement, still auditable.

What you gain

SituationEditable quantityMovement ledger
Count differs from systemOverwrite and forgetAdjustment with reason; the gap is visible in reports
Auditor asks "why 412?"No answerOpen the movement list
Cost of goods on P&LGuessFrom movement costs
Two branchesTwo numbers to editTwo locations, one ledger

See the inventory module and the glossary entry on stock movements.

Try it

Stock you can explain.

FAQ

Frequently asked questions

How do I fix stock after a physical count?

Post an adjustment document for the difference with a reason. The movement stays in history; reports show the shrinkage.

Does every sale really move stock?

Yes, in the same database transaction as the invoice, the receivable and the journal.