• From: India, Hyderabad
  • Registered: 07/31/2020
  • Posts: 2

Topic: Currency setup for India

Currency setup for India like INR or symbol

2 Reply by dearmosin (edited by dearmosin 08/30/2020 02:01:22 am)

  • From: India, Pune
  • Registered: 06/12/2019
  • Posts: 54

Re: Currency setup for India

Banking and General Ledger - Currencies

Currency Abbreviation: INR
Currency Symbol: Rs. or INR
Currency Name: Indian Rupees
Hundredths Name: Paise
Country: India

If you really need ₹ as only option then open phpmyadmin select table 0_currencies under SQL write this query and GO

Please Note: 0_ is the default prefix of primary company. Replace with your company's prefix.

ALTER TABLE 0_currencies MODIFY COLUMN curr_symbol VARCHAR(10)
    CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';

Now Try Inserting ₹ symbol, it must get updated

Mohsin Mujawar
Impulse Solutions

dearmosin's Website

3 Reply by dearmosin (edited by dearmosin 08/30/2020 02:06:13 am)

  • From: India, Pune
  • Registered: 06/12/2019
  • Posts: 54

Re: Currency setup for India

@apmuthu can the above query be included in English Indian COA - New

Mohsin Mujawar
Impulse Solutions

dearmosin's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Currency setup for India

The reason why this is not implemented is that there are quite a few legacy users and those who use WinXP still in India where unicode in older browsers may not have the rupee font.

If you want, then replace line 508 in the CoA:

  `curr_symbol` varchar(10) NOT NULL DEFAULT '',

with whatever encoding you want - please note that the one of the first lines has SET NAMES latin1; as the default encoding.

Also change the data in line 521 accordingly for the symbol besides saving the file as UTF-8 encoding text and change the _init/config file with the proper encoding.

apmuthu's Website