Unable to set Currency type on an Asset record via flow designer flow

[chaithra10]

I am working on a catalog flow which creates asset records automatically and sets the cost and currency type(like $, Euro etc), I am unable to set the currency type as this is not a separate field on an Asset record. And it is defaulting to $ each time. COuld someone help?

[J Siva · Accepted solution]

@chaithra10 

PFB.

1. Variable set with 2 variables.
-> Currency type - Ref field

-> Price - String field

Add below variable attribute to the currency type field. So that users can search with both the code and symbol.

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=code;symbol,ref_ac_columns_search=true,ref_ac_display_value=false

Flow:

var price = fd_data._2__for_each.item.price_1; 

The "item" is missing in your script.

[J Siva]

Hi @chaithra10 
Try to set that field using inline script.

PFB the community post with similar requirement.
https://www.servicenow.com/community/developer-forum/change-currency-code-of-a-field-via-script/m-p/...

Regards,
Siva

[chaithra10]

Thanks for the response. I do not want to convert any value. I simply want to pass the currency type from catalog variables to the asset record in hardware table.

[J Siva]

@chaithra10 
Yeah.. It's just a sample. PFB the script to set the currency type. Do the same in your flow inline script.

[J Siva]

@chaithra10 
Catalog item with two variables.

1. Currency type - Reference variable - table: fx_currency.

2. Price - Single line text.

Flow:

Output:

Regards,
Siva