How to show currency Symbol inside the field

Terry · September 12, 2016, 11:42am

Can anyone please show me how to add the currncy symbol in a currency field?

I have tried add a field labeled “Currncy” and set it as a link field and put “Currency” inside the option. After that , I put “currency” inside the option for those fields I want to set this “currency”. I can see those fields will show this Currency Symbol if they are in list view.

But what i want is to to show the currency symbol within the field whose type had been set to “Currency”.

makarand_b · September 12, 2016, 11:47am

@Terry,

Set the fieldtype as Currency the frappe framework will automatically render the currency symbol before the value.

Thanks

Terry · September 12, 2016, 12:01pm

@makarand_b, thanks for the reply.

All the fields has been set field type currncy. But the currency symbol is not showing.

makarand_b · September 12, 2016, 12:06pm

@Terry,

Did you try reloading & clearing cache after changing the fieldtype ?

Terry · September 12, 2016, 1:33pm

I am not sure if the below information is helping or not.

In the item master, i added some custom fields which are used to calculate the item cost and suggested selling price. Those field are set to filed type “currency”.
For the costing part, i want to set it in euro, and for the suggested price, i want to set it in USD.

Terry · September 12, 2016, 1:34pm

@makarand_b, yes I did reload.
The currency field just showing the number with 2 decimals, but no symbol.

Pawan · September 13, 2016, 2:45am

Have you submitted the document ?

KanchanChauhan · September 13, 2016, 7:06am

@Terry In Global Defaults, check if you have selected No for Hide Currency Symbol.

Terry · September 13, 2016, 8:49am

@Pawan. Thanks, I am working on the Item master, there is no “Summit” botton but i did saved. The symbol still not showing up after saved.

@KanchanChauhan, Thanks, I have checked that “Hide Currency Symbol” is set to “No” is the Global Defaults".

Another question, If i have two price lists, one is for buying and one is for selling, they are using different currency, lets say, buying is using Euro, and selling is using USD. Is there something i need to type in for the option field or write custom script?

KanchanChauhan · September 13, 2016, 9:11am

No you should be fine. No need to add any script.

Terry · September 13, 2016, 9:20am

@KanchanChauhan, sorry for keep asking silly question. but how to set field is A use currency Euro and set field B use USD?

TurkerTunali · October 29, 2018, 1:32pm

I think that you should also need to set the Symbol for the currency.
For instance I set “TL” in desk#Form/Currency/TRY

bghayad · January 4, 2019, 11:12pm

Hello @Terry
Was you able to find solution on below:

but how to set field is A use currency Euro and set field B use USD?

Regards
Bilal

clarkej · January 5, 2019, 8:06am

Hi Bilal,

check out fmt_money

github.com

frappe/frappe/blob/develop/frappe/utils/data.py#L475


      
          
          
def get_last_day(dt):
          	"""
          	Returns last day of the month using:
          	`get_first_day(dt, 0, 1) + datetime.timedelta(-1)`
          	"""
          	return get_first_day(dt, 0, 1) + datetime.timedelta(-1)
          
          

          
def is_last_day_of_the_month(dt):
          	last_day_of_the_month = get_last_day(dt)
          
          
	return getdate(dt) == getdate(last_day_of_the_month)
          
          

          
def get_quarter_ending(date):
          	date = getdate(date)
          
          
	# find the earliest quarter ending date that is after
          	# the given date
          	for month in (3, 6, 9, 12):

To find code that calls that method try this search:

frappe@ubuntu:~/frappe-bench$ find . -name '*.py' | xargs grep fmt_money

fmt_money is called here for eg

github.com

frappe/erpnext/blob/develop/erpnext/controllers/accounts_controller.py#L601


      
          						or 1
          					)
          
          
			if self.doctype == "Purchase Invoice":
          				self.set_expense_account(for_validate)
          
          
	def apply_pricing_rule_on_items(self, item, pricing_rule_args):
          		if not pricing_rule_args.get("validate_applied_rule", 0):
          			# if user changed the discount percentage then set user's discount percentage ?
          			if pricing_rule_args.get("price_or_product_discount") == "Price":
          				item.set("pricing_rules", pricing_rule_args.get("pricing_rules"))
          				if pricing_rule_args.get("apply_rule_on_other_items"):
          					other_items = json.loads(pricing_rule_args.get("apply_rule_on_other_items"))
          					if other_items and item.item_code not in other_items:
          						return
          
          
				item.set("discount_percentage", pricing_rule_args.get("discount_percentage"))
          				item.set("discount_amount", pricing_rule_args.get("discount_amount"))
          				if pricing_rule_args.get("pricing_rule_for") == "Rate":
          					item.set("price_list_rate", pricing_rule_args.get("price_list_rate"))

bghayad · February 11, 2019, 12:56pm

Hello;

The currency symbol inside the field can be determined by the option field property of the field. I did not find any other way.

Except to use fmt_money which is python based or to use frappe.utils.fmt_money which is jinja based.
I tried to use frappe.utils.fmt_money in .js file but it did not work. I tried this: frappe.utils.fmt_money(doc.outstanding_amount, currency="LBP"); But it is not working in javascript.

Is there a method to be used with javascript?

I added @Denmark_Del_Puso because he used frappe.utils.fmt_money in jinja in this link:

Regards
Bilal