SuiteCRM v. 8.1.3 - Issues with currencies in Opportunities module - list view

đź’¬ General Discussion
1

Hi to all.

I’m currently experiencing an issue with the currency field in the List View of the Opportunities module.

I want the list view to show the Opportunity amount in the original (not converted) currency.

I have added the “Opportunity amount” field in Studio > Opportunities > Layouts > List View (it was hidden) and now that value can be added as a column on the list view. However it doesnt show the correct currency symbol of the opportunity amount, instead it shows the default currency of the account (same currency symbol as the converted amount).

Note: in the detail view, the correct currency is shown.

Detail view:
2022-12-05_121627

List view:
2022-12-05_121640

I’d appreciate any help on solving this issue. Thanks in advance.

2

I have exact same issue.

In my edit view, I am selecting Euros as the Currency, but in list view it shows up as Dollars.
No conversion done or anything. Just the sign that changes.

Have you managed to fix this issue?

3

Okay I fixed mine…

Just changed the system currency… Et Voila!

1 Like
4

Can you please explain how to fix this? I’ve tried many times but couldn’t find a solution. Please provide a step-by-step guide.

5

Hello Sohan,

you can change the standard currency “display labels” under admin - locale

image
image2544Ă—618 60 KB

Afterwards, your opportunities will show in the list view with your standard currency display settings:

image
image1902Ă—618 131 KB

In this way, you don’t have to add another currency:

However, this approach is a bit of a quick & dirty workaround - in the DB it will be odd, storing EUR value in the USD column:

image
image695Ă—168 14.7 KB

The clean approach would be to fix the code:

unfortunately, this reported bug is already sitting there since quite a while.

6

image
image1364Ă—297 29.5 KB

Thank you for your response.

I am already aware of the general solution you provided; however, my issue is slightly different.

In SuiteCRM 8, both the “Amount” and “Opp. Amount” fields are currently being displayed in USD ($) in the list view. My requirement is to show the “Opp. Amount” in a different currency, based on the currency assigned to the related opportunity.

How can I resolve this issue?

Additionally, please confirm whether this is a known bug in SuiteCRM 8, or if I need to handle this via customization. If customization is required, kindly provide the necessary file and folder structure for modifying the list view accordingly.

Thank you.

7

Amount = USD (in the DB field)
Opportunity Amount = the value in the converted currency.
In list view, the symbol is wrong (but the conversion seems to be correct)

If your Conversion Rate is configured to be correct / different from 1.0 then you’ll see the correct difference in the list view.

image
image1255Ă—112 10.1 KB

image
image1389Ă—304 24.6 KB

The bug here is, that the list view shows the correct value (opp amount) but the wrong currency symbol. That’s basically what the issue is saying, if I interpret it correctly:

As for the bugfix, one approach would be search for:

scrm-currency-detail in the new code (the Angular UI)

And then look at the trail of the variable and why it renders with the wrong currency symbol (but converts correctly).