3

When a currency field is added on any report created through CRM report wizard and the report is supposed to display the sum of the value entered in the currency field, the value returned on the report is displayed in the base currency format, when it is expected to show results in the format of the currency values added to that field.

- We create a custom currency field on Opportunity say Amount. System will automatically generate another field Amount_base which will save the data in the base currency format
- Now we add a secondary currency say "Euro" and create some Opportunities using the Euro currency. The data in Amount field is in Euro format
- Create a report in CRM using the wizard and add both the fields Amount and Amount_base
- Now when we generate the report, the sum of both fields is in Dollar.

Category:
STATUS DETAILS
Under Review