Automatic Export and Import of Exchange Rates and Indexes in SAP Business One

Hello everyone, and welcome to the topic Automatic Export and Import of Exchange Rates and Indexes in SAP Business One.

There are many customers who are having multiple companies running on the single database server on SAP Business One for which they maintain Exchange Rate on day to day basis for each company. The SAP Business One allows us to export and import exchange rate from one company into another company which minimizes the manual data work of users.

Use the below procedure to automatically export and import foreign currency exchange rates and indexes, from one company to another in SAP Business One.

Prerequisites

The database of the source (exporting) company and that of the target (importing) company are both stored on the same database server.

                    Target Company                                                       Source Company

Above picture shows that Exchange Rate  for Target Company is not maintained whereas Exchange Rate for Source Company is maintained.  

Procedure

1. Enter the company from which you want to perform the export.
2. Choose  Administration >>  Exchange Rates and Indexes  and select either the Indexes or Exchange Rates tab, according to the data you want to export.
3. From the drop down list, choose the required year; and on the Exchange Rates tab, the month, so the data you need to export is displayed.
4. Select the columns you want to export by clicking their headers. Use either the Ctrl or Shift function to select multiple columns.
   Choose Auto. Export.

            

  5. Choose Continue when the following message appears: Export selected exchange rates/indexes to the common table? Choose "Yes".

                                                       

     6. Choose Administration >> Choose Company >>, and select the company to which you want to            import the data.

    7.  In the Define Foreign Currency Exchange Rate window, select the relevant tab.
    8.  Select the columns to which the data should be imported, and then choose Auto. Import. The               exported values are now displayed in the selected columns.

 

Finally, your exchange rate data will be copied to Target Company.

                                                                 Target Company

Note:

You import data only for the same columns as those from which the export is done. 

Thanks for visiting.

Post your queries in comment box.