Make Currency amount read only but allow for edit of currency type

[mattystern]

Hello,

I am looking to achieve the reverse of this post. I have a currency field with a calculated value from a record producer and I need to make the amount "Read Only." However, this value may be in either British Pounds or USD. When I automatically feed the record producer into the field as "Read Only," it restricts the currency to the system default (USD.) Is there a way to either:

A - Feed the currency value via record producer based on user selection on a form? OR

B - Make the currency type editable while keeping the amount read only? 

Thanks in advance, the community is always very helpful to me!

-Matt

[Ct111 · Accepted solution]

Hi,

For A) Can you try this  and let me know if this helps.

var currencycode = "GBP";  // put the ISO of the country in which you want.

var cost = 1040;

current.cost.setValue(currenycode + ';' + cost);

For B) Refer  below

• Multiple: Enables you to enter multiple price values for an item using a different currency for each price. The field’s value is the value entered in the user’s session currency; otherwise, the first price entered is converted to the user’s session currency. Whenever conversions are performed, the latest currency rates are used. Note: The first value entered is used during display. The additional values are not used during calculations.

For examples of using price field, refer to the tables used in Service Catalog.

A price field’s currency code and numeric value can be changed in a form. An edit icon is shown next to the price field. Clicking the edit icon displays a form that can be used to edit all details of the price field:

• Currency: List of currencies enabled in the system in the combo box. In single currency mode, the currency is a label and cannot be changed.
• Amount: Numeric value formatted in the user’s locale
• Type: Combo box with calculated, fixed, multiple
  • When the price type is changed to multiple, the system creates child records for all currencies enabled in the platform populated with values converted from the amount field using latest currency conversion rates.
  • In single currency mode, the type cannot be changed.
  • The price type can be modified any time

Mark my ANSWER as CORRECT and HELPFUL if it helps.

https://docs.servicenow.com/bundle/madrid-platform-administration/page/administer/currency/concept/p...

[mattystern]

Hello,

Thank you for the information! This information was helpful but did not achieve the functionality needed. The first solution did not work, mostly because of the way I have to set the value is a little much to say the least. I tried adding it in as a static value as outlined and was unable to get it to change.

The second solution outlined in the ServiceNow docs is on each entry in the table and requires the field to be editable, unless I am missing something. The value is edited from this little pencil seen here on the right here. 
  

I just had a meeting with the customer who said they are just going to use USD and add a "Standard Conversion" variable based on currency which will multiple the number and convert it to USD. I added some simple if logic for it and I am just going to make the whole field read only.

Thank you again for reaching out!