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

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

Odoo Inventory Valuation Report

inventory

3 Odpowiedzi

7463 Widoki

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

Autor

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

Autor

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

Autor

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.

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
How to print all product labels at once, including quantities in stock? inventory	2 gru 25	352
Odoo Inventory - Reference warehouse visit Netherlands - >1000 orders per day inventory	1 lis 25	260
Inventory rotation or inventory turnover inventory	1 paź 25	1804
Lot/Serial Number Rozwiązane inventory	2 wrz 25	1026
track inventory history inventory	1 sie 25	1815

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!