4 Replies Latest reply on Jan 28, 2016 4:04 AM by Christian Steenberg

    How to manage Event Exchange Rates?

    Christian Steenberg Expert

      Hi,

      New to sourcing and I'm struggling with the Exchange Rate concept.

      We have Upstream and Downstream on demand site.

      I can load currencies via "Import Currency Conversion Rates (CSV)".  But nothing happens for Event Exchange Rate Sets.

      How do I update the default rates in "System Currency Conversion Rates"?

      At the moment it holds rates from 1999.  Also - how do I add/remove currency pairs to the "System Currency Conversion Rates" list?  I know that I can create a new Exchange Rate set and enter pairs and values, but that doesn't seem like a good option if I have to maintain lots of pairs and update them regularlypai

      Any suggestions are welcome, Chr

        • Re: How to manage Event Exchange Rates?
          David Morel Master

          You update the currency rates in Admin then choose a new set in the event.  You might have to enable the setting of currency rates in the template before you gain access to them in your event. Check out the documentation available via the Help link in the solution and contact support if you still have questions.

           

          David Morel

            • Re: How to manage Event Exchange Rates?
              Christian Steenberg Expert

              Thanks David,

              I’ve checked the documentation. I still can’t get it to work. Currency Rates are not updating, I keep seeing the rates from 1-Jan-1999.

               

              Document: "Common Data Import and Administration Guide"

              Chapter "Defining Currency Conversion Rates", page 11.

              “As part of the enablement book currency rates are loaded to Ariba with FromCurrency, ToCurrency, Rate.”

              Since the enablement of the site used we have used data import.

               

              Further on import of data I found this:

              Chapter "ImportingYour Data", page 21-22.

              “After you enter your data in the appropriate data worksheets, you can import it using the data import tasks available from Site Manager in Ariba Administrator.

              Context

              These steps are for importing data that does not require translation. For information on importing translations, see Importing Translations for Units of Measure or Commodity Codes.

              1. Log in to your site using your administrator username and password.
              2. Choose Common Actions > Administrator.
              3. In Ariba Administrator, choose Site Manager > Data Import/Export.
              4. Click Import next to the data import task you want to run.

               

                   Task: “Currency conversion rates” - “Import Currency Conversion Rates”.

               

              On Ariba Connect,  I’ve read the blog entry “Currency Conversion Rates: How They Work and How to Upload Them”,

              https://connect.ariba.com/AC_ATC_Blog_OD/1,,MDAxNzk0NTQyNA==,00.html#Article&152676

              “Currency conversion rate is defined in a Microsoft Excel or comma-separated value (CSV) file that you can export through the Data Import/Export task:

              • For a sourcing-only realm, you can export the file by going to Manage > Administration > Site Manager > Data Import/Export > Export tab > search for currency.
              • For an integrated realm/integrated suite, it appears in Manage > Core Administration > Site Manager > Data Import/Export > Export tab > search for currency.
              • Everything defined in this file also appears in the sourcing side (Sourcing, Manage > Administration). If you upload new rates here, they appear in the sourcing side.

              The file consists of five columns:

              • FromCurrency: Defines the currency from which to convert the value.
              • ToCurrency: Defines the currency into which to convert the value.
              • Rate: Rate that system will use to convert.
              • UniqueName: Used when you want to overwrite the existing conversion rate in procurement (not a mandatory column). If you are importing new rates, you can leave it blank. In sourcing, you do not even have to define this column in a file.
              • Date: Defines when the rate becomes effective. This is the most important column in a file.”

              Additional Information:

              • If you have over half a million records in the currency conversion rate table, exporting to a CSV file is more efficient and faster. Either exporting to Excel may fail or you may run into a row limit.
              • If you upload currency conversion rates in a suite-integrated setup by going to Manage > Administration (in other words, the sourcing side), those rates do not appear in procurement. If you deactivate some rates in the sourcing side, the changes are not reflected in procurement.
              • If you upload currency conversion rates into a child or parent in a non-integrated suite, changes also appear in sourcing within 24 hours following the data load.
              • If you define a rate to convert from EUR to USD, for example, the system automatically inverts it and calculates the USD to EUR conversion rate. For example if you have the EUR to USD rate defined as "2", the system automatically assumes that the USD to EUR rate is equal to "0.5".
              • Date format can be specified with hours or without, based on your preference. The system accepts both.

               

              For sourcing events I checked the document "Event Management Guide".

              Chapter "Creating Multiple Currency Events", page 172.

              "Procedure:

              1. 1. The Multi Currency Rules section expands to show additional options.
              2. 2. You must choose a set of Currency Conversion Rates. An administrator user must initially add these rates. If an administrator user has not performed the initial configuration, you cannot choose a conversion rate set, and cannot add or edit bidding currencies.
              3. 3. After choosing an exchange rate set, you can Edit and adjust the rates. You can remove exchange rate pairs from the event or from specific lines within the event, but you cannot set up new exchange rate pairs that do not exist in the exchange rate set. If you need a currency pair that is not part of an existing exchange rate set, ask an administrator user to create it"

               

               

              So I’ve imported currency exchange rate pairs successfully. I can export them again - the currency data is in Ariba.

              When I select the "System Currency Conversion Rates" in the Event then I’m still seeing the old 1-Jan-1999 pairs and rates. It’s like the table does not update at all. Could it be that a job that copies the data to the Exchange Rate Set isn’t running?

               

              br

              Chr