ListView shows only default currency

[zaska]

Hi there,

I have some custom modules and using a currency fields, but my problem appears in the Opportunity module too. My default currency is EUR and I've added 3 more currencies. When create an opportunity with currency different from the default in ListView I see the default currency (EUR). In DetailView it shows the correct symbol. Do I have to write some custom scripts for ListView or it is a bug?

Sugar CE 5.2.0h

[spthibault]

I'm having the same problem. Also, when I try to order the list by currency the result is always an empty list.

[goko]

The thing with the varying currencies is a feature, not a bug .

Opportunities amounts are very tricky...

First some background:
When you create an opportunity you select a currency, which is saved in opportunities.currency_id, and the amount you enter is saved in opportunities.amount.
When you save the record Sugar calculates the amount in the system currency based on the currency rate at that time, and saves that in the opportunities.amount_usdollar field.
(amount_usdollar is a very misleading column name, since the system currency can be any currency.)


Then we come to what's displayed where:
An opportunities amount is shown in different currencies depending on the view.

ListView and Reports shows the amounts in the current users currency.

EditView and DetailView shows the amount that was originally entered.


If you deal with currencies where the rates can vary over time, this can lead to some strange consequences because Sugar has choosen to make the opportunities.amount_usdollar the "master" when calculating the amounts shown in the ListView and Reports.

I show you what I mean in a few steps:

1. if you don't have more than one currency, add one (Admin->Currencies)
2. create an opportunity with the amount in a non-system default currency
3. now set your users default currency to the currency you used for the new opportunity (My Account->Edit) and have a look at Opportunities Listview and detailview - nothing strange sofar
4. change the conversion_rate for the opportunities currency (Admin->Currencies)
5. have a look at Opportunities Listview and detailview - Ooops!! The amount in Listview differs from the amount in DetailView even though it's the same currency!!

This strange behaviour is reported as bug 28793. Sugar thinks its a feature request (target 5.5.2)

[maloner]

Hi goko,

We are currently experiencing the same problem on 5.5. Did you get anywhere with this?

Thanks,

John.

[aureh12]

Custom module on 5.5 with a currency field.

Subpanels display: 1000$
DetailView display the right value: 1000€

How to fix the subpanel ?

Thanks for your help

[aureh12]

As I said, I have a custom module.
I created price (currency) and studio created automatically the currency_id.

fields:
price
currency_id

When I display the subpanel, the $bean->currency_id is empty for all the records.
As a result, all my records in the subpanel are displaying $ (default currency)

DetailView value : €32,00 (good)
Subpanel value : $32,00

I populate $bean->currency_id using a the logic_hook process_record and sql query.
The result is interesting:

DetailView : €32,00 (good)
Subpanel value : €24,00
ListView value: $32,00

Does anybody know what's going on ?

[fagut]

in subpanel defs, add

    'currency_id'=> array(
      'usage'=>'query_only',
   ), 
  

no need for logic hook.

[wos]

Anything new here?

We have the 6.1.1 version.

I have three different currencies, and all of them have the us dollar sign in the report list and if I use the print as PDF there are no currency signs.

Can this be fixed in Admin > Studio?