1. OBJECTIVE AND SCOPE
The purpose of this document is to describe the monthly process to update "reel" exchange rates in BFC.
2. Quantum files
Quantum is the Treasury system managing centrally Solvay official exchange rates and distributing them across the SAP applications.
On the last working day of the month, Quantum (QUANTUM-Solvay@avantgardportal.com) automatically sends 4 emails (one per each file) to BFCAdmin-ext@solvay.com with the following subjects:
- QUANTUM : YYYY.MM Rates Interface for BFC contains YYYY.MM_BFC_Rates_Interface_FromQT.txt file
- QUANTUM : YYYY.MM Monthly Rates for BFC contains YYYY.MM-BFC_MonthlyRates_FromQT.xls file
- QUANTUM : YYYY.MM Quarterly Rates for BFC contains YYYY.MM-BFC_QuarterlyRates_FromQT.xls file
- QUANTUM : YYYY.MM Year's Rates for BFCcontains YYYY.MM-BFC_YearRates_FromQT.xls file
3. BFC upload
The file YYYY.MM_BFC_Rates_Interface_FromQT.txt received from Quantum has the correct format ready to be uploaded in BFC.
3.2 Create REEL YYYY.MM table in BFCTop
Before being able to upload YYYY.MM reel exchange rates from the txt file we need to create the table in BFC.
From the previous period do a Save as.
Save the new table 
and close.
Open the new table
Select all lines, except the frozen rates, and press DELETE to erase previous month rates.
3.3 Upload Quantum file
Upload YYYY.MM_BFC_Rates_Interface_FromQT.txt file
6 lines expected to be rejected: Currency CNH not created in BFC table.
Save the table
3.4 Run excel retrieval file to check consistency
3.5 Pilot to FCProd
To pilot REEL exchange rates Task EXPL-ADMIN should be used.
