MODULES / OPERATIONS
Stock Ledger Report
Detailed and summary stock ledgers with product/category filters, opening balances and PDF/XLSX exports.
Overview
| Module id | ask_stock_ledger |
|---|---|
| Version | 1.0.0 |
| Who uses it | Anyone who uses the screens listed below. |
| Installed | On demand, from Settings → Modules. Anything it needs is installed with it. |
Where to find it
| Reports / Inventory | Stock ledger |
|---|
The menu entries appear once the module is installed and your role allows them.
How it links to other modules
- Needs: Inventory
- Works better with: no other module in particular
- Needed by: no other module
A module that is needed cannot be turned off while the module that needs it is on.
Details
Stock ledger report
Port of D:/Odoo18/sparkosol/custom-addons.odoo18/ask_stock_ledger. Install Stock Ledger Report from Settings > Modules, then open Reports > Stock ledger (/reports/stock-ledger). Inventory is a dependency.
Includes detailed and summary modes, inclusive date ranges, multiple products, hierarchical category filtering, opening/in/out/closing quantities, optional inventory values, source-document links and PDF/XLSX exports. All exports use the same definition and filters as the screen. Explicit products override category; unselected zero-activity products are omitted, explicitly selected ones remain. Archived products with history remain reportable. Quantities are in each product's reference UOM; totals across incompatible UOMs are not added together.
ASKERP adaptations: quantities retain six-decimal precision instead of the source's whole-unit rounding. Posted Stock (1300) journal items provide historical values, including AVCO issues, instead of multiplying all history by today's standard cost. Internal transfers have no company-wide quantity/value effect and are omitted. Manufacturing movements cross the internal boundary and count; WIP value is not included in stock. Partner names are shown where the movement is linked to a sales delivery, purchase receipt or credit-note return. Standalone movements have no inferred partner. There are no stored report balances or transient report tables.
Service and export access require module installation and Inventory entitlement. RLS scopes all rows to the active company. Disable/reinstall preserves inventory. No schema migration or stock posting change is required.
Tests: npx vitest run addons/ask_stock_ledger/addon.test.ts server/reports/registry.test.ts. Browser check against a running local app: node --env-file=.env --import tsx scripts/stock-ledger-smoke.ts (E2E_BASE_URL overrides port 3000).