Manage Entity Exchange Rate Configuration

Merchandising and Trade Management provide the option to configure which date to use when determining the exchange rate to use for certain transactions. This configuration also allows you to determine whether or not the entities exchange rate should be used or ignored. For example, if an exchange rate is entered on a purchase order, you can determine if that rate should be used or the one in the currency exchange rate table based on the date configuration. This table is seeded initially, but can be updated as needed to support your business. The following entities support configuring the date to use for currency exchange rates:

Table 5-1 Manage Entity Exchange Rate Configuration Options

Entity	Exchange Rate Date Options
Merchandising
Order Cost	Transaction Date*, Original Order Approval Date
Order Expenses	Transaction Date*, Original Order Approval Date
Trade Management
Order Assessments	Transaction Date*, Original Order Approval Date
Transportation	Commercial Invoice Date*, Finalized Date
Customs Entry	Entry Date*, Confirmed Date
Letter of Credit	Application Date*, Confirmed Date
Obligations	Obligation Approval Date, Invoice Date*, Paid Date

* Initial system default

The configuration for this function is accessed through the main Merchandising task list under Foundation Data > Download Foundation Data and Foundation Data > Upload Foundation Data. To update the configuration, you will select the template type of Finance Administration from the Download Data screen and then the template Entity Exchange Rate Configuration. Click the Download button and when prompted, choose to either open the .ods file that is generated or save the file and open it separately in the spreadsheet application of your choice. Once opened, there will be one sheet that can be modified - Entity Exchange Rate Config.

Update Entity Exchange Rate Configuration

If you would like to update the exchange rate date used for any of the above entities, download the spreadsheet, and then navigate to the row where you would like to make your updates and choose the action type of Update.

The following columns in the worksheet can be updated:

Ignore Entity Exchange Rate - this can be set to Yes or No, depending on whether you want to use the exchange rate on the entity or use one in the exchange rate table based on the date configuration. The default for all entity options is No.
Exchange Rate Date - indicate the date you want used for an entity. Valid values are based on the table above.

Uploading Changes

For all actions defined above, once all the updates have been made to the data in the spreadsheet, save the file and close it. Then, return to the Merchandising screens and select Foundation Data > Upload Foundation Data from the main task list. In this screen, select the template type Finance Administration and the template Entity Exchange Rate Configuration. This will generate a process description automatically, but this can be updated if desired. Lastly, select the Browse button and navigate to the directory where you saved the updated spreadsheet.

To review the status of the upload and check whether any errors occurred, select the Foundation Data > Review Status task from the main task list.

See also Download/Upload Data from Spreadsheets in the Oracle Retail Merchandising Do the Basics User Guide.

Currency Cross Reference

Currency Exchange Type mappings exist as a cross reference between the Merchandising currency types and those maintained in an external financial system, if they differ. This cross reference is used when importing current exchange rates from the financial system, where the financial system may maintain a different exchange type than is used in Merchandising. Updates to these mappings can be made through spreadsheet download and upload processes. These processes are accessed through the main Merchandising task list under Foundation Data > Download Foundation Data and Foundation Data > Upload Foundation Data.

To update currencies exchange type mappings, you will select the template type of Finance Administration from the Download Data screen and then the template Currency Exchange Type Mappings. Click the Download button and when prompted, choose to either open the .ods file that is generated or save the file and open it separately in the spreadsheet application of your choice. Once opened, there will be one sheet that can be modified - Currency Exchange Type Mapping.

Update a Mapping

Currency exchange type mappings can only be updated. It is not permitted to add new or delete existing rows. To update existing mappings, first download the spreadsheet. In the Currency Exchange Type Mapping sheet all existing cross reference values will be displayed. To update an existing record, select the action type of Update for the row being updated. Both the External Exchange Types and RMS Exchange Types columns may be updated but both are required.

Uploading Changes

For all actions defined above, once all the updates have been made to the data in the spreadsheet, save the file and close it. Then, return to the Merchandising screens and select Foundation Data > Upload Foundation Data from the main task list. In this screen, select the template type Finance Administration and the template Currency Exchange Type Mappings. This will generate a process description automatically, but this can be updated if desired. Lastly, select the Browse button and navigate to the directory where you saved the updated spreadsheet.

To review the status of the upload and check whether any errors occurred, select the Foundation Data > Review Status task from the main task list.

For more information, see "Download/Upload Data from Spreadsheets" in the Oracle Retail Merchandising Do the Basics User Guide.