2022 Developer Survey is open! Take survey.

Questions tagged [currency]

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

Filter by
Sorted by
Tagged with
-1 votes
2 answers
43 views

How to change boolean result to a compatible currency value in a formula field

I got this formula and I got stuck trying to make it work. How do I get the result to be compatible with a currency field? Any help would be greatly appreciated! The error: Formula result is data type ...
user avatar
  • 11
1 vote
1 answer
20 views

Question regarding multiple currencies

We do not maintain multiple currencies and we do not wish to do that at this time. What we would like to do is to provide our users with the ability to choose a currency from a picklist dropdown (...
user avatar
  • 3,720
0 votes
0 answers
29 views

Currency Conversion using apex

I have currency fields on a custom object and opportunity object. I want to convert currency fields value of this custom object based on CurrencyIsoCode value on opportunity. Let's say the value of ...
user avatar
0 votes
0 answers
16 views

Custom currency symbol

I need to set a custom currency symbol NOT available through the standard currency symbols in Salesforce. In my country, we use a quite peculiar currency named "Unidad de Fomento" (which ...
user avatar
0 votes
0 answers
38 views

Changing currencyCode and value in datatable

I use lightning datatable and want to display currency columns. I have field balance that calculated during the process and I faced the problem. In some first rows it worked fine, I have sum and then ...
user avatar
  • 3
1 vote
1 answer
40 views

wanted to understand the currency field behavior [closed]

We have a custom object and it has a field lets say PrevYrTPC and it is of type currency. I was going through the records of the current object and I found something which I could not understand. The ...
user avatar
  • 55
0 votes
0 answers
20 views

Formula field with currency return type using other rollup return alot of repeating digits or zeroes values after the decimal places?

We have a scenario where We have one formula field with the currency return type, Now we are using this field in another Rollup field. Let me share one example We have this value CAD 50.00 (USD 38.76) ...
user avatar
0 votes
1 answer
39 views

Multi Currency - When editing a currency field it shows the user currency in the input field instead of the record currency

Multi Currency - When editing a currency field it shows the user currency in the input field instead of the record currency, but saves in the record currency anyway, so what is the point of the input ...
user avatar
-1 votes
1 answer
66 views

System.TypeException: Invalid decimal in Rest Resource @HttpPost

I developed an Apex REST web service in Salesforce with the method 'POST' and i am trying to insert the string value in currency field of Product__c object, so when I try to hit the API im getting the ...
user avatar
3 votes
2 answers
130 views

Is it possible to get a currency symbol in Apex or Visualforce knowing CurrencyIsoCode?

Is there any way to get a currency symbol in Apex or Visualforce knowing CurrencyIsoCode? I need it to display the full price of a product (value and symbol) in Visualforce Mail.
user avatar
  • 332
2 votes
1 answer
472 views

Flow Screen currency formula - how to return null value?

I have a screen flow with a Currency screen element. I'm trying to set the default value with a formula. The formula will either have a value, or it won't. If the result of the formula is null, the ...
user avatar
  • 5,459
0 votes
2 answers
765 views

System.JSONException: Unexpected character ('<' (code 60)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')

public class CurrencyConvertorClass { public static Decimal convertCurrencyToINR(Decimal eur){ Decimal inr = 0.0; HTTP h = new HTTP(); HTTPRequest req = new ...
user avatar
0 votes
0 answers
36 views

Currency value storage and presentation when multi-currency is turned on?

I've read several help pages and posts on multi-currency and note that when this is turned on: A CurrencyISOCode field is set on a record when it is created with the value taken from the user's ...
user avatar
  • 129k
1 vote
0 answers
138 views

Currency value is converting to integer from LWC to Apex

Passing the below object from LWC to APEX Method, in this Payment_Received__c value is 10.50, when i read this value in Apex method its print 10 [ { "Name": "10618", ...
user avatar
0 votes
1 answer
33 views

Hide Currency Records from User

I have one new user in our Salesforce org that we only want to see records with the ZAR (south africa) currency. Our org has multi-currencies enabled (our business trades in USD and AUD), but we only ...
user avatar
  • 31
0 votes
0 answers
12 views

How to get company's default currency in Apex for both single currency and multi currency orgs [duplicate]

Background we are building an SF's custom app and cannot assume if Multiple Currency Settingsis enabled or not (depends on the customer). What I want to do I want to get the organization's default ...
user avatar
0 votes
0 answers
39 views

Formula help for calculation

Need some help editing a formula to calculate commissions. This is the full scenario written out (numbers are changed) and my current formula below that needs some additions (and is not working): If a ...
user avatar
0 votes
2 answers
54 views

How to store 50 billion currency value in salesforce? [closed]

Long Val1= 50000000000 ; Throws an error Illegal Integer.How would i assign 50 billion value in salesforce ?
user avatar
0 votes
2 answers
97 views

How "NextStartDate" field value get calculated for DatedConversionRate object

I would like to know how the calculation is happening for DatedConversionRate's nextstartdate, is it depends on some configuration setting?
user avatar
0 votes
1 answer
143 views

How to map Converted Currency fields to other systems

There are a couple of currency fields that we want to map to our commission system but are not appearing on the mapping for the Tool. I'm not sure how Salesforce implements the fields, or if only they ...
user avatar
0 votes
1 answer
687 views

Text Field Not Formatted in Currency When Selecting Currency Symbol from Dropdown List

I've been repeatedly modifying a Salesforce LWC page which aims to format a text field into a currency format (with corresponding currency symbols, commas, and decimals). Displayed currency symbol ...
user avatar
  • 321
0 votes
1 answer
1k views

How can we use Dated Exchange Rates values in formula fields?

I have a formula(Checkbox) field on the Opportunity object, which shows TRUE, when Some_Value__c (formula(Currency)) field >= 6000$: Some_Value__c / CURRENCYRATE(TEXT(CurrencyIsoCode)) >= 6000 ...
user avatar
2 votes
1 answer
759 views

How to updating conversion rate daily from Apex?

I want to update the conversion rate daily in multicurrency. Please suggest any solution for this as I do not have any idea where to update the conversion rate and how. Thanks in advance. :)
user avatar
  • 145
1 vote
1 answer
356 views

Format decimal according to locale, but with fixed number of decimal places

There were many question around the topic of formatting decimals according to user's locale and rounding decimals, but I haven't seen the one that actually fits my case, so here I go. I am creating ...
user avatar
  • 694
-1 votes
1 answer
1k views

Is there a way to get default currency using apex in single currency org?

I know we can use userinfo.CurrencyIsoCode to get currencycode for user in multi currency org. For single currency org we can manually look into company information and see currency locale. https://...
user avatar
  • 3,309
0 votes
1 answer
392 views

Is there a way to query a currency field in a specific currency?

I have to do a VF with a "total" field for Quotes in a multi-currency org. Is there a way for me to obtain the QuoteLineItem.UnitPrice in U$D regardless of the user's currency configuration?
user avatar
  • 252
0 votes
0 answers
30 views

on clicking any pencil icons to update the record, the currency data fields that are in SEK change to SGD

on clicking any pencil icons to update the record, the currency data fields that are in SEK change to SGD (User's local currency). On saving the records the currency changes back to SEK. This should ...
user avatar
  • 3
0 votes
1 answer
106 views

Account Currency Defaulting to USD instead of Corporate currency (Euro)

I have multi currency enabled in my org with USD, GBP and EURO. EURO is my corporate currency. My user has Local currency as EURO. However, when I create an Account Record without entering the ...
user avatar
  • 1,071
0 votes
1 answer
49 views

Look up question

I have a custom object A, that has a currency field and has a look-up relationship to object B. Now within object B, I am trying to access the value of the currency field of object 'A'. What is the ...
user avatar
0 votes
0 answers
198 views

Salesforce currency field decimal rounding, too many decimal places

How come my currency field numbers are slightly off from the whole numbers? for example 8.90000000000003 23.34999999999997 40.8199999999999 I recall having to do something to prevent this from ...
user avatar
0 votes
0 answers
222 views

How can I tell Salesforce their CPQ Developer Org is BROKEN when their Submit Case is BROKEN?

My original objective was to do the prework setting up a CPQ Developer Org for Superbadge Billing Specialist The first bullet on "Pre-work and Notes" declares: Default currency is USD and default ...
user avatar
1 vote
2 answers
4k views

How can use custom currency in a input field?

I'm using LWC, but I can't set custom currency in the lightning-input, using type number or currency. I also try to use lightning-input-field of type currency, but I found in documentation: ...
user avatar
-1 votes
1 answer
171 views

Marketing Cloud - default no. of digit for phone no. field and default currency

Default max max number of digits for phone number field in my marketing cloud is 9. How can I change it? Similarly, if I try to add a facebook (?) account, it doesn't accept the account whose ...
user avatar
0 votes
3 answers
513 views

Keep currency symbol and amount on same line in VF

I have create a VF page for (PDF) quote generation however i'm struggling keeping the currency symbol and amount together. Looking at my code ... {!$Label.Quote_PDF_AgreesOnPlanned_Act} <b&...
user avatar
0 votes
1 answer
138 views

How to store Currency in limits in currency field

I have a requirement where I need to store values in currency field as $2,00,000/$3,00,000. Basically, that field will be used to denote limits. I cannot do that using a currency field. WHen I tried ...
user avatar
  • 121
0 votes
1 answer
2k views

Converting Currency to Decimal And Converting Back To Currency Display in Email Template

I have a currency field that I multiply by .5 in my apex code. This changes the data type to a Decimal. I want to display on a visualforce email template the newly updated number as a currency. ...
user avatar
  • 3,177
8 votes
1 answer
6k views

How to set currency code to <lightning:input type="number" formatter="currency">

I am developing a custom currency field with lightning:input type="number" formatter="currency" component: <lightning:input type="number" formatter="currency" value="100" step="1"/> I have ...
user avatar
  • 4,749
0 votes
3 answers
253 views

Swiss Currency by using culture code

I have a small problem. I´m using culture-codes to put the value into the correct format. used culture code: de_CH I was hoping to get this format: CHF 18.99 But I got that: ...
user avatar
  • 109
0 votes
1 answer
147 views

Translating own country identifier into SF culture code

I´m quit new in the Amp-world and I´m hoping for help. I have newsletters with a lot of products and prices. Right now I have the content in data extension fields with the final value and currency ...
user avatar
  • 109
1 vote
1 answer
1k views

How to use FormatCurrency with a text field filled with decimal numbers

I have a data extension with decimal numbers (seperated by comma) and formatted as text (changeable). Now I want to use that data and put it with FormatCurrency() into the right shape for the ...
user avatar
  • 109
0 votes
1 answer
55 views

multi currency invoice

My current invoicing system can only process products in euros. We will have shortly customers from the UK, they will be charged in pounds. We will offer to the British customers our products in our ...
user avatar
  • 1,410
0 votes
0 answers
58 views

Formula logical operators currency madness

Either there is something really wrong going on with SF or I'm going crazy. I have some fields: Total__c, Amount_Received__c, Amount_Refunded__c (Currency) Amount_Paid__c (Formula Currency) ...
user avatar
  • 2,000
0 votes
1 answer
241 views

Is Salesforce adding decimals wrongly?

Problem Description: Having weird decimals calculation Field 1(formula(Currency)): 0.53 Field 2(formula(Currency)): 5.27 Formula field Total = field 1 + field 2 Total = 0.53 + 5.27 Expected: ...
user avatar
2 votes
2 answers
3k views

System.TypeException: Invalid decimal Error in apex

I have a currency field in object. I am assigning value to it in apex For US users: the currency format is 241,500.00 so when i apply decimalof on this i am getting 241500000.00. But for Eur users: ...
user avatar
1 vote
0 answers
382 views

inputCurrency format changes on focus

I have an inputCurrency field defined like this: <ui:inputCurrency aura:id="amount" class="slds-p-top_none" value="{!s.Amount__c}"/> This input is inside a component that lives inside an ...
user avatar
6 votes
1 answer
1k views

Lightning currency input component that respects the records IsoCode

I was so used to Visualforce fields that display a currency value in the CurrencyIsoCode of the relevant record that it took me a while to understand why in Lightning wrong Iso Codes (those of the ...
user avatar
1 vote
0 answers
426 views

Multi Currency and Closed Opportunities [closed]

We are in the process of enabling multi-currency, not advanced currency management. We were told that updating corporate exchange rates would not only affect open opportunities but also closed ...
user avatar
1 vote
1 answer
954 views

Need to initialize a currency field to blank or null in a process

Before calculating currency field values, I need to initialize all of these fields to be blank or null values as different fields may need to be populated based on updates to opportunity start and end ...
user avatar
1 vote
0 answers
489 views

How to get rid of the dollar($) sign in currency field in email template

I am thinking of a way to get rid of the $ sign of a currency field in email template. One way to do this is to create a new formula field of number to copy the value which seems a bit clumsy to me. ...
user avatar
  • 12.7k
0 votes
0 answers
765 views

Set Negative Values on Currency Field while loading data with dataloader

I am trying to upload the data using workbench. The file contains columns as Id, currencyField. Here is the sample: ID Column1 | CurrencyField Column 2 XXXXXXX | 1234.33 YYYYYYY | -5678....
user avatar
  • 85