(BEL) Understanding Country-Specific Functionality for Belgium

This chapter discusses:

Belgium-specific setup and processes that you use in addition to the standard setup and processes provided in the base software.
Tax ID validation for Belgium.
Bank account validation.
Additional supplier information for Belgium.

Belgium-Specific Setup and Processes

This table lists the country-specific setup and functionality for Belgium:

Setup or Process	Description
User-defined codes (UDCs)	In addition to the standard software UDCs, set up UDCs to work with: Tax processing. See Setting Up UDCs for Belgian Tax Processing. Accounts payable. See Setting Up UDCs for Accounts Payable. European Union reporting. See Setting Up UDCs for Intrastat Reporting. Invoices with an attached International Payment Instruction (IPI). See Setting Up UDCs for International Payment Instructions. Companies: Affiliated Companies (74/AC) Code Number (74/30) See Setting Up UDCs for European Companies.
Payment processing	Before processing payments, set up the Belgium-specific payment formats. See Setting Up Payment Formats for Belgium.
Customer bank accounts	Before you assign bank accounts to customers, verify that your customers have a country code that is equal to BE (Belgium) in the Address Book Master table (F0101). The validation of the online bank account information is activated based on this key. See Setting Up Bank Accounts.
Supplier bank accounts	Before you assign bank accounts to customers, verify that your customers have a country code that is equal to BE (Belgium) in the Address Book Master table (F0101). The validation of the online bank account information is activated based on this key. See Setting Up Supplier Bank Accounts.
Customer setup	The Belgian authorities allow only one value-added tax (VAT) listing per VAT registration number for the Quarterly and Yearly VAT report. If multiple customers have identical VAT registration numbers within the JD Edwards EnterpriseOne system, a parent company must report the consolidated information for all its customers to the Belgian authorities. See (BEL) Entering Customer Information for Parent Companies.
Tax rate areas	Before entering taxable transactions for Belgium, set up tax rate areas for Belgium. See (BEL) Setting Up Tax Rate Areas for Belgium.
Tax ID validation	Set up the VAT or RNPM (Registre National des Personnes Morales) tax ID number for each company, customer, or supplier. See Tax ID Validation for Belgium.
Bank accounts	When setting up bank accounts for Belgium: Review the overview about bank account validation. See Understanding Bank ID and Bank Account Validation. See Bank Account Validation. Review the overview about using international bank account numbers (IBAN). See Understanding International Bank Account Numbers.
Invoice processing	In addition to standard invoice processing, you can print invoices with an attached IPI. To print these invoices and attachments: Set up UDCs for IPIs. See Setting Up UDCs for International Payment Instructions. Print invoices with attached IPIs. See Printing Invoices with an Attached International Payment Instruction.
Intrastat reporting (setup)	See (Europe) Setting Up European Union Functionality.
Intrastat and other European Union reporting (using)	See (Europe) Using European Union Functionality.
VAT reporting	These reports exist for Belgium: Monthly VAT Payable Report - Belgium (R74B100). Monthly VAT Recoverable Report (R74B110). Yearly VAT Report (Paper) (R74B150). Yearly VAT Report (Flat File) (R74B200). Quarterly VAT Report (Flat File) (R74B250). Quarterly VAT Report (Paper) (R74B300). See (BEL) Reports for Belgium.

Tax ID Validation for Belgium

A tax ID is the identification number that you use when you report information to the various tax authorities. For every transaction that can occur with a company, a customer, or a supplier, you must enter an associated tax identification number. Tax IDs are also called VAT codes, VAT registration numbers, or fiscal codes.

When you create an address book record for each company, customer, or supplier, enter the tax ID number in the Tax ID field on the Address Book Revision form. To ensure that the tax ID that you enter is checked for authenticity, enter a country code from the Country Codes (00/CN) UDC table in the Country field on the Mailing tab on the Address Book Revision form. When a country code exists in this field, the system validates tax IDs for that country. Additionally, the country code that you specify in the Country Code field must exist in the Tax ID Validation (70/TI) UDC table.

Belgian Tax IDs

Businesses in Belgium can use the VAT or RNPM (Registre National des Personnes Morales) number as the tax ID for reporting to the government, or they can use the unique enterprise number (numero unique d’enterprise) as the tax ID for reporting. The unique enterprise number must always begin with the character 0.

You can enter the VAT, RNPM, or unique enterprise number into the system with the preceding characters BE or without these preceding characters. VAT and RNPM number strings are either 9 or 11 characters, depending on whether the preceding BE is entered. The unique enterprise number string is either 10 or 12 digits, depending on whether the preceding BE is entered. For example, these character string structures are valid:

BE 12345679 (VAT or RNPM with preceding BE and with a space between BE and the VAT or RNPM).
BE12345679 (VAT or RNPM with preceding BE and without a space between BE and the VAT or RNPM).
123456789 (VAT or RNPM without preceding BE).
BE0987654321 (unique enterprise number with preceding BE).

The maximum number of characters allowed by the system is 12. Therefore, if you enter a preceding BE with the 10-digit unique enterprise number, you cannot include a space between BE and the 10-digit number.
0987654321 (unique enterprise number without preceding BE).

When you enter a VAT, RNPM, or unique enterprise number, the system verifies that the length of the string is valid and that the characters are valid, such as the unique enterprise number beginning with 0 (zero). The system also compares and validates the check digits. If any of the validations fails, the system displays an error.

Bank Account Validation

To process bank transactions for Belgium, the account information that you enter must be accurate to avoid service charges from the bank and possible rejection of electronic funds transfers. Electronic funds transfers can be rejected for payments and receipts because of incomplete or incorrect account information.

The JD Edwards EnterpriseOne system automatically validates the bank account information for Belgian suppliers and customers, including the bank account numbers, according to the standards set by the Belgian banking authority. The Modulus 97 algorithm validates the bank account number when you add or change a bank account number. If you enter an invalid bank account number, you receive an error message stating that the bank account is invalid.

Note. When you add bank account information in the Bank Account Number field, ensure that the control digit is included, in addition to the bank account number in the Bank Account Number field. The Control Digit field is considered part of the bank account number in Belgium.

Additional Supplier Information for Belgium

JD Edwards EnterpriseOne software provides an option for reporting I.B.L.C./B.L.W.I (Institut Belgo-Luxembourgeios Du Change/Belgisch-Luxemburgs Wisselinstitut) codes for foreign payments. The I.B.L.C./B.L.W.I. is a Belgian governmental authority that requires reporting codes for all foreign payment orders. You must set up your suppliers and individual vouchers correctly before the Create A/P Bank Diskette - Belgian Foreign (R04572L2) payment format will use these codes.

Use the Category Code 07 field on the Supplier Master Revision form to enter the reporting code. When you enter vouchers for your suppliers, the system will assign the value in the Category Code 7 field to all vouchers for this supplier. If you leave the Category Code 07 field blank, the flat file for the Create A/P Bank Diskette - Belgian Foreign report (R04572L2) contains a value of 000.

If you add the reporting code to your supplier after you have already entered vouchers for that supplier, you must run the Update Approver/Cat Code 7 report (R04802) to update existing vouchers with the reporting code.

You can also enter the Category Code 07 value at the time of voucher entry.