Incorrect calculation of product prices in invoices and quotes when using a currency other than the dollar

Hello :raised_hand:, community. I’m experiencing an issue with decimals when changing the currency using the currency selection dropdown in quotes and invoices. I would really appreciate your help in resolving this issue. Thank you in advance!

In the Currency module, create a new currency:

Currency Name: Colon
Conversion Rate: 526.2700000000

Then, create a product with this currency (COLON), and set the price to 410.00.

When I go to the Quotes module (this also happens in the Invoice module), I load the product, and with the currency dropdown set to COLON, it shows the correct value of 410.00. However, if I change the currency dropdown to another currency and then switch back to COLON, it calculates the price as 410.49.

When the currency in the quote or invoice is set to COLON by default, it loads correctly.

The decimals get messed up after switching to another currency and then switching back to COLON."

You tagged it with “suitecrm7” but it’s SuiteCRM 8 right?
Can you edit the tag?
And what’s the full Suite version number?

Hi Chris,
The label is correct in version 7. I apologize for not specifying the version earlier; it’s 7.14.5.

Does this issue happen when you do the same on the Suite 8 online demo? https://suite8demo.suiteondemand.com Login with User: will Pass: will

Those credentials belong to a regular user, so I don’t have permission to register a currency. However, I set up version 8.6.2 locally, which is the same as the DEMO version, and I recreated the scenario. The issue occurs exactly the same way.

Hello Hipolito,

I seem to be able to replicate it.
Here are my steps:

  1. Add a second currency - including a conversion rate
  2. Create a product in the added currency
  3. Create a quote
  4. Switch to the added currency
  5. Add the product
  6. Switch to USD
  7. Switch to the added currency - now I’ve got the wrong price as well.

I assume, now there are some JS calculations going on, instead of loading the product details from the product table again.
A workaround would be, to simly enter the product name and re-load the product. Then the price is correct.
Do you want to create a new bug ticket for that?

Hello BastianHammer, thank you very much for your response. I have already registered the BUG: Error in recalculating product values when switching currencies in quotes and invoices. · Issue #541 · salesagility/SuiteCRM-Core · GitHub

1 Like

What did you set here?

Currencies

Hi

Set ISO-4217 Code field first and then put Conversion Rate:

CRC

Correct, that’s how it was done, and I added the conversion rate of: 526.27

Yeah, it is bug. When you can currency, it does not update amount all the time.