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 ...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 ...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 ...Close change requests using custom schedules.
This post describes the use of a python script to close change that are in a specific stage using Custom Schedules. Use Case: There may be a scenario where number of old Change Requests that have gotten lost in the shuffle over the years. Most of ...How to create a change automatically based on a schedule
This is a sample python script that triggers the creation of a Change Request in ServiceDesk Plus using the Change API based on a schedule Note: Attached script will not work beyond 11138 SDP Version. A short guide on setting up python is ...