EduPerea737 Posted March 31, 2017 Share Posted March 31, 2017 Hi, I've been handling all my customers and invoices with COP currency, and I have several customers and several invoices indeed. So, I want to change current defauld currency (USD) for (COP), could it be some problem with previous transactions and invoices? Thanks 0 Quote Link to comment Share on other sites More sharing options...
twhiting9275 Posted March 31, 2017 Share Posted March 31, 2017 Previous invoices and transactions shouldn't be affected, no. However, if you switch, then future transactions will be affected. It's likely that's what you want anyways 0 Quote Link to comment Share on other sites More sharing options...
EduPerea737 Posted March 31, 2017 Author Share Posted March 31, 2017 So, I think I have to change all my customers currency selection, right? 0 Quote Link to comment Share on other sites More sharing options...
twhiting9275 Posted March 31, 2017 Share Posted March 31, 2017 Correct. The fastest way to do this would be with a MySQL query. Take a look at the query docs and the laravel query docs . You want to update 'currency'in tblclients to use the new value (this will be numeric) 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted April 1, 2017 Share Posted April 1, 2017 Previous invoices and transactions shouldn't be affected, no.However, if you switch, then future transactions will be affected. It's likely that's what you want anyways I don't think that's correct advice - if you change a users currency, then it will have an impact on both their old and new invoices... the advice posted on here for many years, by both WHMCS staff and experienced users, is that you shouldn't change a client's currency. e.g if the client has an old invoice for $100 USD, and you change their currency to COP - the old invoice will now appear to be for $100 COP... and I think there's a BIG exchange rate difference between the two currencies. you might be able to get around that by using an addon, e.g Cached Invoices - but if it were me, I wouldn't change their currency. 0 Quote Link to comment Share on other sites More sharing options...
EduPerea737 Posted April 3, 2017 Author Share Posted April 3, 2017 I don't think that's correct advice - if you change a users currency, then it will have an impact on both their old and new invoices... the advice posted on here for many years, by both WHMCS staff and experienced users, is that you shouldn't change a client's currency. e.g if the client has an old invoice for $100 USD, and you change their currency to COP - the old invoice will now appear to be for $100 COP... and I think there's a BIG exchange rate difference between the two currencies. you might be able to get around that by using an addon, e.g Cached Invoices - but if it were me, I wouldn't change their currency. That is true but in my case, I didn't have that problem because I changed all, so when I change my default currency from USD to COP, all my previuous invoices whas changed to USD, for example 85000 COP was turned into 85000 USD, so then, wheh I changed customer currency choice, it turn again into 85000 COP 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.