Currency fields contain currency values, such as the ExpectedRevenue field in a Campaign, and are defined as type double.

learn more… | top users | synonyms

0
votes
0answers
16 views

How to Create fields based on the number inputted by user?

So I was just wondering how can I create custom fields (which will take in a currency) when the user has specified the amount of fields to create. So for example, I have a total Commission of $100 and ...
1
vote
0answers
8 views

Records of custom objects imported to salesforce have currency code that cannot be updated to the same code as in csv file

I have already imported a list of records of a custom object to salesforce via data loader. Now the imported records have currency fields in ISO code(THB) that we imported to salesforce. Unfortunately ...
2
votes
0answers
27 views

Stumper: unexpected conversion behavior in multi-currency organization

I am facing an issue wherein our custom currency conversion is seemingly being short-circuited by the standard multi-currency functionality, but only sometimes. Our organization has multi-currency ...
1
vote
1answer
16 views

Get currency from Asset object in Apex

How do I get the currency in which asset price is stored? Can I write something like asset.currency in Apex? I'm creating a package for org with multiple currencies, and I need to convert the asset ...
7
votes
1answer
140 views

I see a possible platform bug relating to currency - would like help confirming, or show me what I'm missing

Historically it's been possible to determine if advanced currency management is enabled by using: Schema.getGlobalDescribe().containsKey('DatedConversionRate'); as this object is only available on ...
2
votes
2answers
89 views

SOQL query failing when comparing formula field and currency field values

I'm having trouble trying to figure out what's wrong with this SOQL sentence: SELECT Id, FormulaField__c, CurrencyField__c FROM MyTable WHERE FormulaField__c != CurrencyField__c ...
0
votes
0answers
48 views

How to Retrieve a User Standard Field and add it to a Formula in a Custom Object?

Here is my dilemma. I have a Custom Object with a Formula(Text) field. I want this Formula Field to retrieve the User's currency being set in User's Profile. By the way, MULTICURRENCY is ENABLED. My ...
2
votes
1answer
69 views

Euro Currency format in visualforce pdf

i just read every article about currency conversion but i did not found the solution. I have a visualforce rendered as pdf with a lot of currency fields. But they were displayed either like 1000.00 ...
4
votes
1answer
61 views

How to auto populate the currency value into the custom object while creating record using related list button

I have opportunity car set (custom object , Master object) which has a related list in that "service"(custom object,child object). In service there is a standard picklist field called "Currency". It ...
2
votes
1answer
63 views

In Reports, Show Currencies option will not default to Personal Currency

Overview: So my organization has just activated the Multicurrency feature on one of our Sandbox environment for development and testing purposes. In one of our reports, there is a Currency field ...
1
vote
1answer
90 views

Visualforce currency euro

I need to display currency. This field is Roll-up summary of formula fields with return type 'Number' <apex:outputText value="{0, number, currency}"> <apex:param value="{!Invoice....
0
votes
0answers
58 views

Error using S4G Currency updater - Winter '16 sandbox

I've installed the S4G Currency Updater 3.6 in a sandbox running Winter 16. I set up the FX Currency updater app, to not use Advanced Currency Management. The currency app seems to update 1 of 5 ...
0
votes
1answer
76 views

Get Currency Symbol using REST API

Is there anyway to find out the Currency Symbol used for Currency fields using REST API?
0
votes
1answer
29 views

How to fix Currency in a Custom Object

I have got a custom Object filled with market data, I like to use Dashboards to picture the Trends in the worldmarket we are working in. This Object is not related to any other Object. We are using ...
1
vote
2answers
94 views

Simple Maths on Currency Value in Formula

I have been asked to create a field on Opportunity that will show the value of the Amount field but taking into account the Probaility value. So, if the Amount field was GBP 100,000 and the ...
1
vote
1answer
219 views

Trigger for Converting Amount(Currency/Number) to Words

Has anyone else come up with a solution by Trigger for this? I have been trying to figure this out for a few weeks now but to no avail. for e.g Amount - 200$ Amount in words - Two hundred ...
2
votes
2answers
98 views

