Country Maintenance

Menu Path: System Administration $Images\bluerarw.gif$ Module Setup $Images\bluerarw.gif$ Country Maintenance

Purpose

Add, edit, and delete countries.

Overview

Use Country Maintenance to define and maintain country codes, country names, and other related settings. Country codes can be up to 10 characters in length. You can assign a harmonization code and other defaults for each country you define. You can also import country codes in Country Import.

For database information for this window, see Country Maintenance Database Information.

Adding Countries

To add a new country:

Click the New button in the ribbon.
Enter the country code in the Country field.
Enter the name of the country in the Country Name field.
Enter a label for all fields in which users will enter state or province information for the country in the State Label field. If the country does not have states or provinces, select the State/Province not Required check box.
Enter a format for phone numbers for the country in the Phone Format field.
Enter a postal code format in the Postal Code Format field, or if the country does not use postal codes, select the Postal Code not Required check box.
Select the Validate Postal Code Against Postal Code Maintenance check box if you want to only allow valid postal codes to be entered for the country.
Enter the ISO code for the country in the ISO Country Code field.
Enter a royalty region for calculating royalties in the Royalty Region Name field.
Enter the default currency for the country in the Default Currency field.
If you will pay excise taxes in the country, enter the supplier to which the taxes will be paid in the Excise Supplier field. Also, If the country requires exported data for all products that are leaving the excise tax suspension regime, enter the Apprise program that will be used to export this data in the Excise Export Procedure field.
If the country uses VAT, select the Use VAT check box, then enter any other applicable VAT settings, including default VAT accounts for the country on the Accounts tab.
Click the OK button in the ribbon. The country is created.

Updating Countries

To update a country:

Enter the country code in the Country field.
Click the Update button in the ribbon.
Update the country information.
Click the OK button in the ribbon. The country is updated.

Deleting Countries

To delete a country:

Enter the country code in the Country field.
Click the Delete button in the ribbon.
Click the OK button in the ribbon. The country is deleted.

Note A country cannot be deleted if it is used anywhere in the system.

Ribbon Home Tab Buttons

Button	Description
Exit	Click this button to close the Country Maintenance window.
New	Click this button to create a new country.
Update	Click this button to update the selected country.
Delete	Click this button to delete the selected country.
Show Data	Click this button to refresh locations displayed on the Inquiry tab. This button is only available if you click the Inquiry tab.
OK	Click this button to accept an action. This button is only available after you click the New, Update, or Delete button in the ribbon.
Cancel	Click this button to cancel an action. This button is only available after you click the New, Update, or Delete button in the ribbon.
First	Click this button to display the first country.
Prev	Click this button to display the previous country.
Next	Click this button to display the next country.
Last	Click this button to display the last country.
Location	Click this button to display Location Maintenance, which allows you to view information about a selected location. This button is only available if you click the Inquiry tab.

Fields and Buttons

Field or Button	Description
Country	Enter a country code, or click the Lookup button to select an existing country code.
Country Name	Enter the name of the country.

Main Tab Fields and Buttons

