SAP Currency Rate Replication

SAP Currency Rate Replication replicates SAP currency exchange rates into the Salesforce currency rates. All currencies are paired with your Salesforce organization’s master currency. The rate for each pair is retrieved from SAP using the currency defined in Transaction OC41 (Maintain Exchange Rates).

Two integration scenarios are created as part of this component - ovcSapCurrencyRate and ovcSfdcCurrencyRate.  ovcSapCurrencyRate fetches Currency Exchange Rate from SAP and maps it to the intermediate integration object ovcSfdcCurrencyRate_DatedConversionRate__c. The mapping is passed to the ovcSfdcCurrencyRate scenario which then calls a SOAP API to write to the Salesforce DatedConverionRate object where currency rate is maintained. ovcSfdcCurrencyRate scenario requires a new connection string to be created during the activation process as described in Steps 4 and 5 below.

Pre-requisites

SAP Currency Rate Replication requires Salesforce features related to Multiple currencies and Advanced Currency Management to be enabled. Please refer to the below Salesforce help links and Overcast help links before proceeding to activate the component.

1. Manage Multiple Currencies

2. Advanced Currency Management

3. Currency Rate SFDC Object DatedConversionRate: Insert or Update only. If start date exists already, Insert will fail.

4. Connection String for Salesforce: This component requires a connection string of type Salesforce to make the SOAP API call and update the DatedConversionRate object in Salesforce. Please note that it is type Salesforce, and not Salesforce Job.

Installation

1. Navigate to the Component Library in the Overcast App. Filter by SAP-integrated Quotes & Orders under Collections.
   
    
2. Search for SAP Currency Replication component and activate it by selecting the blue Activate button. (Once activated, the panel will appear green).
   
    
3. Select Activate.
   
    
4. Go to Integration Scenarios tab, open ovcSfdcCurrencyRate scenario. Select Edit and assign the connection string of type Salesforce to this scenario, which you have established in Pre-Requisites No.4. Scroll to the bottom of the screen and select Save & Activate.
   
    
5. Navigate to the Monitoring Tab and check the Status. A green circle indicates that the component is successfully activated and is ready to use. If you see a red circle indicating an error, navigate to the ID (eg. 00001) and see Detailed Log for information regarding error. Go to Monitoring pages for more information.
   
    
6. Navigate to Setup and search for Custom Metadata Types. Click Manage Records next to ovcCurrencyRate.
   
    

7. Click Edit against the sample record that was created during activation or click New to create a new entry.
   
    

8. Tweak the following input parameters that will be used during the BAPI call out, and then click Save.
   Label = Name the Label as you wish (Example: '2022 Rates')
   DateKey = today  -- *user customizable (Example: '20220101') 
   Date_type = V or E
   Type 'V': All exchange rates are read that are valid "on" today (or 01.01.2022 as an example) 
   Type 'E': All exchange rates are read that are valid "from" today  (or 01.01.2022 as an example) 
   Rate_type = M 
   
    

9. Navigate to Integration Scenarios and search for ovcSapCurrencyRateRep scenario. Select Run.
   
    

10. Select your Scenario Input that was set up in step 8 and select Run for Action Type. Click Run scenario. 
    
     

11. Navigate to Setup and search for Manage Currencies. Select Manage Dated Exchange Rates and click Continue.
    
     

12. Check if Dated Exchange Rates have been updated.
    
     

13. You can schedule the scenario to run repeatedly at specific times, which will update SAP currency rate automatically in Salesforce. Select the scenario ovcSapCurrencyRateRep from Integration Scenaraios tab. Scroll down to Schedule Job and select the JOB NAME DatedCurrencyRateReplication.
    
     

14. Scroll down to Scheduled Tasks and select Edit next to DatedCurrencyRateReplication. 
    
     

15. Input the Scenario Input, which is to match the label name you set up in step step 8. Select Save.
    
     

16. Scroll back to the top and select Edit to set up the Scheduled Job Detail. Follow instructions of step 1 & 2 on Scheduling a Scenario. After the set up, make sure to select Schedule this job.