3173103 - How do currency conversion rates work?

• Need to understand how currency conversion rates are defined and maintained in SAP Ariba Buying and Invoicing, SAP Ariba Purchasing and Receiving, and Sourcing.
• Want to know how to export the Currency Conversion Rates file from Site Manager and where to find it in Sourcing-only versus integrated realms.
• Clarify the meaning of file columns (FromCurrency, ToCurrency, Rate, UniqueName, Date) and how effective dates control rates over time.
• Determine how rates synchronize between Upstream and Downstream when the Application.AQS.EnableCurrencyConversionRateSetSync parameter is enabled.
• Understand automatic inverse rate calculation and its exception for Exchange Rate Sets in sourcing events.
• Learn accepted date formats, default time zone behavior, and common formatting pitfalls.
• Assess performance considerations such as using CSV for large datasets and Excel row limits.
• Verify behavior for multi-currency bidding in Sourcing events and the need to update rates upstream.
• Identify propagation timing to sourcing in non-integrated suite setups after data load. 

SAP Ariba Buying and Invoicing

SAP Ariba Purchasing and Receiving

exchange rates, convert, conversion, foreign exchange, FX rates, currency mapping, rate maintenance, inverse conversion, non-triangulated rates, effective dating, Pacific time zone default, UniqueName column, synchronization parameter, suite integration realm, import export task, Site Manager navigation, CSV performance, Excel row limit  , KBA , migration source: knowledge@ariba , 12s1 , 9r2 , 9r1 , migrated on: 2022-04-02 14:23:32 , BNS-ARI-GS-EVT-CUR , Guided Sourcing Event Currency Issues , BNS-ARI-GS-EVT-ADE , Guided Sourcing Event administration , BNS-ARI-SS-EVT-CUR , Sourcing Event Currency Issues , BNS-ARI-CP-CORE , Core Administration , How To