I have a situation in a multi currency org. I have Booking Object as child related to Opportunity Object. On a Visualforce page I want to show list of Bookings related to the a Opportunity.
Problem : Booking object has a Amount field which can be of any currency. My requirement is, irrespective of Booking record's currency I want to show all the bookings according to the currency of Opportunity(Parent) on a page.
I have tried the convertCurrency(field)
function but it is converting according to user's currency which is not suitable for my requirement.
Any help would be much appreciated.
Select Id, Name, Opportunity__r.Amount, Opportunity__r.Id, Opportunity__r.CurrencyIsoCode, Amount__c from BookingObject__c WHERE Opportunity__r.CurrencyIsoCode != 'USD'