Hello Rajesh, ProductStore and PartyAcctgPreference entities also have fields to store currency UOM.
-- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development HotWax Systems Pvt Ltd. www.hotwaxsystems.com On Thu, Aug 31, 2017 at 9:17 AM, Rajesh Mallah <mallah.raj...@gmail.com> wrote: > looks like too many messages has already been > exchanged in past at various point in time. > > http://ofbiz.markmail.org/search/?q=changing+default+ > currency#query:changing%20default%20currency > > it will be beneficial to new users if it is given attention . > > regds > mallah. > > > On Thu, Aug 31, 2017 at 8:01 AM, Rajesh Mallah <mallah.raj...@gmail.com> > wrote: > > > > > > > > > @Deepak , @Rishi / List , > > > > Additional SQL tracing reveals that the ProductPricing > > entities are being queried with CURRENCY_UOM_ID=USD > > and hence the USD pricing is being picked up. I am not sure > > why USD currency is being picked. I have changed in almost > > all places including properties file. > > > > -- ./framework/common/config/general.properties > > > > # -- unique instance id (20 char max) > > unique.instanceId=ofbiz1 > > # -- the default currency to use for prices, etc > > currency.uom.id.default=INR > > # These values override the _NA_ DEFAULT values in user preferences for > > the GLOBAL_PREFERENCES userPrefGroupTypeId > > # -- the default organizationPartyId for used in dropdowns and reports > > > > > > 2017-08-31 07:52:15,412 |http-nio-8080-exec-9 |GenericDAO > > |T| Ran query in 1 milli-seconds: EntityName: ProductPrice > > Sql: SELECT PRODUCT_ID, PRODUCT_PRICE_TYPE_ID, PRODUCT_PRICE_PURPOSE_ID, > > CURRENCY_UOM_ID, PRODUCT_STORE_GROUP_ID, FROM_DATE, THRU_DATE, PRICE, > > TERM_UOM_ID, CUSTOM_PRICE_CALC_SERVICE, PRICE_WITHOUT_TAX, > PRICE_WITH_TAX, > > TAX_AMOUNT, TAX_PERCENTAGE, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID, > TAX_IN_PRICE, > > CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, > > LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > > CREATED_STAMP, CREATED_TX_STAMP FROM ofbiz.PRODUCT_PRICE WHERE > > ((PRODUCT_ID = ? AND (PRODUCT_PRICE_PURPOSE_ID = ? OR > PRODUCT_PRICE_PURPOSE_ID IS NULL) > > AND CURRENCY_UOM_ID = ? AND PRODUCT_STORE_GROUP_ID = ?)) > > ORDER BY FROM_DATE DESC > > > > where clause:[PRODUCT_ID=10000, PRODUCT_PRICE_PURPOSE_ID=PURCHASE, > > CURRENCY_UOM_ID=USD,PRODUCT_STORE_GROUP_ID=_NA_] > > > > Full Log: > > https://pastebin.com/raw/smdQX84B > > > > > > Looking forward to further comments and > > guidance. > > > > ​regds > > mallah. > > >