Standard Currency field modification

I recently enabled multiple currencies in my org. I know that for Opportunities once the currency is set and there are line items that currency can not be modified. Is this true for all objects? I ...
1
vote
1answer
305 views

Pricebook entry currency code does not match opportunity currency code

I have a Visualforce page which create a product record, a priceBookEntry record and a opportunityLineItem record. I don't understand why in only one case, I get this error : In my code, I first ...
0
votes
0answers
103 views

REST API get CurrencyIsoCode of single Currency org

So with a multi currency, my understanding is I could check the CurrencyIsoCode of the record. For single currency, it's all a corporate default, right? But the identity, user, and organization ...
1
vote
1answer
382 views

How to manage thousands separator for a number field on email template?

I would like to display the Purchase price with thousands separator : for example 16.00 24.96 3,316.57 the problem when I write this code : <apex:outputText value="{0,number, 0,000.00}"> ...
1
vote
1answer
271 views

How to format currency in a visualforce page rendered as a PDF?

I have a visualforce page which contains currency field. When rendered as a PDF, it loses the format of the currency. How can I keep the currency format? I am using CSS to put the dollar sign in ...
0
votes
1answer
98 views

Pulling in currency field from Salesforce into Exact target

Wonder if anyone can help me, I am pulling in a currency field from Salesforce into ExactTarget but I have the following issue: If the currency ends with a zero (i.e. 223.00) the last digit does not ...
2
votes
1answer
63 views

Currency field and rendered attribute do NOT seem to work together at all

I've just spent the better part of my day trying to sort this out. Seems that if i have a Currency type in my custom object (mortgages__c), there is no way to get the Page to gather input and reflect ...
1
vote
2answers
92 views

Currency Conversion

For building a Currency conversion function , we will be needing exchange rates on an hourly basis to be stored in SFDC. Is this going to be a manual task or we can automate the population of exchange ...
1
vote
1answer
118 views

S4G Currency Updater

This app does not do what is expected. I've added currencies to the company profile, enabled Advanced Currency Management, entered the recommended Remote Site, and Authenticated myself as the User. ...
0
votes
0answers
143 views

Currency Conversion Issue

I am working on a OptyLineItem trigger that does a rollup summary on the Opty header of a custom currency field on the OptyLineItem. The default currency is USD and Advanced Multi-currency is enabled....
0
votes
2answers
682 views

How do I remove the Decimal from a Currency Field

I want to get my custom currency field to show no decimal places, but when I update the decimal number in the customization page to zero, the field still shows 2 decimal places for the currency field ...
0
votes
0answers
170 views

Changing already created text fields into currency fields?

So I have a really tedious problem. I've been plopped into a SalesForce setup that was created by someone else and they want me to automate our company's billing process a little. The issue is for ...
1
vote
2answers
259 views

One report - 2 totals - Multiple currencies

I am running a closed oppty report. We have Advanced Multiple Currency enabled, and some of the opptys are in INR. When summing up the Amount and Grand Total, I get 2 different results. So, which ...
1
vote
2answers
2k views

Currency conversion with current Exchange rates

I need to convert the Currency from EURO to USD , I am using the fields are 1. TestCurrency__c - Currency 2. CurrencyConvert - Formulafield(Currency datatype) My Organization Corporate Currency is "...
0
votes
1answer
506 views

Maximum Length of Currency field with its Decimal Places Component

What is the Maximum Length Of Currency Field with its Decimal Places Component. ?
0
votes
0answers
285 views

Currency Field as Workflow Criteria

I created a workflow on opportunities with one criterion being 'Amount greater than 19,999'. The workflow saved without an issue but didn't respect this individual criterion (i.e. performed an email ...
3
votes
1answer
804 views

Currency is coming as Standard field in every custom object

I have multiple currencies in my org. My Advanced Currency Management is not enabled. Now when I am creating any custom object, I can see that Currency is coming as Standard field on every object ...
1
vote
2answers
712 views

Opportunity Amount - Formula field not displaying currency

