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
Overview: Automatically creating projects in Zoho Projects based on the changes in SDP MSP keeps everything in sync without manual updates. This means all tasks and updates on a Change are automatically reflected in Zoho Projects, making it easier to ...To change Solutions tab title to knowledge base
C:\SupportCenter\server\default\lib\classes\resources\ApplicationResources_en_US.properties Copy above file and put it under C:\ManageEngine\SupportCenter\custom\i18n. Change the key ' sdp.header.solutions=solutions' to ...Risk Matrix for Change using Custom Module
Overview: A risk matrix helps in identifying risks based on how likely they are to happen and how serious their impact could be. This makes it easier to decide which risks need urgent attention and which ones can be watched over time. It helps manage ...Change Risk Assessment Questionnaire using Custom module - Implementation steps
We’re excited to share a step-by-step guide( Attached) on implementing a Change Risk Assessment Questionnaire in ServiceDesk Plus using the Custom Module feature. This solution leverages Custom Modules, Change Additional Fields, and Field & Form ...