(BEL) Setting Up Country-Specific Functionality for Belgium

This chapter discusses how to:

Set up user-defined codes (UDCs).
Set up payment formats.

Setting Up UDCs for Belgium

Setting up Belgian-specific UDCs enables you to use Belgian-specific functionality. You also set up some base software UDCs with Switzerland-specific values. This section discusses how to set up UDCs for:

Tax processing
Accounts payable

Setting Up UDCs for Belgian Tax Processing

Set the VAT Report Code (74B/TA) for Belgian tax processing.

VAT Report Code (74B/TA)

You must set up the UDC (74B/TA) with the correct legal codes to configure the Set up TAX Rate Area / Document Type program (P74B500). Typical Belgian tax codes are contained in the Codes field.

The Codes column is a numeric two-position field. The Description 01 column lists the category of the value added tax (VAT) being reported and contains standard Belgian categories. The Description 02 column contains the type of VAT.

Your VAT Report Code (74B/TA) user-defined code table should be set up as:

Codes	Description 01	Description 02
00	Zero tax	Outgoing
01	6 pct. tax	Outgoing
02	12 pct tax	Outgoing
03	21 pct. tax	Outgoing
45	VAT paid by co-contractor	Outgoing
46	Free from VAT: Intracomm. goods	Outgoing
47	Free from VAT: non EU Export	Outgoing
48	Credit Notes for code 46	Outgoing
49	Credit Notes for A, B and C	Outgoing
54	VAT Payable on A	VAT payable
55	Intracomm. goods and services	VAT payable
56	Co-contractor goods and services	VAT payable
57	Non EU import, VAT domestic	VAT payable
59	VAT recoverable	VAT recoverable
61	Corr.: total VAT payable	VAT payable
62	Corr.: total VAT recoverable	VAT recoverable
63	VAT on credit notes received	VAT payable
64	VAT on credit notes send	VAT recoverable
81	Goods and Services	Incoming
82	Services and Other	Incoming
83	Goods for internal use	Incoming
84	Credit Notes for 86	Incoming
85	Other Credit Notes	Incoming
86	Intracomm. Goods and Services	Incoming
87	Services on real estate	Incoming
98	Not in VAT Report	Outgoing
99	Not in VAT Report	Incoming

Setting Up UDCs for Accounts Payable

Set Category Code 7 to process accounts payable payments for Belgium.

Category Code 07 (01/07)

Set up values in UDC table 01/07 to identify foreign payment reporting categories for the Belgian authorities. When entering supplier master records, enter the code in the Category Code 7 field so that Belgian payments are processed correctly.

For example, you might set up these codes:

090: Export credits
09: International business credits

Verify all codes with the Belgian authorities before entering them.

Setting Up Payment Formats for Belgium

This section provides an overview of payment formats for Belgium and discusses how to:

Set processing options for Create A/P Bank Diskette - Belgium Foreign (R04572L2).
Set processing options for Create A/P Bank Diskette - Belgium Domestic/EURO (R04572L3).

Understanding Payment Formats for Belgium

JD Edwards EnterpriseOne software supports these country-specific automatic payment formats for Belgium:

Format	Description
Create A/P Bank Diskette - Belgium Foreign (R04572L2)	This payment format is based on the current Belgian banker association standard and enables clients to write electronic funds transfers to foreign suppliers. This format supports the International Bank Account Number (IBAN); the output records contain the IBAN number and other related IBAN information if you set up IBAN information for your company and your supplier.
Create A/P Bank Diskette - Belgium Domestic/EURO (R04572L3)	The Belgian domestic-compliant and euro-compliant payment format. This payment format is based on the current Belgian banker association standard. This format enables clients to write EFT to domestic suppliers.

Using the Foreign Payment Format

The Create A/P Bank Diskette - Belgium Foreign payment format is used for payments to foreign suppliers. When you run the Create A/P Bank Diskette - Belgium Foreign program, the system produces a cover page in the standard printed format.

The system also generates a standard bank formatted output file in these tables:

Table	Description
A/P Payment Tape (F04572OW)	The standard electronic funds transfer table in the JD Edwards EnterpriseOne payment processing cycle.
Text Processor Header (F007101)	The header record for the Text File Processor program (P007101).
Text Processor Detail Table (F007111)	The detail record for the Text File Processor program (P007101).

Note. You can use either the A/P Payment Tape table (F04572OW) or Text Processor tables to extract payment details from the JD Edwards EnterpriseOne system.

The cover page includes:

