we have two company with two different currency the first one is in OMR and second one is in AED. 1 OMR=9.5 AED
if i check mark both company it should be show us both company sale report based on selected company currency but it wont.
example:
in AED company we have sold 365000 AED and in OMR company we have sold 10000 OMR if we check mark both company and select OMR company it should be show us 10000+(365000/9.5)=48421 OMR but it showing 10000+365000=375000 OMR which is not correct.
and based on AED company must be show us 365000+(10000*9.5)=460000 AED but it showing 365000+10000=375000 AED and again is not correct. in another word Odoo will show Sum of both sale sales order without considering the currency rate. in accounting and purchase we are able to have to report correctly and in my perspective it should be same in sale as well. i was wondering if somebody know how to solve the problem?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
In the current stage the multi-company-feature is giving you only the possibility to look at all companies simutaniously (what is, in deed, a certain kind of advantage). But currency translation is not part of that. If you look at the ODOO-consolidation-system you are going to understand why: ODOO is not even able to deal with correct currency-translation mechanics in that tool (which is doing nothing else).
But it shows also, that this topic is not that easy: you have to define 1. which currency fields to convert (you have net amount, tax, amount, gross amount, untaxed amount invoiced ....), 2. do you want to have it 100% flexible (like
sales@gyeongcc.com described above) or is it enough to have one group currency), 3. which rates should be considered (average rates, transaction rates (some countries use only one rate per month), so if you have two Sales Orders with different dates and want to look at the total, how should translation work)?
I think it is not that easy (nobody said it will be easy). But if you have some ideas, let me know, I agree it could be a real benefit, and I could discuss with developers...
Florian, thank you for your statement. I understand that things may be more complex. Then maybe a sales report on multiple companies should be blocked or at least warned against. If one has clients whose currency rates differ only slightly, the result is erroneous - and one may not even notice it! I also only noticed it because we have a client in Indonesian Rupiah (with a crazy conversion rate to the Euro) and our group sales suddenly amounted to hundreds of millions of Euros (!). That would be a reason to celebrate in January already, unfortunately the joy was short...
For sure, I was also confused many times. To sum up different currencies just makes no sense at all :-)
Dear Florian
with respect all you have mentioned about difficulties is correct, but what is difference between purchase and sales? all those difficulties are same in purchase isn't it? in purchase Odoo will convert the amount based on latest currency rate and for me its enough at least I have an idea about our reports.
Did you enable multi company option for the user?
of course
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
1
Aug 25
|
3027 | ||
|
2
Oct 23
|
3567 | ||
|
2
Dec 23
|
4162 | ||
|
1
Oct 23
|
8767 | ||
|
0
Aug 23
|
2246 |
I asked the exact same question here a few days ago with no one to answer. I think this is a huge problem in a multicompany environment. In this respect, it can't really be that no one has noticed or solved this yet. I don't give up hope...
It mustn’t be very hard to solve because in purchase there isn’t problem but unfortunately even in Odoo it self most of support team they don’t have enough knowledge. i have send a ticket to them and the answer is very really funny “this is the odoo standard”
Now question is what Does meaning of multi company and ERP?
this means nothing less than that Odoo has a significant limitation in the multi-company area. It's really maddening: Odoo can do so many complex things - and keeps failing at very simple ones. SAP is already trembling with fear...
Dear friends of Odoo S.A., could it be that the success of the last few years has gone a little to your head and that you therefore no longer need to worry about such "insignificant" details? There is a German proverb: "Pride comes before a fall".