Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Akuntansi
Inventaris
PoS
Project
MRP

All apps

Semua Post Orang Lencana-Lencana

Label (Lihat semua)

odoo accounting v14 pos v15

Mengenai forum ini

Help

Odoo Inventory Valuation Report

inventory

3 Replies

7455 Tampilan

Marcio Valenzuela

Im in the Inventory Module in v11 CE and I can see the option Reporting>Inventory Valuation which gives me a list of subcategories with the products inside. When I open a subcategory it displays the individual products in that category, their quantity and stock valuation. What I want is to export this to excel with each product subcategory expanded and each product with their valuation. But in order to do this I have to checkmark each product's checkbox in order for it to be exported to excel.

I have quite a few categories and over 4000 products.

Is there an easier way to do this?

Moaaz Gafar

https://apps.odoo.com/apps/modules/17.0/advance_stock_valuation_report

Muhammad Saeed SherKhan (Metasoftec)

Why inventory Valuation does not Create in odoo Three Reason

https://youtu.be/9d9Z_7uOC6c

Paresh Wagh

Hi Marcio:

You can remove the Group By category criteria from the search filter and then select the checkbox in the Title row to select all the products.

EDIT:

Go to Inventory > Reporting > Inventory Valuation. Clear out the filters in the Search box and then select the checkbox in the Title row to select all the products.

Select Action > Export to export the data. You will get the popup shown below to select the fields to be exported.

Select the following options:

Export Type: Export all Data

Export Formats: Excel

To select the name/description of a field, select the + sign to expand the field in the list of Available fields and select the attribute of the field that you want to export. For example, to select Internal Category/Complete Name, select the + sign to the left of the Internal Category field, scroll down and select Internal Category/Complete Name and click on Add to add it to the list of Fields to Export on the right.

Now when you export the data, you will get the descriptive names in the Excel file.

Marcio Valenzuela

Penulis

Yes but I still need them grouped but with stock valuation at the individual and grouped level

Paresh Wagh

When you Export the data make sure the Category field is also selected in addition to all the other data that you need. Once you get the data in Excel, you can run Pivot reports on the data for the grouped level valuation.

Marcio Valenzuela

Penulis

How do I customize the view so that it shows the Category Column?

Paresh Wagh

You don't need to customize the view if you are exporting data. At the time of export, you have the option of selecting the fields that you want to export. Make sure that the Category field is one of the selected fields.

Marcio Valenzuela

Penulis

The native export feature only references ID field values for category and does not have the field for stock valuation. Iow, I get product_id & categ_id/id key reference values, not the actual product & category names. It also doesnt have a stock valuation field as the view does. The excel export function will export the list view but that list view doesnt have the categrory column.

Paresh Wagh

I have edited my earlier answer and added an example with detailed steps.

Menikmati diskusi? Jangan hanya membaca, ikuti!

Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!

Daftar

Post Terkait	Replies	Tampilan
How to print all product labels at once, including quantities in stock? inventory	2 Des 25	338
Odoo Inventory - Reference warehouse visit Netherlands - >1000 orders per day inventory	1 Nov 25	252
Inventory rotation or inventory turnover inventory	1 Okt 25	1799
Lot/Serial Number Diselesaikan inventory	2 Sep 25	1019
track inventory history inventory	1 Agu 25	1815

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!