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.