Field or Button	Description
State/Province not Required	Select this check box if you do not want to require states or provinces to be included in addresses for the country. You should only select this check box for countries that do not have states or provinces.
State Label	Enter the label that appears for a state or province field when the country is selected. This allows you to customize the field so it is specific to the country’s nomenclature. Example For the country of Canada, enter Province because Canada is comprised of provinces.
Phone Format	Enter the format of the phone numbers for the country. Example For the US, the format could be (999)-999-9999 Note Only the character X and/or 9 are used to denote an entry value. X can be any keyboard value. 9 must be a numeric value. All other characters will appear exactly in the field position designated. So, if the format was XXt99, then the t would always appear in the third position of this field, and the fourth and fifth positions must be numbers.
Postal Code not Required	Select this check box if you do not want to require postal codes to be included in addresses for the country. You should only select this check box for countries that do not have postal codes.
Postal Code Format	Enter the format of the postal codes for the country. Example For the US, the format could be 99999-9999. Note Only the character X and/or 9 are used to denote an entry value. X can be any keyboard value. 9 must be a numeric value. All other characters will appear exactly in the field position designated. So, if the format was XXt99, then the t would always appear in the third position of this field, and the fourth and fifth positions must be numbers.
Validate Postal Code Against Postal Code Maintenance	Select this check box to only allow postal codes that have been set up in Postal Code Maintenance to be entered in Customer Maintenance. Example For the US, the format is XXXXX.
ISO Country Code	Enter the International Organization for Standardization (ISO) code for the country. You can enter the two- or three-digit ISO code.
Royalty Region Name	Enter the royalty region for the country, or click the Lookup button to select a royalty region. For information on setting up royalty regions, see Royalty Region Maintenance.
Default Currency	Enter the default currency for the country, or click the Lookup button to select a currency. This field is required if you enter an amount in the Invoice Amount Limit field. For information on setting up currencies, see Currency Maintenance.
Excise Supplier	Enter a valid supplier code to which to pay excise tax for the country, or click the Lookup button to select a supplier.
Name (Excise Supplier)	Enter a valid supplier name to which to pay excise tax for the country, or click the Lookup button to select a supplier.
Excise Export Procedure	If the country requires exported data for all products that are leaving the excise tax suspension regime, enter the Apprise program that will be used to export this data.
Use VAT	Select this check box if the country uses VAT. If you select this check box, purchase orders for a ship-to address in this country default to use VAT. Additionally, sales orders shipped from this country to a ship-to location in this country default to use VAT. However, you can override this setting for a specific purchase or order class. Note This check box is only available if Show is selected for the VAT Display Level field in Tax Control Maintenance.
VAT ID	Enter your company's VAT ID for the country, or click the Lookup button to select a VAT ID. For information on setting up VAT IDs, see VAT ID Maintenance.
Description	This field displays the description of the entered VAT ID.
VAT Due Days	Enter a number of days before vouchers expire if VAT invoices for the country have not been approved. This field default to 0, which indicates you are not using this functionality. This field is only enabled if you select the Use VAT check box. Note This field is only available if Show is selected for the VAT Display Level field in Tax Control Maintenance.
Default VAT Supplier	Enter the supplier code of the default VAT supplier to which you will pay VAT for purchase orders, or click the Lookup button to select a supplier code. This is the default VAT supplier for purchase orders for products ordered from one country and shipped to a different country. This can be overridden for specific locations or purchase orders. This field is only enabled if you select the Use VAT check box. Note This field is only available if Show is selected for the VAT Display Level field in Tax Control Maintenance.
Name (Default VAT Supplier)	Enter the supplier name of the default VAT supplier to which you will pay VAT for purchase orders, or click the Lookup button to select a supplier name. This is the default VAT supplier for purchase orders for products ordered from one country and shipped to a different country. This can be overridden for specific locations or purchase orders. This field is only enabled if you select the Use VAT check box. Note This field is only available if Show is selected for the VAT Display Level field in Tax Control Maintenance.
Default Output VAT Class	Enter the default output VAT class for the country, or click the Lookup button to select the default output VAT class. This field is only enabled if you select the Use VAT check box. Note This field is only available if Show is selected for the VAT Display Level field in Tax Control Maintenance.
Default Input VAT Class	Enter the default input VAT class for the country, or click the Lookup button to select the default input VAT class. This field is only enabled if you select the Use VAT check box. Note This field is only available if Show is selected for the VAT Display Level field in Tax Control Maintenance.
Invoice Amount Limit	Enter the invoice amount limit (in the country's default currency) if the country has limitations on the monetary amount of invoices created for each company. This field is only enabled if you select the Use VAT check box. Note This field is only available if Show is selected for the VAT Display Level field in Tax Control Maintenance.

Accounts Tab Fields and Buttons

Field or Button	Description
Input VAT Clearing	Enter all or part of the input VAT clearing general ledger account to use when resolving the account from the country, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. For more information on input VAT clearing accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the country. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
Input VAT	Enter all or part of the input VAT general ledger account to use when resolving the account from the country, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. For more information on input VAT accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the country. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
Input VAT Write-off	Enter all or part of the input VAT write-off general ledger account to use when resolving the account from the country, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. For more information on input VAT write-off accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the country. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
Input VAT Pending	Enter all or part of the input VAT pending general ledger account to use when resolving the account from the country, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. For more information on input VAT pending accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the country. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
Output VAT	Enter all or part of the output VAT general ledger account to use when resolving the account from the country, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. For more information on output VAT accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the country. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.
Output VAT Variance	Enter all or part of the output VAT variance general ledger account to use when resolving the account from the country, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. For more information on output VAT variance accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the country. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

Inquiry Tab Fields and Buttons

Field or Button	Description
Locations	This grid displays information for locations in the country. For information on setting up locations, see Location Maintenance.