Hi Arun , I checked PartyAcctgPreference which was USD and changed it to INR yesterday only. After changes i do logout and login and restart the tomcat to ensure there are no caching issues.
ofbiz_redgrape=> SELECT PTYACCPREF.PARTY_ID, PTYACCPREF.BASE_CURRENCY_UOM_ID, PTYGROUP.GROUP_NAME, PTYROLE.ROLE_TYPE_ID FROM (ofbiz.PARTY_ACCTG_PREFERENCE PTYACCPREF INNER JOIN ofbiz.PARTY_GROUP PTYGROUP ON PTYACCPREF.PARTY_ID = PTYGROUP.PARTY_ID) INNER JOIN ofbiz.PARTY_ROLE PTYROLE ON PTYACCPREF.PARTY_ID = PTYROLE.PARTY_ID WHERE (((PTYROLE.ROLE_TYPE_ID = 'INTERNAL_ORGANIZATIO'))); -[ RECORD 1 ]--------+---------------------------------- party_id | Company base_currency_uom_id | INR group_name | REDGRAPE TECHNOLOGIES PRIVATE LTD role_type_id | INTERNAL_ORGANIZATIO The relevant field ProductStore is also INR https://pastebin.com/raw/mM2j6kiE ...... requirement_method_enum_id | order_number_prefix | default_locale_string | en_US default_currency_uom_id | INR default_time_zone_string | Asia/Kolkata default_sales_channel_enum_id | allow_password | Y ......... regds mallah. On Thu, Aug 31, 2017 at 11:05 AM, Arun Patidar < [email protected]> wrote: > 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 <[email protected]> > 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 <[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. > > > > > >
