Questions tagged [currency]
Currency fields contain currency values, such as the ExpectedRevenue field in a Campaign, and are defined as type double.
0
votes
0answers
20 views
Display Currency in Salesforce Lightning
I am using the following code
<lightning:formattedNumber value="{!v.clientRecord.Annual_Income__c}" style="currency" currencyCode="USD" currencyDisplayAs="symbol"/>
However, instead of ...
0
votes
0answers
44 views
Display currency in lightning
I am using lightning:input to display a currency value
<lightning:input aura:id="fee" type="number" formatter="currency"
label="Fee" name="fee" value="{!v.feeObj.Fee__c}" step="0....
-1
votes
1answer
76 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
1answer
89 views
Change Account Currency with Apex?
We use our homebrew shop system together with Salesforce and Financialforce.
Invoices are created and send by our shop system. After an invoice is created it will be transmitted to related Salesforce ...
0
votes
3answers
76 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
43 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
347 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.
...
4
votes
1answer
581 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
88 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
71 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
155 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
34 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
27 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
41 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: ...
1
vote
2answers
391 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
138 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 ...
5
votes
1answer
688 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
134 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
269 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
207 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
158 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
214 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
150 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
746 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
133 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
180 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
76 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
767 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
132 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
80 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;
...
0
votes
1answer
2k views
Can I add multiple currency prices to a product in one data upload?
I am using the data uploader to add prices to a bunch of products I just created.
We work in GBP, EUR & USD; Can I use one spreadsheet to upload all currencies in one hit (standard Price) or ...
2
votes
0answers
54 views
Old record shows the converted currency to EUR instead of showing the amount in USD
I have a field in Opportunity named List Price Summary that computes and displays the SUM of the Total Price in all its Opportunity Line Item records through trigger.
For example, I have two ...
0
votes
1answer
272 views
display aggregate result value as currency
I have requirement to display aggregate result values in visualforce page and it should be formatted to currency. Could anyone help me with this issue i am facing.
apex controller:
RepSalesbyFund = ...
0
votes
1answer
104 views
Set the currency of the records to be fetched using SOQL
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 :...
1
vote
0answers
33 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 ...
1
vote
0answers
68 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
186 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 ...
8
votes
1answer
223 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
334 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 ...
2
votes
1answer
462 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
734 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 ...
4
votes
1answer
738 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 ...
4
votes
2answers
825 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
1answer
1k 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
509 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
147 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
1k 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
502 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
639 views
Converting Formula field to a currency field
Can we change a Formula field into Currency field . I need to change a formula field into Currency field . As per salesforce standard feature we are not able to change a formula data type into any ...
1
vote
2answers
3k 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 ...
