Every movement, on one ledger.
A perpetual, append-only stock ledger — every quantity and value movement across twenty movement types, with running on-hand and running value on every row, and FIFO / AVCO / Standard valuation. In production. On Leysco Akili, the ledger is INSERT-only, enforced at the persistence layer, in early access.
code-inventory
reconciliation
company-books
Perpetual inventory ledger & valuation
SAP B1 inventory · NetSuite · Fishbowl · Odoo Inventory
A perpetual ledger that carries running on-hand and running value on every row across twenty movement types — the stock position and its valuation are one append-only record, not a report reconstructed at month-end. code-inventory
| MOVEMENT | QTY | ON-HAND | VALUE (KES) |
|---|---|---|---|
| Opening | — | 200 | 96,000 |
| GRN-4471 | +120 | 320 | 158,400 |
| Issue-8890 | −80 | 240 | 118,800 |
| append-only | 20 types | → 240 on hand | → 118,800 |
Every movement, one row.
Live · the ledgerEvery receipt, issue, transfer and adjustment posts as one row across twenty movement types, and each row carries the running on-hand quantity and the running value after it. The stock position is never computed after the fact — it is on the ledger. code-inventory
| METHOD | ON-HAND | VALUE (KES) |
|---|---|---|
| FIFO | 240 | 120,000 |
| AVCO | 240 | 118,800 |
| Standard | 240 | 115,200 |
| same 240 units | 3 methods | 3 values |
One position, three methods.
Live · valuationThe same on-hand position values three ways — FIFO, AVCO and Standard — off the same ledger, so the balance sheet and the stock count never argue. Pick the method; the ledger already carries the layers. code-inventory
reject UPDATE a posted row at the persistence layer
reject DELETE a posted row at the persistence layer
assert running balance holds enforced, not by convention
It cannot be rewritten.
Early access · Leysco AkiliOn Leysco Akili, the stock ledger is INSERT-only — enforced at the persistence layer, not by convention — so a posted movement can never be updated or deleted, and the running balance is asserted to hold. Immutability by construction, in early access. code-inventory
Everything in the inventory line.
In this line| Item / Product Master (PIM-light) | Live | Items, variants, units of measure, attributes. |
| Perpetual Stock Ledger + Valuation | Live | This page — append-only ledger, running value, FIFO/AVCO/STD. |
| Goods Receipt / Goods Issue | Live | Every in and out movement, posted. |
| Inter-warehouse Transfers | Live | Stock moved between warehouses, in transit. |
| Physical & Cycle Counting | Live | Counts and reconciliation to book. |
| Lot/Batch + Serial Traceability | Live | FEFO lots, expiry, unit serials. |
| Bin / Location Management | Live | Bin and location addressing. |
| Reorder / Shortfall Alerts | Live | Shortfall and back-in-stock signals. |
| Stock Inquiry, Audit & Analytics | Live | On-hand, valuation, chronological ledger. |
| Stock Reservations & ATP | Early access | Reserve stock and available-to-promise — early. |
| Kitting / Assembly | Designed | Kit and assembly builds — designed. |
| Quality-Inspection Hold | Designed | Quarantine and QI hold — designed. |
A ledger that only grows — and recomputes on every row.
Signature · A ledger only growsThe stock ledger is append-only: every receipt, issue and adjustment posts as one row across twenty movement types, and each row carries the running on-hand and running value after it — recomputed as the row lands, never reconstructed at month-end. This perpetual ledger and its valuation are live in production. code-inventory
reconciliation
The stock ledger runs in the same house that posts 1.66M+ distribution invoices in production — every movement, its running quantity and its running value on one append-only record, so the warehouse and the balance sheet read from the same rows.
The perpetual ledger and its FIFO/AVCO/Standard valuation are in production. On Leysco Akili, the ledger is INSERT-only, enforced at the persistence layer, in early access. We chip each as it is.
- carry running on-hand and running value on every stock movement
- value the same position three ways off one ledger, not three reports
- post twenty movement types to one append-only record
- explore a persistence-enforced immutable ledger on Leysco Akili early access
A stock report and a valuation report that never quite tie out → one append-only ledger — quantity and value on every row
Part of the house.
RelatedTraceability
Lot, batch and serial trace on the same ledger.
LiveInventory
Where the movements are posted.
LiveFinance & Banking
Where the stock value hits the ledger.
LiveThe house has worked SAP Business One since 2017. company-books