Skip to Content
This question has been flagged
invoicereportsformulacalculation
1 Reply
3598 Views
Avatar
Dale

Hi

I have a strange issue on my hands. There seems to be a problem in all my reports that contain invoice values, as well as the button on the kanban record that indicates invoices. The values are all more than double that of the actual invoice value. I have rin the Invoice Analysis report and when compared to the actual invoices there isn't one that is a match. I have no modified any reports manually, they are all standard


What can be the problem? This makes Odoo unusable as we cannot give feedback to the boss on sales


Hope someone can help


Thanks   

Avatar
Discard
Avatar
Dale
Author Best Answer

Hi All


I found the solution for this. I am not quite clear on the theory but it seems to have had to do with the base currency. My main currency is ZAR. The reports seem to have been working out the values based on a calculation of the main currency to some other currency. I had to change the main currency ZAR to a current rate of 1.0 (this meant that the invoices going forward were correct in the report) then I had to change the previously recorded rate to another value (in my case 24.66054) which forced the existing values to match the actual invoice values


Hope that someone else finds this useful

Avatar
Discard
Related Posts Replies Views Activity
Invoice pdf report from API endpoint is not getting
invoice reports
Avatar
Avatar
1
Sep 24
343
How to change the report type from pdf to html in code Solved
invoice reports
Avatar
Avatar
Avatar
Avatar
8
Feb 19
9151
Customer Details on the left Solved
invoice reports v17
Avatar
Avatar
2
Apr 24
512
Odoo 16. Report same report has two different faces.
invoice reports odoo16features
Avatar
Avatar
1
Dec 23
538
Strip string from a field with defined separator in invoice report
invoice custom reports
Avatar
0
Mar 22
2