We have a custom object and in that custom object, we have a formula field, which will display the opportunity amount... (Formula field return type is Currency) Opportunity__r.Amount In the ...
5
votes
1answer
276 views

How to identify Advanced currency is enabled in apex class?

I need to write some apex code when advanced currency management going to enable in our company. Because salesforce supports only for a limited objects that supporting dated currency rates.Previously ...
1
vote
1answer
505 views

Negative currency data displaying in parenthesis. Minus symbol is missing. Any suggestions?

In my visualforce page, i am displaying amount data and it is working fine if the amount is a positive number. But if it is negative amount then the data is enclosed in a parentheses. But, i need a ...
0
votes
0answers
394 views

Decimal places are not coming in Formula field(number) in html email template

I have a currency formula field field1__c which is again referenced in another formula field Field2__c(number). I have selected decimal place as 2.When I use this formula field in Field2__c decimal ...
2
votes
2answers
106 views

Euro currency in approval process bug when using decimals?

I have an approval step criterium that records below €5,55 should be approved automatically. I can't get it to work. I tried setting the step to "greater than 5,55, else approve". However the comma ...
2
votes
1answer
176 views

Find out if field is of type Currency without consuming Describe's?

Parts of my code copy hundreds of arbitrary fields of an arbitrary object to another object. Before copying currency fields I want to do some fx conversion. How can I find out if a field is a ...
0
votes
0answers
944 views

opportunity currencyisocode equal to account

trigger Accountcurrency on Opportunity (before insert) { Set<Id> accIds=new Set<Id>(); for (Opportunity opp : trigger.new) { accIds.add(opp.AccountId); } List<Account> ...
4
votes
1answer
259 views

Different currencies in the same opportunity

it's possible to have different currencies in one opportunity? for example: line item 1 $USD line item 2 $MXN Thanks
7
votes
2answers
905 views

Currency fields show other values on a page that in the database

I am confused by the behaviour of Currency fields in Multi-Currency environments. My app does a calculation on day X and stores its result in a record. The custom page which displays a SUM of those ...
2
votes
0answers
72 views

Currency History Tracking

I am building a custom visual force page and one of the bottle necks is the lack of a "History" related list. I am building the "History" component first but I hit a roadblock: Tracking ...
1
vote
1answer
1k views

Get Symbol of Default Currency in Multicurrency Org

Is there a way to get the symbol (€ not EURO) of an orgs default currency via Apex or a Visualforce global variable? I know how to get the ISO Code: SELECT IsoCode FROM CurrencyType WHERE ...
4
votes
2answers
3k views

Apex:outputText format currency without object value for apex:param value

I have a visualforce table where I'm creating a discount calculator. Basically user inputs a discount percentage and the table on the visualforce updates automatically to show you the updated price ...
1
vote
1answer
3k views

How to set the value of a currency field from a formatted string

In apex, how would you set the value of a currency field with a formatted string? See the sample code: String price = '$1,000.00'; MyObj__c obj = new MyObj__c(); // this line won't compile, so I'...
27
votes
2answers
5k views

How to use Advanced Currency Management (ACM) in Custom Objects?

I've been searching for the last two weeks about how to implement Multi-Currency correctly in our organization. I'm pretty sure I'm not the only one who noticed that if you want to use the Advanced ...
4
votes
1answer
2k views

Pricebook and currency

We have set-up products with a USD and CND price. We have multi-currency set-up in SFDC. When I set an opportunity to USD and select products, it all works fine. But when I set the opp to CND, no ...
12
votes
1answer
3k views

How to access the Organization “Currency Locale” ISO Locale code (NOT Currency code) in Apex/SOQL

First of all, before telling me that this is a duplicate of the previously-asked question "Display currency symbol", READ THE WHOLE QUESTION. Summary: I am trying to replicate the functionality of ...
2
votes
2answers
967 views

Get currency symbol in Visual Force Email Template

I need to get currency symbol in visual force email template. I want it to be the currency the user is using. I check the docs here: http://www.salesforce.com/us/developer/docs/pages/Content/...