Skip to content
logo Knowledgebase

Enter EORI numbers in Sage 50 Accounts v27.2 and above

Created on  | Last modified on 

Summary

How to enter an Economic Operator Registration and Identification (EORI) number when importing and exporting goods between the EU and the UK.

Description

From 1 January 2021, businesses need an Economic Operator Registration and Identification (EORI) number to import and export goods between the EU and the UK. Sage 50 Accounts v27.2 introduces new fields to store your customer and supplier EORI numbers.

Resolution

The EORI number is also known as the Exporter Reference Number (ERN) or the exporter's Registered Exporter (REX) number.

Enter your company EORI number

  1. Click Settings then click Company Preferences.
  2. Enter your Password and click OK.
  3. In the Details tab enter your EORI Number then click OK.

Enter an EORI number for a customer or supplier

NOTE: In v29 you can now add the EORI number into the delivery address when creating an invoice or credit within the Order tab.

  1. Click Customers or Suppliers as required.
  2. Double-click the required customer or supplier record.
  3. On the Details tab, in EORI Number enter the customer or supplier EORI number.
  4. Click Save, then click Close.

TIP: You can enter one EORI number per record. If a customer or supplier has multiple EORI numbers you can create a separate customer or supplier record for each EORI number. 

Print EORI numbers on an invoice or order

When printing invoices and orders, the following layouts display EORI numbers by default:

Type Layout description File name
Invoice A4 Commercial invoice - Plain Paper (Print or Email) COMINVPLAINA4
Sales order A4 Export Sales Order - Plain Paper (Print or Email) EXPSOPPLAINA4
Purchase order A4 Import Purchase Order - Plain Paper (Print or Email) IMPPOPPLAINA4

Alternatively, you can edit your existing layouts to add the EORI numbers:

  1. Select the invoice or order layout you want to amend, then click Edit.
  2. If required, to make space on the layout you can click and drag items or resize items. 
  3. On the menu bar click Toolbox, then click Add Data Field.
  4. In the Add Data Field window, expand the following table as required:
    • To add your company EORI number, expand the COMPANY table
    • To add the customer EORI number, expand the SALES_LEDGER table
    • To add the supplier EORI number, expand the PURCHASE_LEDGER table
  5. Click the EORI_NUMBER data field, then click OK.
  6. If required, click and drag to move or resize the data field.
  7. On the menu bar click File, then click Save As.
  8. If required, enter a new file name then click Save.
  9. On the menu bar click File, then click Exit.