Multicurrency: Smart Query gift amount in foreign currency is output with organisation currency symbol

When creating a revenue smart query that filters on a transaction that was made using a foreign currency the transaction amount is displayed with the organisation currency symbol. 
Download and install the latest patch which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch.

Steps to Duplicate

Steps to duplicate

Replicated on sample data.

- Multicurrency is enabled
- Organisation currency in CRM is set to GBP

1. Search and select a constituent record
2. Add a foreign currency payment to the record e.g. $1000 (use a spot rate for the exchange rate at 0.8)
3. Go to Analysis functional area and click on 'Add an ad-hoc query', choose revenue source view
4. Add a query:


Revenue ID is equal to [ID of payment made above]
Output fields:

Application Details\Amount(transaction currency)
Application Details\Amount(organization currency)

5. From query design window click 'Create smart query':

Set RevenueID as a filter (Equal to) and all fields as visible

Primary key field: [blank]
Record type: Revenue
Smart query name: [give it a name]
Description: [blank]

6. Open the smart query just created and filter on the revenueID of the foreign currency payment made above
7. Click preview results and notice the transaction amount is displayed as £1000 instead of $1000, also if you export to Excel it's also displayed in pounds.


 Blackbaud CRM
 4.0, Service Pack 19 SP11

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.