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.