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 ADSelfService Plus?
Related Articles
To send an acknowledgement email notifications to change owner for every reply conversation in change.
Overview The below document explains the steps that need to be configured for sending notifications to change owner for every reply conversation in changes. (i.e) When a reply is sent and a conversation is added to a change then the acknowledgment ...Integrating Zoho Projects with SDP MSP change management
PURPOSE: When a change is created or edited as required, a project is created in Zoho Projects respectively. Here is an example of creating a project in Zoho Projects when a change is created under a specific site in SDP MSP. TESTED IN MSP BUILDS: ...Risk Matrix for Change using Custom Module
PURPOSE: Creating Risk matrix for changes that automatically calculates the risk of a change based on its priority and impact. Similar to the Priority matrix in the request module. TESTED IN BUILDS: 14504 STEPS: Step 1: Configure the Custom Module: ...Change Account for requester and in requests (Not applicable for builds above 9416 due to behavior change)
If the intent is to move a request from one account to another, you will have to first move the requester to the correct account, and then you will be able to change the account in the requests. 1. Go to Admin - > Account details - > Requesters. Go ...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, ...