Skip to Content

Contributors

Stock quant history

Dear contributors,

Using odoo 14.0, we would like to consult physical stock in the past dateĀ  for analysis and reporting. Consulting those stock should let userĀ  to group and/or filter by product/location/lot information.

Odoo's stock module provide Inventory Report (which displays current stock: `stock.quant`s at now()) where users are able to click on the `Inventory at Date` button which redirect users to product view with selected date in context to re-compute quantities at that time without able to filter by lot.

I've seen `stock_quantity_history_location` and `stock_report_quantity_by_location` in OCA/stock-logistics-reporting repo but don't fit our needs.

Ideally we would like to recreate stock.quant for a given date according to a possible set of criteria set by the users (restricted by locations / lot / product).

Does anyone work on something like this on any odoo version? Does it make sense to suggest a new module `stock_quant_history like this in the OCA/stock-logistics-reporting repo? Any suggestions/advice you'll like to share are welcome!

Regards,

--
Pierre Verkest
06 81 12 25 20
Github: petrus-v - Linkedin: pierre-verkest

by Pierre Verkest - 02:20 - 3 Apr 2024