Stock that can't go below zero.And a reason for every move.
Receipts, deliveries and count adjustments, each one a stock move at average cost that names the document behind it.
Where agent stock-keeping goes wrong.
01
Negative stock
A system that lets stock fall below zero reports a number nobody can act on.
02
Counts nobody can explain
On-hand changes with no document behind it, and nobody can say why there are 53.
03
Value that drifts
Quantity and value updated separately stop agreeing with the books.
Scenarios
Questions a warehouse lead can answer.
How OpenERP answers
The delivery is refused with both numbers, and nothing moves. The agent shipped 53 and left 7 on the order.
How OpenERP answers
Every move names its document. Two were written off after a count, with the reason, and their $36.00 cost went to operating expenses.
How OpenERP answers
Yes. Every move shifts quantity and value in one statement, and the test suite checks that stock valuation equals the Inventory account.
What changes.
- No negative stockDeliveries and write-offs stop at what's on hand.
- A document behind every moveReceipt, delivery or adjustment, each with its cost.
- Value that matches the ledgerStock valuation equals the Inventory account.
- Average cost, kept for youEach receipt updates the item's average cost.
Controls.
Three-way match
A bill posts only if price and quantity agree with the order and the receipts.
Stock floor
A delivery or write-off larger than what's on hand is refused.
Balanced postings
Every document posts a journal entry whose debits equal its credits.
Reversals, not edits
A posted entry never changes. reverse_entry adds a contra entry.
Audit log
Every change writes an audit row in the same transaction.
Self-hosted
One SQLite file on infrastructure you control.
Questions.
Does it support FIFO?
Not yet. Costing is average cost only. FIFO is planned for v0.3.
Can it handle more than one warehouse?
Yes. Stock is tracked per warehouse, and the seed creates two. There's no transfer tool between warehouses in v0.1.
Does it track serial numbers or batches?
No. v0.1 tracks quantity per item and warehouse.
Let your agents run purchasing and stock.Keep the rules on the server.
Run OpenERP on a sample business in minutes, or have Attri deploy it inside your environment with access control and approval rules.