Skip to Content
Menú
This question has been flagged

Dear All,

For inventory valuation, we have a large dataset. To manage the required information, we switched to pivot view and inserted the data into a spreadsheet. Currently, we are using spreadsheets saved under documents. However, we have noticed some discrepancies in the totals.

Odoo is providing one total value, but when we use the Sum formula for the same column, the totals do not match.

Turn on Debug

Go to Inventory -->Reporting-->Valuation

Group By “Product”

Insert to Spreadsheet

Download spread to local

The following is the total I got from the Odoo

I just doing manual sum

Please let me know why this difference, if I export all the information from tree view the sum is matching with Odoo Total.

Is there any issue in spreadsheet.!


We have not made any customizations in valuation or the spreadsheet.

Avatar
Descartar
Best Answer

Hi,

If you're having trouble summing amounts in your downloaded Excel file, it might be because some cells in the amount column are formatted as text instead of numbers. To fix this, follow these steps:


1.  Select all the cells in the amount column.

2.  Change the format to "Number" (you can usually find this option by right-clicking on the selected cells and choosing "Format Cells").

3.  Now you can use the SUM function to calculate the total amount!

Hope this helps!

Avatar
Descartar
Autor

Please download and check

Related Posts Respostes Vistes Activitat
4
de juny 24
4973
2
de juny 24
4139
0
de maig 23
2144
2
d’abr. 23
3420
1
de maig 21
3470