OdooWiki OCA HUB

Stock Kardex Report

stock_kardex_report folder_open OCA/stock-logistics-reporting open_in_new
Reports License: LGPL-3

This report shows the stock of a product in a specific location in a defined time period.

If I ask a report for Product A from 01-01-2020 to 03-01-2020 in location WH/Stock

The report will be the following

+-----------+---------------------+-----------------+----------+-------------+-----+---------+ | Product | Date | Description | Origin | Destination | Qty | Balance | +-----------+---------------------+-----------------+----------+-------------+-----+---------+ | Product A | 01-01-2020 12:00:00 | Initial Balance | | | 100 | 100 | +-----------+---------------------+-----------------+----------+-------------+-----+---------+ | Product A | 02-01-2020 12:00:00 | PO001 | Vendors | WH/Stock | 100 | 200 | +-----------+---------------------+-----------------+----------+-------------+-----+---------+ | Product A | 02-01-2020 14:00:00 | SO001 | WH/Stock | Customers | -50 | 150 | +-----------+---------------------+-----------------+----------+-------------+-----+---------+ | Product A | 02-01-2020 16:30:00 | SO002 | WH/Stock | Customers | -75 | 75 | +-----------+---------------------+-----------------+----------+-------------+-----+---------+ | Product A | 03-01-2020 12:00:00 | PO002 | Vendors | WH/Stock | 100 | 175 | +-----------+---------------------+-----------------+----------+-------------+-----+---------+

auto_awesome What this module does

AI-generated from the code · Odoo 12.0

Adds a Stock Kardex Report to Odoo that shows, for one product and one location over a chosen period, every stock movement with a running balance. Users open a small wizard, pick product, location and dates, and get a list starting with the initial balance.

This module adds a report that answers the question: how did the stock of one product in one location change between two dates?

Where it appears: under the Inventory reporting menu there is a new entry, Stock Kardex Report. It opens a small form (wizard) where the user must fill in the product, the location, a From date and a To date. Both dates default to the current date and time.

What happens when the user clicks the Retrieve Kardex Report button: - The system first calculates the opening balance: everything done into the location before the From date minus everything done out of it before that date. - It then collects all completed stock movements between the two dates that either leave from or arrive in the chosen location for the chosen product. - It builds a list ordered by date, starting with a line called Initial Balance, and shows for each movement the date, the origin document, the product, its unit of measure, the source and destination locations, the lot, the owner, the package, the quantity and the running balance. - Quantities going out of the selected location are shown as negative, so the balance decreases correctly. - Long origin references are shortened for readability.

Results are shown in a read-only list. Each time the report is run, the previous result lines are deleted and replaced, so only the latest report is kept. Access is granted to standard inventory users.

Depends on

stock

Menus it adds

Stock Kardex Report
Models and fields (2)
  • stock.kardex.report · new modeldate, lot_id, origin, balance, move_id, owner_id, qty_done (Done), package_id, product_id, location_id, product_uom_id, location_dest_id
  • stock.kardex.report.wiz · new modeldate_to (To), product, location, date_from (From)

Text generated by AI (DeepSeek) from reading the Odoo 12.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 1 confirmed, 8 with no information of 9 versions.

Sources · Odoo 12.0

Confirmed on 2026-11-03 in branch 12.0 of OCA/stock-logistics-reporting.

terminal Installation and usage

OCA documentation · Odoo 12.0

To get the stock kardex report:

  • Go to Inventory/Reports/Stock Kardex Report
  • A wizard will open; select the product, location and date range to generate the report.
  • Click on Retrieve Kardex Report button.

No verified information in OCA: Installation, Configuration.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.