Currency format - how to change it?

[Spinaker]

Hello.
Can someone help me with the currency format? I want to have a format for example: 100.000,00 PLN (what means one hundred thousands PLN and zero GR. Now I have something like on attachement - currency symbol in the front and then value in "k" on the end... In my language (PL) it is not acceptable...
Thank you all in advance.
Regards!

[kinshibuya]

Hi! The K you can change on the file \sugarcrm\include\languages\<youlanguage>.lang.php

'LBL_THOUSANDS_SYMBOL' => 'K',
chage it for what you need,
This chart is a custom chart? wich one is it?

[kinshibuya]

This chart is divided by 1000, you want to remove it?

[Spinaker]

Exactly, I want to remove the dividing - I want simple value
PS - this is a standard chart - opps by lead source - no customization

[kinshibuya]

ok this you have to do on the dashlet code.
try changing this file:

/sugarcrm/modules/Charts/Dashlets/OpportunitiesByLeadSourceDashlet/OpportunitiesByLeadSourceDashlet.php
near line 104 on the constructQuery function
where is this:

   $query = "SELECT lead_source,sum(amount_usdollar/1000) as total,count(*) as opp_count ".
                    "FROM opportunities ";

Change to:

 $query = "SELECT lead_source,sum(amount_usdollar) as total,count(*) as opp_count ".
                    "FROM opportunities ";

[Spinaker]

And what with items which are not a dashlets? I mean all the numbers in for example opportunity list view? Here I have a currency symbol before the numbers - i want to have it behind...

Edit:
The best in my language is, where the value is show in this format (one million dollars): 1.000.000,00 $
So I want to make something like 1.000.000,00 PLN for my language...

[kinshibuya]

well in Admin -> System Locale Settings you can change the Symbol from $ to PLN but to put it behind i guess you need to build a view.list.php for the module Opportunities.

[Spinaker]

I have changed it, but I have still no 1000s separator in dashlets (dot . ) and unfortunetly i don't know how to make a custom view.list.php