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 <[email protected]> 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. >
