Questions tagged [currency]
Currency fields contain currency values, such as the ExpectedRevenue field in a Campaign, and are defined as type double.
105
questions
0
votes
2answers
26 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 ...
0
votes
0answers
20 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 ...
1
vote
0answers
45 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", ...
0
votes
1answer
22 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 ...
0
votes
0answers
11 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 ...
0
votes
0answers
34 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 ...
1
vote
2answers
37 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 ?
0
votes
0answers
12 views
Salesforce CurrencyISO Code Confusion
I noticed one strange thing in our Client's Production ORG. We have an apex class that calculates salary proposals from employee contract object. The currency iso code is EUR in the contract and the ...
0
votes
2answers
48 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?
0
votes
0answers
18 views
Reference Text Formula in Currency Formula
Trying to create a Currency formula field then essentially goes
IF Text field CONTAINS "Partial Credit" (Amount__c * 0.5)
IF Text field CONTAINS "Full Credit" (Amount__c * 1)
But ...
0
votes
1answer
67 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 ...
0
votes
1answer
399 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 ...
0
votes
1answer
433 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
...
2
votes
1answer
392 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. :)
1
vote
1answer
189 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 ...
-2
votes
1answer
799 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://...
0
votes
1answer
217 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?
0
votes
0answers
26 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 ...
0
votes
1answer
57 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 ...
0
votes
1answer
43 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 ...
0
votes
0answers
98 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 ...
0
votes
0answers
198 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 ...
1
vote
2answers
2k 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:
...
-1
votes
1answer
134 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 ...
0
votes
3answers
375 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&...
0
votes
1answer
103 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 ...
0
votes
1answer
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.
...
7
votes
1answer
5k 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 ...
0
votes
3answers
221 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: ...
0
votes
1answer
127 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 ...
1
vote
1answer
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 ...
0
votes
1answer
44 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 ...
0
votes
0answers
47 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) ...
0
votes
1answer
160 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: ...
2
votes
2answers
2k 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: ...
1
vote
0answers
340 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 ...
6
votes
1answer
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 ...
1
vote
0answers
346 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 ...
0
votes
1answer
695 views
currency field multiplied by another number rounded down its decimals
We have a currency field which should produce a currency result with decimal points after multiplication. However, the decimal part was consistently round down to zero. All fields in the formula have ...
1
vote
1answer
705 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 ...
1
vote
0answers
392 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. ...
0
votes
0answers
594 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....
0
votes
1answer
334 views
How to replicate NumberFormat based on locale in salesforce
I want to show currency on VF page in different formats based on locale used on the template. NumberFormat class is available in Java to achieve this but in apex is there any way to achieve this.
...
0
votes
1answer
2k views
Formatting as a currency on a VF page
I'm trying to render a currency value to a VF page. Whether I use Decimal or String, it still doesn't seem to work with the OutputText formatting :-
<apex:column>
<apex:facet name="...
1
vote
1answer
222 views
How to NOT convert QuoteLineItems currency in a trigger's queries?
TL;DR:
I need to compare QuoteLineItems and Opportunity Products in a trigger, but the queried rows amounts are being automatically converted to user-profile's currency, failing my comparison. How ...
1
vote
1answer
461 views
Selectively disable Parenthetical Currency Conversion
I'm trying to find a way to disable the 'Parenthetical Currency Conversion' only for a specific object.
Currently, we have one custom object where the business requires a different exchange rate ...
0
votes
1answer
96 views
Enabled Multicurrency in Org
I have enabled multicurrency in org ,but the CurrencyISOCode field got added to all Objects PageLayouts.
I want to remove this field from all pagelayouts.Please suggest .
i have almost 600 objects and ...
0
votes
1answer
1k views
How to separate currency values through commas in salesforce formula field
how to separate currency values through commas in salesforce formula field.
My code :
TEXT(ttt__c) & " to " & TEXT(sss__c) & " xxx in "& city__c & if(State__c="",""," "& ...
2
votes
1answer
947 views
SOQL: Get most recent amount grouped by a parent and a type
Should be simple had it been SQL. But. I would like to get the amount field value that belongs to the most recent month available for that parent and that type.
Data:
Parent_Id__c Type__c ...
0
votes
1answer
96 views
working with salesforce currency fields
I have to perform some calculations on two currency field in the following manner and display in the UI:
field1*field2/field2
So i have the following code for this:
Decimal value1 = object.field1;
...
