Countries

Countries are used throughout the application including the importing process, countries of origin and manufacture for your suppliers, and addresses. A default list of countries are loaded into Merchandising on initial installation, however modifications can be done to the list to add new values, remove values that are not used, and update descriptions. Countries are maintained through the upload/download process. This functionality is accessed from the main Merchandising task list under Foundation Data > Download Foundation Data and Foundation Data > Upload Foundation Data.

To add, update, or remove a country, select the template type of Foundation from the Download Data screen and then the template Countries. 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.

Add a Country

To add a new country, select the action type of Create on an empty row on the Countries tab. Next enter up to a 3 digit code for the country, along with the country description in the primary language of up to 120 characters. The other columns in this table will generally be the same for all countries, outside of Brazil. It is recommended they be set as follows if adding a country other than Brazil:

Adding a country translation can be done in a similar manner from the Country Translations tab. This facilitates the ability to translate the country description in multiple languages.

• Localized Ind = No

• The following will be automatically set as follows, as they are only used when implementing in Brazil (specialized tax type):

  • Item Cost Tax Include = No

  • Default Purchase Cost = Base Cost

  • Default Deal Cost = Base Cost

  • Default Cost Comp Cost = Base Cost

• Default Location and Default Location Type can be left blank

Adding a country translation can be done in a similar manner from the Country Translations tab. This facilitates the ability to translate the country description in multiple languages.

Update a Country

If you would like to update any details for countries, a similar process will be followed as that described above for creating new. First, download the spreadsheet, and then navigate to the tab where you would like to make your updates.

The following columns can be updated in each tab:

• Countries - Country Description, Localized Ind, Default Location, Default Location Type

• Country Translations - Description

The columns Item Cost Tax Include, Default Purchase Cost, Default Deal Cost, and Default Cost Comp Cost on the Countries tab are not used.

In the tab where you are going to make your updates, select the action type of Update, and then correct the value in the spreadsheet.

Remove a Country

If you wish to remove a country, select the Delete action on the row of the country you which to delete on the Countries tab. Removing a country translation can be done in a similar manner on the Country Translations tab. Note that removing a country is not allowed if it is still in use.

Upload 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, you'll again select the template type Foundation and the template Countries. 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.