Odoo apps are well integrated. Products datas are shared accros modules, and the accounting module can « talk » very well with the inventory one. Doing everything in Odoo is easy. But sometimes you need just a spreadsheet with your past inventory at a precise date. That functionality is a bit hidden. Here’s how to enable it :
- install the Accounting module
- enable multi-location inventory
- switch to developper mode to see hidden menus
- go to Inventory / Reports / Aging inventory
To export :
Quickly done
… but product name, stock and stock value only
- on the right of the list view, click on Tableau Croisé dynamique
- now click on the download icon (xls file)
Complete nightmare
… but you may be able to export every needed field
- from list view unfold all products, check the checkbox
- click on Action / Export
- click on all available fields
- choose your fields, don’t forget inventory moves, quants and associated dates
- export
- try to play with your spreadsheet
- go to Quickly done