How to Query Currency Fields in Multicurrency Organizations?

Query Currency Fields in Multicurrency Organizations

Currency_Fields_in_Multicurrency_Organizations        If an organization is multicurrency enabled, you can use convertCurrency() in the SELECT
clause to convert currency fields to the user's currency.An organization has enabled advanced currency management, dated exchange rates will be used when converting currency fields on opportunities, opportunity line items, and opportunity history.




SELECT Id, convertCurrency(AnnualRevenue)
FROM Account

You cannot use the convertCurrency() function in a WHERE clause. If you do, an error is returned. Use the following syntax to convert a numeric value to the user's currency, from any active currency in your organization:

WHERE Object_name Operator ISO_CODEvalue

Opportunity records will be returned if the record's currency Amount value is greater than the equivalent of
USD5000. For example, an opportunity with an amount of USD5001 would be returned, but not JPY7000.

FROM Opportunity
WHERE Amount > USD5000
Use an ISO code that your organization has enabled and is active. If you do not put in an ISO code, then the numeric value is used instead of comparative amounts. Using the example above, opportunity records with JPY5001, EUR5001, and USD5001 would be returned. Note that if you use IN in a WHERE clause, you cannot mix ISO code and non-ISO code values.



Apex Apex Default Methods Apex Methods Apex_Collections Apps Batch Apex Books CRM eBooks Data Import Wizard Data Management DataLoader Difference Between Error in Salesforce FAQ's FAQ's-Apex FAQ's-Apps FAQ's-CRM FAQ's-Data loader FAQ's-SOQL & SOSL FAQ'S-Triggers FAQ's-User Profile & Security FAQ's-VF Explorer Ide Formulas & Functions Integration Interview Questions Only Latest_Updates Limits&Best Practices Online-Training Reports and Dashboards Salesforce Deployment Salesforce Realtime Examples On Development Salesforce Realtime Task On Admin Salesforce Realtime Tasks Salesforce Realtime Tasks- Apex Salesforce Training Salesforce1 Mobile Sites SOQL Spring'14 Release Triggers User Profile & Security VF Tags VisualForce Winter'14 Release Wizard for Accounts/Contacts Workbench Workflows and Approvals
Sfdc Gurukul- All in one place for salesforce and step by step tutorial for beginners: How to Query Currency Fields in Multicurrency Organizations?
How to Query Currency Fields in Multicurrency Organizations?
How to Query Currency Fields in Multicurrency Organizations?,currency converter in soql,query currency fields using soql,salesforce Multicurrency Organizations converter in soql,soql convert currency ,soql currency conversion,salesforce soql convert currency
Sfdc Gurukul- All in one place for salesforce and step by step tutorial for beginners
Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy