Skip to content
logo Knowledgebase

Sage 200 Brexit - Country Codes

Created on  | Last modified on 

Summary

This article will cover how to amend or create country codes to be used in Sage 200 Professional, Sage 200 Standard Online, Sage for Education and Sage CRM.

Description

Due to the Brexit transition period coming to an end on 31/12/20, companies in both the United Kingdom and the Republic of Ireland must make changes inside their software to country codes to remain compliant with government legislation. The new country codes outlined in this article will already be in your software in the following variants, however, you may still need to follow the actions.

  • Sage 200 Professional 2020 R2
  • Sage 200 Standard Online
  • Sage for Education

If you do not have the above versions, there are notes to guide you on any changes you may need to make in the software.

Resolution

CAUTION: The XI and XU country codes have been added for use in Republic of Ireland only - see the Actions required for businesses in the Republic of Ireland section for further information. 

Actions required for businesses in the United Kingdom (England, Scotland, Wales & Northern Ireland)

Once you have correctly completed any in-progress submissions in your software, the EU check box will need to be cleared for the GB country code.

 NOTE: Older versions of Sage 200 Should keep GB ticked as EU 

Instructions on how to do this are as follows:

Sage 200 Professional
  1. Go to Accounting System Manager, Settings, Country Codes
  2. Scroll down to the GB code and untick the EU tick box
  3. Click OK.
Sage 200 Standard Online/Sage for Education
  1. Go to Settings, Organisational & Financial, Country Codes
  2. Scroll down to the GB code and untick the EU tick box
  3. Click OK.

Actions required for businesses in the Republic of Ireland

The following new country codes have been added into the latest versions of Sage 200 for use by companies in the Republic of Ireland:

  • XI - Northern Ireland
  • XU - Great Britain (However we don't envisage this country code being used in the software)

NOTE: For older version of Sage 200 Professional, these codes will need to be created manually. XI should be flagged as an EU country, for further information on how to do this, please follow the steps in this help file.

Once you have correctly completed any in-progress submissions, customers and suppliers based in Northern Ireland will require their country code to be set as XI.

Instructions on how to do this are as follows:

Sage 200 Professional

For customers:

  1. Go to Sales Ledger, Sales Accounts, Amend Account Details.
  2. Select your customer and click on the Trading tab
  3. Change the country code in the drop down to XI
  4. Save the record

NOTE: Further information on updating Sales Ledger records en masse can be found here

For suppliers:

  1. Go to Purchase Ledger, Purchase Accounts, Amend Account Details
  2. Select your supplier and click on the Trading tab
  3. Change the country code in the drop down to XI
  4. Save the record

NOTE: Further information on updating Purchase Ledger records en masse can be found here 

Sage 200 Standard Online/Sage for Education

For customers:

  1. Go to Customers, Create & Amend Accounts, Amend Customer Details
  2. Select your customer and go to the Trading tab
  3. Change the country code in the drop down to XI
  4. Save the record

NOTE: Further information on updating Customer records en masse can be found here

For suppliers:

  1. Go to Suppliers, Create & Amend Accounts, Amend Supplier Details
  2. Select your customer and go to the Trading tab
  3. Change the country code in the drop down to XI
  4. Save the record

NOTE: Further information on updating Supplier records en masse can be found here

CAUTION: It may also be necessary to make amendments to layouts to accommodate circumstances where a GB VAT number prefix is required.

Stock Records

You must review all your stock records and ensure that the Country of Origin has been selected correctly.

An example of this would be if you are a business based in the Republic of Ireland and have purchased a product from Northern Ireland, the Country of Origin code would now be XI.

Please see below for instruction on amending the Country of Origin on Stock records: 

Sage 200 Professional

 

Click Stock Control, Stock items, Maintain stock items, Amend a stock item then open the Analysis tab 

Amend the Country of Origin 

Information of updating Stock records on-mass can be found http://desktophelp.sage.co.uk/sage200/professional/Content/General/IMPORT_ImportStockRecords.htm  


Sage 200 Standard / Education 

 

Click Stock Control, Stock records, Amend a stock item details then open the Analysis tab 

Amend the Country of Origin 

Information of updating Stock records on-mass can be found http://desktophelp.sage.co.uk/sage200/sage200standard/Content/Screens/Stock/ImportStockItems.htm  


 Additional Requirements for Sage CRM users

To ensure that country codes pull through into CRM correctly, the following steps should be undertaken:

NOTE: The country codes of XI & XU must both exist in Sage 200 for this to work. This is irrespective of whether they have been added manually or are included as part of the latest software updates. You must repeat the following steps for each country code.

  1. In CRM, go to Administration, Customisation, Translation, New
  2. Caption Code is XI
  3. Caption Family is addr_country
  4. Caption Family Type is Choices
  5. UK Translation for XI - United Kingdom (Northern Ireland)
    UK Translation for XU - United Kingdom (Excluding Northern Ireland)
  6. Save the record
  7. Go to Administration, Settings, Metadata Refresh. Tick Refresh All, then Execute.
  8. Once completed, you must sync your data immediately.

Now all of the country codes will be synced across and translated correctly within CRM.