| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Discuss (mail) |
| Lines of code | 1903 |
| Technical Name |
aos_stock_card_report |
| License | OPL-1 |
| Website | http://www.alphasoft.co.id |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Discuss (mail) |
| Lines of code | 1903 |
| Technical Name |
aos_stock_card_report |
| License | OPL-1 |
| Website | http://www.alphasoft.co.id |
Stock card per product, with moving average cost.
A dynamic dashboard that replays every stock valuation layer into a running ledger — opening balance, every IN / OUT / adjustment / internal / manufacturing / return, and running stock qty + inventory value + average cost recomputed Odoo's AVCO way. Plus a one-click Xlsx export.
Every movement is colour-coded so the eye can scan ledger rows at a glance.
What You Get
📋 Opening balance + every movementEach ledger opens with the cumulative balance (qty & value) before the period, then lists every movement — IN, DO, Adjustment, Internal, Manufacturing, vendor/customer returns. |
📈 Moving average cost (AVCO)Running Stock Qty, Inventory Value, and Average Cost are recomputed on every row — exactly the way Odoo computes AVCO internally. |
🔍 Group & filterGroup by Product, Product × Warehouse, or Product × Location — each group keeps its own independent ledger. Filter pills with quick date ranges; filters auto-save per user. |
📊 KPI tiles + Top-10 chartSix always-visible tiles — group count, movement count, total opening, IN, OUT, ending inventory — and a Top-10 bar+line chart of value IN / OUT / ending. |
🔗 Clickable drill-downEvery row links straight to the journal entry, picking, and product form — no copy-paste to reconcile cost movements against accounting. |
💾 Xlsx export & cost privacyStyled workbook with group header + per-group totals. Cost columns (Debit, Credit, Inventory, Average) can be gated to a cost-editor group — quantities stay visible to everyone else. |
See It In Action
Three views — summary tiles, per-product ledgers, and the Top-10 chart.
🔢 Summary tiles + first ledger
Six KPI tiles (# Group, # Movement, Total Opening, Total IN, Total OUT, Ending Inventory) sit above the first product ledger — AVCO badge, every movement row, running Stock Qty / Inventory / Average on the right.
📄 One ledger per group, with PERIOD TOTAL
Every product (or product × warehouse / product × location) gets its own block — closing balance, inventory value, average cost in the title row; PERIOD TOTAL footer rolls IN / OUT / Debit / Credit / Balance / Qty / Inventory / Average for the period.
📈 Top-10 Group chart
Click Show Charts for a Top-10 bar+line view — green bars for Value IN, red for Value OUT, blue line for Ending Inventory. Hide zero-ending filters out groups with no remaining stock. Useful for board packs and management reviews.
How It Works
1 |
Open Inventory › Reporting › Stock Card, pick a date range (or use one of the quick ranges — This Month, YTD, Last Month). |
2 |
Pick a grouping — By Product is the standard stock card; switch to By Product × Warehouse or By Product × Location when stock differs across sites. |
3 |
Narrow with Products / Categories / Warehouses / Locations pills + the search box. Optionally toggle Show Charts. |
4 |
Click Xlsx to download the same data as a styled workbook — one sheet per run with group headers and per-group totals. |
ⓘ A note on costing methods
The ledger replays Odoo's own stock valuation layers, so the running quantity, inventory value, and average cost match the figures Odoo posts to the stock-valuation account. AVCO products show a continuously updated average cost; FIFO and Standard products show the unit cost Odoo recorded on each layer. Cost privacy is enforced at the JS layer — non-cost-editor users see quantities only.
Compatibility
Odoo 18.0 — Community & Enterprise •
Depends only on stock_account •
Xlsx export needs the xlsxwriter Python package
Built by Alphasoft
We build practical Odoo modules for real Indonesian businesses — accounting, inventory, and reporting that fit how teams actually work.
www.alphasoft.co.id
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module