How to change Base currency in MSP

How to change Base currency in MSP

By default, once you set Base currency under SSP, and as long as you create a new PO the base currency is editable under SSP, as well as under Currency. Once you create a new PO, then the base currency is not editable from UI. The same can be achieved using DB queries.


NOTE: Please take a full backup of the application before proceeding with the below steps.

Please connect to  database by following the instructions from the below link,


Once if you are connected please execute the below queries one after the other,

To get currency code, go to Reports--> New Query Report and execute the below query.

select * from currency

You'll have to capture the required base currency value which needs to be set.

For MSSQL DataBase:

Run the below query one by one.

update Currency set BASECURRENCY = 1, EXCHANGERATE = 1, FREQUENTCURRENCY = 1 where CURRENCYCODE = '<CurrencyCode of required base currency >'

update Currency set BASECURRENCY = 0, EXCHANGERATE = 0, FREQUENTCURRENCY = 0 where CURRENCYCODE = '<CurrencyCode of current(wrong) base currency>'

update VendorDefinition set CURRENCYID = (select CURRENCYID from Currency where CURRENCYCODE = '<CurrencyCode of required base currency>')

update POVendorCurrency set CURRENCYID = (select CURRENCYID from Currency where CURRENCYCODE = '<CurrencyCode of required base currency>')


For Postgres DataBase:

Run the below query one by one.

update Currency set BASECURRENCY = true, EXCHANGERATE = 1, FREQUENTCURRENCY = true where CURRENCYCODE = '<CurrencyCode of required base currency >'

update Currency set BASECURRENCY = false, EXCHANGERATE = 1, FREQUENTCURRENCY = false where CURRENCYCODE = '<CurrencyCode of current(wrong) base currency>'

update VendorDefinition set CURRENCYID = (select CURRENCYID from Currency where CURRENCYCODE = '<CurrencyCode of required base currency>')

update POVendorCurrency set CURRENCYID = (select CURRENCYID from Currency where CURRENCYCODE = '<CurrencyCode of required base currency>')


After executing the above queries please restart ServiceDeskPlus-MSP service and check.

      New to ADManager Plus?

        New to ADSelfService Plus?

          Resources

              • Related Articles

              • Change icons for the buttons in SSP

                To change the default icons for the buttons available under SSP, To change the Triangle icon for I am facing an issue, and similarly for the other two options, login to the application as an administrator, goto Admin- Self service portal settings, ...
              • Rename MSP shown in browser tab

                To rename the default name ServiceDeskPlus-MSP shown in the browser tab, edit the file named Rebrandinfo.xml present in the path, ServiceDeskPlus-MSP\Conf In the file rename ServiceDeskPlus-MSP to the desired text you want to display in the browser ...
              • Change Auto closure

                This will be helpful in auto closing change request after X days it is in review stage. This use case is more suitable in environments where ONLY Requesters (customers) are the Change Reviewers and they want the Change to be closed if no review is ...
              • Script to bulk close change using deluge script based on the status

                The following script will help you bulk close changes based on the status of change using custom schedules 1. Go to Reports tab --> New query report --> copy the query to the query editor and run the report. Save the report in the folder. The query ...
              • How to provide EDIT access to other technicians for the reports created by others or Admins ?

                Applicable for both 9.4 and 10.5 users. Please Make use of the below update query to provide the Edit option under Report for Users other than SD-Admin Role : Kindly connect to the database and execute the query below UPDATE GLOBALCONFIG set ...