Status

DRAFT

Release date


Issues

Last modified dateLast modified byComment
Romain BABLOT

 

Creation



1/ Summary


This objective of this page is to describe step by step the process of update the Salesforce Exchange rate based on the SAP data.

This process is trigger by the business to create Service One ticket to request the update


2/ Prerequisite

1/ This process is triggered by a business user that request the update of the Salesforce exchange rate. Click Here to review the process to create that request

2/ User that will perform this process must have the following access : 

  • Access to BW query : BW_QRY_DAFICE01_0001 

  • Access to Salesforce as an Admin in order to be able to update following salesforce object : 

    • CurrencyType

    • DatedConversionRate

  • Access to Salesfroce Connecte


3/ Update Process

Step 1

Access the BW Query : BW_QRY_DAFICE01_0001 and extract its content to a GSheet.

From the Service One request, identify if the Yearly or the Monthly rate has to be updated. (select the correct step 2)

Step 2 - Monthly rate Update

Weare going to prepare the file to be loaded in UAT & PROD.

UAT & PROD must be setup in the same time.


2.1 / From that GSheet connect it with Salesforce PROD in order to retreive the following data : 

  • Sheet 1 : PROD - CurrencyType
    • SOQL : select id,IsoCode,ConversionRate  from CurrencyType 
  • Sheet 2 : UAT - CurrencyType
    • SOQL : select id,IsoCode,ConversionRate  from CurrencyType 


2.2 / Map the new ConversionRate field from the BW Extract based on UAT Sheet & in PRD Sheet : 

  • CurrencyType.IsoCode = BWQuery.ISOCode
  • BWQuery.CAR3 will be the new conversion rate


2.3 / Run the update  via the Salesforce inspector in UAT then in PRD.



2.4 / Close the Service One Request.

Step 2 - Yearly rate Update

Weare going to prepare the file to be loaded in UAT & PROD.

UAT & PROD must be setup in the same time.

In case of Yearly Rate, the Service One request need to provide a Start date.


2.1 / From that GSheet extract the following in order to create a new Sheet : 

  • BWQuery.ISOCode  ==> Column name : "IsoCode"
  • BWQuery.CAR4 ==> Column name : "ConversionRate"
  • new Column ==> "StartDate" = date provided in the Service one request


2.2 / Copy the new sheet in Salesforce Inspector Import in order to INSERT new Records.

Do it first in UAT, then PRD




2.3 / Close the Service One Request.