Hi Rahul, I have updated the demo server.
A fresh installation of Fineract should not have this issue. It looks like tenants created on the demo server are having a sample database that consists of a few loan products and Chart of accounts configured, this sample database is restored from incubator-fineract/fineract-provider/src/main/resources/sql/migrations/sample_data/load_sample_data.sql. I had a quick look at this file and it has incorrect symbols for INR and other currencies. Fixing this file would ensure that *https://issues.apache.org/jira/browse/FINERACT-547?filter=12342983 <https://issues.apache.org/jira/browse/FINERACT-547?filter=12342983>* does not occur in new tenants created with sample data on the demo server. Regards, Vishwas Regards, Vishwas +1 (202) 716 6675 On Sat, Feb 10, 2018 at 10:41 AM, Rahul Goel <[email protected]> wrote: > Hi community, > > I was looking into this iss*u*e : > https://github.com/openMF/community-app/issues/2440 > *https://issues.apache.org/jira/browse/FINERACT-547?filter=12342983 > <https://issues.apache.org/jira/browse/FINERACT-547?filter=12342983>* > > I found that this is a bug of FINERACT project due to incorrect data in > database. > I tried fetching currency details using below API endpoint and found that > backend is giving incorrect symbol. (screenshot attached) > https://demo.openmf.org/fineract-provider/api/v1/currencies? > tenantIdentifier=default&pretty=true > > I then replicated this on my local machine using staging database dump > shared with me by Sampath. Because staging database had correct symbol, > correct result was received from API(screenshot attached). > > I request community members who has access to the database to kindly run > these queries. > > 1. > *UPDATE `m_currency` SET display_symbol = '₹' where code = 'INR' * > 2. *UPDATE `m_organisation_currency` SET display_symbol = '₹' where > code = 'INR'* > > > After running these queries ISSUE : FINERACT-547 should be resolved. > -- > RAHUL GOEL > >
