Realized Sales Upload is a monthly process executed by CRM Team in iCARe for SpP GBU.
1 - Business opens a ticket with 2 excel files containing the realized sales to insert and the exchange rates to update
2 - Update currency rates with type Realized Sales
2.1 - Execute the following query and extract the information into an excel file
select id, Target_Currency__c, Type__c, Exchange_Rate__c from BW_Exchange_Rate__c where Type__c = 'Realized Sales'
2.2. - Open the file Exchange rates. Map by currency to get the corresponding SF Ids. Remove the rows without Ids. Make sure the exchange rate value doesn't have comma.
Prepare the file with SF Ids and exchange rates. Use the columns F (Id) and Exchange Rate (G) to perform the update in the table BW_Exchange_Rate__c.
3 - Update the realized sales
3.1 -