Change Currency Docfield Symbol

tmatteson · October 29, 2018, 4:31am

What’s the best way to change a currency docfields currency symbol? From $ to ₹, USD to INR, for example?

I’m using format_currency and then refreshing the field but I can’t trigger a change in the symbol, when I log the output it shows “₹ 100.00”. I cant find an obvious way to do it in set_df_property which seemed like another logical place to look.

snv · October 29, 2018, 5:49am

Hi,

Maybe you can get some hints here:

github.com

frappe/erpnext/blob/c1231d65fdb59dfdc28f5b2e1bbc5bed552fc878/erpnext/public/js/controllers/transaction.js#L855


      
          		// What TODO? should we make price list system non-mandatory?
          		this.frm.toggle_reqd("plc_conversion_rate",
          			!!(this.frm.doc.price_list_name && this.frm.doc.price_list_currency));
          
          
		var company_currency = this.get_company_currency();
          		this.change_form_labels(company_currency);
          		this.change_grid_labels(company_currency);
          		this.frm.refresh_fields();
          	},
          
          
	change_form_labels: function(company_currency) {
          		var me = this;
          
          
		this.frm.set_currency_labels(["base_total", "base_net_total", "base_total_taxes_and_charges",
          			"base_discount_amount", "base_grand_total", "base_rounded_total", "base_in_words",
          			"base_taxes_and_charges_added", "base_taxes_and_charges_deducted", "total_amount_to_pay",
          			"base_paid_amount", "base_write_off_amount", "base_change_amount", "base_operating_cost",
          			"base_raw_material_cost", "base_total_cost", "base_scrap_material_cost",
          			"base_rounding_adjustment"], company_currency);
          
          
		this.frm.set_currency_labels(["total", "net_total", "total_taxes_and_charges", "discount_amount",

EDIT:

For Example:

frm.set_currency_labels(['total'], 'USD')

tmatteson · October 29, 2018, 6:45am

OK. So this is part of the solution (and a part I forgotten about, so I glad you pointed me to it) but it’s not changing the symbol, just the label. In the console:

cur_frm.set_currency_labels(["amount_due"], "INR")

cur_frm.set_currency_labels(["amount_due"], "USD")

The currency symbol remains $ but the label changes.

snv · October 29, 2018, 8:08am

The currency fieldtype can be dynamic based on Options in the field’s meta.

You can create a link field for Currency doctype and set that field’s name as “options” for the field whose symbol you want to change. (See Sales Order doctype for example)

Then you can have the label changed and dependent field refreshed on change of link field.

tmatteson · October 30, 2018, 4:42am

Yes! That worked. Thank you @snv

bghayad · December 31, 2018, 12:51am

Hello @tmatteson

Can you please the script that you used to accomplish this?
I need to set the symbol for the currency field (it will be dependent on another selection), so how I can obtain this?

Regards
Bilal

bghayad · January 3, 2019, 10:38pm

Hello @tmatteson
Can you please help?

Regards
Bilal

tmatteson · January 4, 2019, 1:00pm

I can’t find where I’m doing it in the code that I wrote. I know that I have not been able to change it in a child table at all.

bghayad · January 4, 2019, 11:19pm

What this thing that worked?

Regards
Bilal

clarkej · January 4, 2019, 11:24pm

Continued here How to show currency Symbol inside the field - #13 by bghayad

clarkej · January 5, 2019, 5:39pm

This part of the puzzle helps

github.com

frappe/frappe/blob/develop/frappe/model/meta.py#L460


      
          			self._table_fields = DOCTYPE_TABLE_FIELDS
          		else:
          			self._table_fields = self.get("fields", {"fieldtype": ["in", table_fields]})
          
          
	def sort_fields(self):
          		"""Sort custom fields on the basis of insert_after"""
          
          
		field_order = []
          		insert_after_map = {}
          
          
		for field in self.fields:
          			if not getattr(field, "is_custom_field", False):
          				field_order.append(field.fieldname)
          
          
			elif insert_after := getattr(field, "insert_after", None):
          				insert_after_map.setdefault(insert_after, []).append(field.fieldname)
          
          
			else:
          				# if custom field is at the top, insert after is None
          				field_order.insert(0, field.fieldname)

bghayad · June 22, 2019, 2:00am

Hello;

How I can use set_currency_labels for child table field?

Regards
Bilala

Thukten_Dendup · February 28, 2022, 12:55pm

frappe.model.set_currency_labels(cdt, cdn, "amount", "USD);

Try this one

adam26d · August 22, 2022, 5:58pm

Woah. I had to read this like 5 times to understand it.

What @snv is saying is very straight-forward:

Create a link type field in your doctype linked to Currency (doctype)

image1966×606 52.4 KB
Create your currency field

image1966×580 54.1 KB
Put field 1 as the option in field 2

image1966×606 57.3 KB

Field 2 will automatically get its symbol when field 1 changes

TurkerTunali · August 26, 2022, 7:59am

We can also specify the currency symbol in the options something like “company.default_currency”.

bluesky · November 1, 2022, 11:33am

I tried all the suggested solutions here but couldn’t manage to change the currency symbol used in a query report. How can I adjust the currency (in a multi-currency setup) to a different currency than the standard currency? I used Currency as field type and the field is correctly displayed as a currency. However, I cannot adjust the symbol to display a different symbol from the default currency. What am I missing?

tmatteson · November 1, 2022, 12:41pm

In a report you need a column for the currency. For example, the P&L report returns a currency column but it’s hidden from the user.

bluesky · November 1, 2022, 12:59pm

Thanks @tmatteson. I tried this (following @adam26d suggestion) but I don’t see any enabled currencies in the query report. Is it somehow different for query reports than for changing in standard doctypes (I think that was the original question here)?
This is from the report:

Is it maybe that the “Options” field in a doctype is different from the options in a query report?