Information	Description
Principal	The name and address of the company that is remitting the payment.
Registration Number	The file ID for the A/P Payment Tape table (F04572OW).
Ordering Customer's Account Number	The bank transit number that is associated with the company account which is being used for payment. This information is found in the Bank Transit Master table (F0030) that is associated with that account.
Name of Medium File	The name of the report that creates the file.
Creation Date	The date when the file is created.
Number of Data Records	The number of data records created in the A/P Payment Tape table (F04572OW).
Number of Payment Orders	The number of separate payments that are included in the file.
Total of Amounts	The total amount of the payments added together.

When you run the Create A/P Bank Diskette - Belgium Foreign program, the payment attachment program that is associated with this payment group produces a standard payment attachment. As with standard payment processing, the payment attachment contains the invoice numbers that are included in the payment.

Considerations for the Foreign Payment Format

To correctly populate the bank's address in the output file from the Create A/P Bank Diskette - Belgium Foreign program, you must complete either of these fields:

SWIFT Code on the Set Up Bank Accounts by Address form.
Address Number on the Set Up Bank Transit Address form.

When you complete the SWIFT Code field, the SWIFT Code and the supplier's account number create a unique bank/bank account number combination in the bank file. When you complete the Address Number field for the bank, the bank's mailing address and the supplier's account number create a unique bank address/bank account number combination in the bank file.

Important! It is recommended that you complete the SWIFT Code field and leave the Address Number field blank. If you complete both fields, the system uses the value in the SWIFT Code field.

The Domestic Belgium Payment Format

The Create A/P Bank Diskette - Belgium Domestic/EURO (R04572L3) payment format is used for payments to domestic suppliers. When you run the Create A/P Bank Diskette - Belgium Domestic/EURO program, it generates a cover page and a reference list in the standard printed format.

The system also generates a standard bank formatted output file in these tables:

Table	Description
A/P Payment Tape (F04572OW)	The standard electronic funds transfer table in the JD Edwards EnterpriseOne payment processing cycle.
Text Processor Header (F007101)	The header record for the Text File Processor program (P007101).
Text Processor Detail Table (F007111)	The detail record for the Text File Processor program (P007101).

Note. You can use either the A/P Payment Tape table (F04572OW) or Text Processor tables to extract payment details from the JD Edwards EnterpriseOne system.

The reference list includes:

Detail	Description
Registration Number	This number identifies the file in A/P Payment Tape table (F04572OW).
Payment From	The bank transit number that is associated with the company account which is being used for payment. This information is found in the Bank Transit Master table (F0030) that is associated with that monetary account.
Payment To	This line identifies the payee's bank account number.
Detail Section	This section includes the document type, document number, invoice number, invoice date, payment amount, and due date.

In addition to the reference list and cover page, an additional report is generated by the domestic payment program. The Bank Payment Detail Belgium program (R74GHP70), or Remittance letter, generates a hard copy of detail information that is included in the electronic file. It contains additional detail information about the electronic payment.

Setting Processing Options for Create A/P Bank Diskette - Belgium Foreign (R04572L2)

Processing options enable you to specify the default processing for programs and reports.

Bank Info

Bank's Payment Method

Specify the bank's payment method. Enter TLX to specify Urgent SWIFT. Leave this processing option blank to specify Normal SWIFT. You bank might provide other codes.

Cost Code

Specify how the bank's charges are applied. Values are:

NOR: Normal costs.

BEN: All costs to beneficiary.

OUR: All costs to orderer.

Diskette

Use these processing options to specify the default values for the bank tape.

Devise Name	Enter the devise name.
Tape Density	Enter the tape density.
Label Name	Enter the label name.
Block Size	Enter the block size.
New Volume ID	Enter the new volume ID.
New Owner ID	Enter the new owner ID.
File Name	Enter the file name.

Setting Processing Options for Create A/P Bank Diskette - Belgium Domestic/EURO (R04572L3)

Processing options enable you to specify the default processing for programs and reports.

Diskette

Use these processing options to specify the default values for the bank tape.

Execution Date	Specify the execution date. If you leave this processing option blank, the system uses the current date.
Duplicate	Enter 1 if this is not the first time that the diskette is generated. The system places a D in the Header Record of the diskette when you enter 1.
Devise Name	Enter the devise name.
Label Name	Enter the label name.
New Volume ID	Enter the new volume ID.
New Owner ID	Enter the new owner ID.
File Name	Enter the file name.

Reference List

Print Reference List	Enter 1 to always print the reference list. If you leave this processing option blank, the system prints the reference list only for the payees for which the value in the Bank Message field reaches the maximum amount of invoices.
Print Bank Payment Detail List	Enter 1 to print the bank payment detail list.

Currency

EURO Currency Code

Specify the currency code that exists in your system for the euro. If the code that you enter is the same as the currency code of the payment, the system uses the Euro Bank Payment Format. If the currency code of the payment is different from the code that you enter, they system uses the BEF Bank Payment Format.