Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Invoice analysis report more than doubling actual invoice values

By
Dale
on 11/20/15, 1:05 AM 514 views

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   

0
Dale
On 11/22/15, 1:54 PM

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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 11/20/15, 1:05 AM
Seen: 514 times
Last updated: 11/22/15, 1:54 PM