Realized Sales Upload is a monthly process executed by CRM Team in iCARe for SpP GBU. In the current month, we load the realized sales from the previous month.
There are two main steps, first update the exchange rates, second update the existing realized sales and insert the new realized sales provided by the business.
The realized sales are present in the table Sales__c and the exchange rates are saved in BW_Exchange_Rate__c.
Original document about this process:
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 - Load the new realized sales
3.1 - Go to the report - https://syensqo-icare.lightning.force.com/lightning/r/Report/00ORf000002uYM1MAM/view?queryScope=userFolders and extract the data into an excel file.
Note 1: do not change the Realized Sales Created Date filter. It's always Feb 1st 2026, until Feb 2027. In March 2027, we change the report filter to February 1st 2027.
In February month we do not load Realized Sales. It means that in Feb 2027 we skip this step 2.
Note 2: to guarantee that only RS are exported, we must have the filter billing type = ''
3.2 - For the records extracted, run the following updates:
3.2.1 - Update realized sales with flag BWX_Update_Flag__c = 0
3.2.2 - Update realized sales with flag BWX_Update_Flag__c = 1
3.3 - insert realized sales from the business file into the system
3.3.1 - map the columns with SF api names (mapping in this file - row #2)
add two new columns into the file:
Rolling_12__c = true
GBU__c = SP
Perform the product mapping - extract all the active products in the system and map with Product_r: Material_group__c to get the product id for every realized sales row
| Calendar Year/Month | Company Code | Company Name | Material | Material Name | Material Group_P | Product Name | Material Sales Text | Region of the Manufacturing Plant | Sold-to party | Sold To Party Name | CRM ID | Country of Sold to party | Region of Sold to Party | Ship-to party | Ship to party Name | Ship-To City | Ship-To Region | Payment Term | Document Currency (DC) | Final Consignee CRM ID | Netv_local_currency_CY__c | Qty in docu unit - ACT | Budget Volumes (KG) | Budget Sales (€) | Fcst ICM [Est Act] (€) | Fcst Unit ICM [Est Act] (€/KG) | Netv in EUR - ACT | Netv in loc curr - ACT | Netv in docu curr - ACT | Rolling 12 | GBU | |
| Calendar_year_month__c | _ | Solvay_Company__c | Material__c | Material_Name__c | Product__c | Product_r: Material_group__c | Commercial_Product_Name__c | Sales_Material_Name__c | _ | Sold_to_Party__c | _ | Account__c | Country_of_Sold_to_Party__c | Region_Sold_to_Party__c | Ship_to_Party__c | _ | Ship_To_City__c | Ship_To_Region__c | Payment_Terms__c | Doc_currency__c | Final_Consignee__c | Local_Currency__c | Quantity_Local_CY__c | _ | _ | _ | _ | Netv_EUR_CY__c | Netv_local_currency_CY__c | Netv_Invoice_Currency__c | Rolling_12__c | GBU__c |
Mapping to use in Data Loader:
3.3.2 - check if all the records have a product linked, if not, report the lines missing the product to the business
3.3.3 - insert the realized sales (Sales__c) into the system
4 - Update the Realized Sales from same month in the previous year
Example: We are loading the RS from March 2026, in this step we extract the RS from March 2025 (same month, previous year).
4.1 - Export the existing realized sales of the same month from the previous year
extract the realized sales records from this report https://syensqo-icare.lightning.force.com/lightning/r/Report/00ORf000002usZFMAY/view?queryScope=userFolders
Note: to guarantee that only RS are exported, we must have the filter billing type = ''
4.4 - prepare the file with RS Ids and add the column Rolling_12__c as false - example of the file
4.5 - update the Sales__c table with the file from step 4.4
Example of the realized sales file from April 2026 to load RS from March 2026: