Skip to product information
1 of 60

Stock Movement Report Pro

Regular price €299,00
Regular price Sale price €299,00
Sold out

Stock Movement Report Pro

The stock movement ledger for Dolibarr: opening and closing balances product by product, balance at date, valuation, flows, signed period closing, reconciliation and Excel...

6 people are viewing this right now

View full product details

Stock Movement Report Pro

The stock movement ledger for Dolibarr: opening and closing balances product by product, balance at date, valuation, flows, signed period closing, reconciliation and Excel exports with live formulas

Features

The stock ledger, product by product
For every product: the opening balance, each movement with its running balance, total receipts, total issues and the closing balance. The opening balance is the exact sum of every movement before the first day, so opening + receipts − issues = closing is checked and shown on every report.
Every filter you need
Today, this or last month, quarter, this or last year, 30 or 90 days, or free dates; warehouses with or without their sub-warehouses; product categories with or without sub-categories; products; lot or serial number. Group by product, product and warehouse, category or lot, and save the view as a report.
An Excel file that recalculates
The running balance of each line is a formula, product totals are SUBTOTALs, the grand total a SUBTOTAL of the whole column, the closing a SUM of the ending balances. Change a quantity in the workbook and everything follows. Coloured product cards, frozen title rows, auto-filter. PDF and CSV too.
Balance at any date, and its value
The stock of every product and warehouse at any date, replayed from the movements, valued at the weighted average cost, the last purchase price before that date or the price of each movement, with the gap to today's level. Freeze it as a dated snapshot.
Flows by family
Purchases, sales, production, transfers, inventories, returns, breakage: editable families and rules classify every movement the moment Dolibarr records it. A movement no rule recognises stays unclassified and listed — it is never forced into a family.
Closed periods stay closed
Monthly periods signed by the storekeeper, the logistics manager, the controller or management; closing freezes the balance. A movement dated in a closed period and recorded afterwards is caught at once — or refused, if you choose — and must be reviewed: justified, corrected or accepted.
The ledger checked against Dolibarr
For every product and warehouse, the sum of all movements is compared with the stock level Dolibarr keeps, and every gap gets its cause: level edited without a movement, stock with no movement behind it, deleted warehouse, rounding. Each gap is followed until corrected or accepted.
The life of every lot
Where a lot came from, the warehouses it went through, where it left to, its balance after each movement, what is left and its use-by date; lots in stock sorted by expiry.
Alerts that are raised once
Eight kinds of rules: negative stock, receipt without price, large adjustment (transfers are recognised and left out), dormant stock, late recording, reconciliation gap, below the alert threshold, expired lot. An alert is raised once; an ignored alert does not come back; a justification on the movement resolves it.
Reports sent on time, honestly
A saved report e-mailed every day, week, month, quarter or month-end, as Excel, PDF or CSV. When e-mail is off — in the module or in Dolibarr — the delivery is queued and never counted as sent. Every export is kept and downloads again byte for byte.
Dashboard, 52 reports, REST API
Nine watch tiles, stock level and value, the current month, twelve months of flows; 52 reports in eight families with chart, table and CSV; a Ledger button on Dolibarr's product and warehouse cards; warehouse groups; a 34-route REST API; five languages.
A demo a stock controller would believe
One click installs the stock of an industrial supplies distributor: 14 categories, a site with its sub-warehouses, 40 products, fourteen months of movements with lots used first-in first-out, transfers that always balance, production, inventories, returns and breakage — and only the gaps planted on purpose. One click removes exactly that, and nothing of yours.

What the module does not do

  • It never changes Dolibarr's movements or stock levels. It reads them; the only thing it may do to a movement is refuse it when it is dated in a closed period and you asked for that.
  • It does not correct gaps by itself. A reconciliation gap is explained and followed; the correction (a stock movement) remains a decision made in Dolibarr.
  • Valuation follows the cost Dolibarr keeps. Weighted average, last purchase price or movement price — no FIFO cost layers.
  • Lots are read from the movements. The module does not create lots and does not replace Dolibarr's lot / serial module.
  • E-mails go through Dolibarr's own mail settings. With e-mail disabled, deliveries are queued, not sent.

Putting it to work

  1. Activate the module: it creates its 27 tables, its data folders, its settings, 37 permissions and 7 scheduled jobs.
  2. Grant the permissions to your user groups.
  3. Optionally install the demo data from the module setup to discover it on a realistic stock.
  4. In Flows, review the families and rules, then click Reclassify everything once for your history.
  5. In the Ledger, pick a period and a scope; save your favourite views as reports.
  6. In Periods, create your monthly periods, have them signed and close them.
  7. Enable Dolibarr's Scheduled jobs module so classification, alerts, late entries, reconciliations, snapshots and deliveries run by themselves.

Technical summary

Module number 1740000
Dolibarr 16 and later (tested on 17.0.3)
PHP 7.1 and later (tested on 8.5)
Tables 27, prefix llx_stockmovementreport_
Permissions 37 in 15 groups
Menu 1 top entry, 50 left entries
Scheduled jobs 7
Reports 52 in 8 families
REST API 34 routes
Languages English, French, German, Italian, Spanish
Excel export native OOXML writer, live SUM / SUBTOTAL formulas
Tests 1 186 checks, no failure
Developed by DoliResource
Copyright © DoliResource
Website : www.doliresource.com