Currency conversion rate is 0 for default currency

Using my Dolibarr
1

Hi

We have U.P. (net) and U.P (currency) against products while adding them in order card. We undestand that U.P (currency) = U.P (net) * (currency conversion rate). Please confirm

If we create an order with a currency apart from the default currency, the values against U.P (currency) is displayed correctly

But if we create an order with the default currency, the values against U.P (currency) is displayed as zero.This is because the currency conversion rate against default currency is shown as ‘Currency conversion rate 0 (0 USD = 1 USD)’

Please find below reference screen shots. Please suggest how can we correct this (like1 USD = 1 USD)

ref-06122018.png
ref-06122018.png1238×548 14.7 KB

Thanks

2

Hello

You failed to specifiy which version you are using so it is likely nobody will respond to you.

However, on v8.0.3, this seems to be fixed (I think) https://github.com/Dolibarr/dolibarr/commit/824b572bd07910c4b2ea938b4d936f530ad28881

3

Thanks for your reply. I am using the version 7.0.3

If I insert a record into ‘multicurrency_rate’ table this is working fine.
Query: INSERT INTO .xxx_multicurrency_rate (rowid, date_sync, rate, fk_multicurrency, entity) VALUES (NULL, now(), ‘1’, ‘1’, ‘1’);

Please suggest if this is correct

4

What about this? https://github.com/Dolibarr/dolibarr/pull/8904

5

Ok, I will use this to fetch currency rates

About this issue ‘Currency conversion rate is 0 for default currency’: From your reply I undestand that this is fixed in version 8.0.3.

Please suggest how can we fix this in version 7.0.3 (like is there a patch or details of the files to be modified)

Thanks

6

This shows you the changes but be careful and make a backup of the original files