Questions tagged [currency]

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

27 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
1answer
390 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 ...
2
votes
0answers
63 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 ...
2
votes
0answers
154 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
246 views

Getting currency code with SOQL query for all types of organizations

I need to get the currency code of currency fields (such Opportunity.Amount) in a way that works for both multi-currency and single-currency organizations I don't use Apex, I use SOQL My approach ...
1
vote
0answers
263 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 ...
1
vote
1answer
387 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
281 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. ...
1
vote
1answer
193 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
327 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 ...
1
vote
0answers
54 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
77 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
305 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
24 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
0answers
19 views

European user getting currency displayed in EURO as well as USD

I am having a strange issue. I have a European User, who has language French and Currency EURO given in the user record detail. I have other users from USA who have USD as their currency. I have ...
0
votes
0answers
26 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
152 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 ...
0
votes
1answer
359 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
0answers
38 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
518 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 ...
0
votes
0answers
392 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
251 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
658 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 ...
0
votes
1answer
552 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 ...
0
votes
0answers
392 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
0answers
452 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 ...
0
votes
0answers
666 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 ...
0
votes
0answers
2k 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> ...