(ESP) Setting Up Functionality for Spain

This chapter provides overviews of the foreign tax ID validation, the alternate chart of accounts for Spain, and discusses how to set up:

User-defined codes (UDCs).
Draft stamps.
Village codes for companies.
Payment formats.

Understanding Foreign Tax ID Validation for Spain

Foreign companies and individuals in Spain are assigned national fiscal identification (ID) numbers. These numbers are used on legal and fiscal documents, such as invoices, vouchers, and fiscal reports. The fiscal ID number for companies is called the Codigo de Identificacion Fiscal (C.I.F.), and the number for individuals is called the Numero de Identificacion Fiscal (N.I.F.).

When you enter address book records for Spain, you enter the N.I.F. and C.I.F. numbers in the Tax ID field on the Address Book Revision form, and the system validates the number against the required format.

For foreign C.I.F. numbers, the system validates that the number is nine digits and contains the following attributes:

The first character is N.

N represents the type of company.
Characters two through seven contain a numeric string.
The last character is a check digit that the system assigns using an algorithm that is applied to the numeric string.

For foreign N.I.F. numbers, the system validates that the number is nine digits and contains the following attributes:

The first character is K, L, M, or X.

This value represents the type of foreign individual (for example: resident, nonresident, less than 14 years old, and so on).
Characters two through seven contain a numeric string.
The last character is a check digit that the system assigns using an algorithm that is applied to the numeric string.

If you enter a number in the Tax ID field that does not follow the required format, the system generates an error message.

When you run the Address Book Batch Upload program to upload records for Spain, the system validates numbers against the required format and generates an error message in the Work Center if any numbers are invalid.

Understanding the Alternate Chart of Accounts for Spain

In Spain, local businesses are required to use a legal, also known as a statutory, chart of accounts (PGC - Plan General de Cuentas). The Spanish statutory chart of accounts uses a decimal-based numbering system with ten account classes:

Account	Classes
Balance Sheet	These account classes are included on the Balance Sheet: Class 1: Capital Accounts and Borrowings and Long Term Debt Class 2: Fixed Assets and Long Term Investments and Assets Class 3: Inventories Class 4: Receivables, Payables, and related accounts with third parties Class 5: Cash and Marketable Securities
Income Statement	These account classes are included on the Income Statement: Class 6: Expenses Class 7: Income and Revenue
Other	These account classes are reserved for other reporting purposes: Class 0: Special Accounts - generally, commitments that are not recorded on the Balance Sheet, and so on Class 9: Analysis Accounts - does not directly concern general accounting and fiscal statement preparation Class 8: Currently not used

Classes and Subclasses

Accounts are organized in classes, subclasses, sub-subclasses, and so on. For example:

Class: 4 - Receivables and Payables
Subclass: 40 - Payables; 41 - Receivables
Sub-subclass: 419 - Advances Received from Customers, Discounts, and Refunds
Sub-sub-subclass: 4191 - Advances Received on Orders

Setting Up UDCs for Accounts Receivable Drafts for Spain

Set up the Draft Print Program (03B/DP) UDCs with Spain-specific values.

Set up each draft print program that you use in conjunction with the Invoice Group by Draft program (R03B5052). These draft print programs are available for Spain:

R74S500 (Print Receipt with Letter)
R74S502 (Print Drafts from Invoices)

Setting Up Draft Stamps for Spain

This section provides an overview of draft stamps and discusses how to set up fees for draft stamps.

Understanding Draft Stamps

Spanish law allows you to collect payment on multiple invoices by combining those invoices on a draft. The government collects a fee on drafts by requiring that the draft be printed on special paper with a government stamp. Spanish businesses pay the fee by purchasing the stamped paper. The amount of the fee depends on the amount of the draft. The government provides various stamps that correspond to the different fees.

To process drafts in the JD Edwards EnterpriseOne Accounts Receivable system, you need to set up a fee table. The fee table lists the fees for various draft amounts. You can set up more than one fee table and distinguish one from another by currency code, months outstanding, or effective date. For example, you might set up one fee table for drafts that are due within six months and another fee table for drafts with a due date that is more than six months away.

When a draft amount exceeds the upper limit on the fee table, the government increases the fee amount in proportion to the increase in the draft amount.

You should set up fees for draft stamps when you begin using the JD Edwards EnterpriseOne Accounts Receivable system to process drafts. You can revise the table of fees if the government changes the fees.

The system stores fee tables in these tables:

Stamps (Timbres) Fee Detail (F74S502).
Stamps (Timbres) Fee Header (F74S505).

Forms Used to Set Up Fees for Draft Stamps

Form Name	FormID	Navigation	Usage
Work With Stamp (Timbre) Fees	W74S505A	Spanish Draft Processing (G74S03B161), Maintenance of Stamp Fees.	Locate Spanish stamp fees.
Stamp (Timbre) Fees Detail	W74S505B	On the Work With Stamp (Timbre) Fees form, click Add.	Set up fees for Spanish draft stamps.

Setting Up Fees for Draft Stamps

Access the Stamp (Timbre) Fees Detail form.

Currency Code

Enter the code that identifies the currency of the fees.

Months Outstanding

Enter the number of months between the draft emission date and the draft due date.

Effective Date

Enter the date on which stamp fees become effective.

Check Amount

Enter the upper limit of the receipt amounts to which the fee applies. For example, if you enter a check amount of 4000 on the first line with a corresponding stamp fee of 10, all receipts less than or equal to 4000 will require a stamp fee of 10.

The check amount you enter also becomes the lower limit for the next line. For example, if you enter a check amount of 4000 on the first line and a check amount of 8000 on the second line, all receipts that are greater than 4000 and less than or equal to 8000 require the stamp fee that corresponds to the 8000 check amount.

Stamp Fee

Enter the fee amount (Timbre) paid to the government when a draft (Efecto) is created. The fee is based on these factors:

The amount of the draft receipt.

The number of days between the draft origination date and the draft due date.

The currency code.

The effective date.

Additional Fee Amt (additional fee amount)

Enter the additional fee amount that will be added to the original fee amount obtained from the fee table. An additional fee amount is added when the draft amount is beyond the upper limit that is listed on the table.

For Each Amt (for each amount)

Enter the additional draft amount for which you have to pay an additional fee. For example, if you must pay a 3 euro fee for each additional 1000 euros of the draft amount, you would enter 1000 in this field and enter 3 in the Additional Fee Amount field.

Note. You complete the Check Amount and Stamp Fee fields for each row in the fee table. You complete the Additional Fee Amt and For Each Amt fields only for last row in the fee table.

Entering a Village Code for Companies in Spain

This section provides and overview of village codes for companies and discusses how to enter the village code.

Understanding Village Codes for Companies

In Spain, when you set up a company record, you need to enter a village code for the company. The village code is the INE (National Institute of Statistics) code that identifies the place of origin of transactions that are initiated by the customer or supplier.

If your user profile is set to Spain (ES), the Spain Company Additional Information Revisions form appears when you add a company record. You specify the village code for the company on this form.

Forms Used to Set Up Companies for Spain

Form Name	FormID	Navigation	Usage
Company Setup	W0010B	Organization & Account Setup (G09411), Company Names & Numbers On the Work With Companies form, click Add.	Enter company information.
Spain Company Additional Information Revisions	W74S0010A	Click OK on the Company Setup form.	Enter the village code.

Form Name

FormID

Navigation

Usage

Company Setup

W0010B

Organization & Account Setup (G09411), Company Names & Numbers

On the Work With Companies form, click Add.

Enter company information.

Spain Company Additional Information Revisions

W74S0010A

Click OK on the Company Setup form.

Enter the village code.

Entering the Village Code

Access the Spain Company Additional Information Revisions form.

Setting Up Payment Formats for Spain

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

Create a payment format template.
Set processing options for Print Automatic Payments - Check - Spain (R74S572A).
Set processing options for Print Automatic Payments - Check With Letter - Spain (R74S572B).
Set processing options for Print Automatic Payments - Draft - Spain (R74S572C).
Set processing options for Print Automatic Payments - Funds Transfer Order - Spain (R74S572D).
Set processing options for Print Automatic Payments - Transf Order, (Foreign) - Spain (R74S572E).
Set processing options for Print Automatic Payments - Tape Format, (CSB 34/1) - Spain (R74S572FA).

Understanding Payment Formats for Spain

JD Edwards EnterpriseOne software provides these payment formats for Spain:

Format	Description
R74S572A	Checks.
R74S572B	Checks with letters.
R74S572C	Draft format.
R74S572D	Transfer order (domestic currency).
R74S572E	Transfer order (foreign currency).
R74S572FA	Electronic fund transfer. This format supports IBAN; the output records contain the IBAN number and other related IBAN information if you set up IBAN information for your suppliers.

Considerations for the Print Automatic Payments - Tape Format, (CSB 34/1) - Spain (R74S572FA) Format

The Print Automatic Payments - Tape Format, (CSB 34/1) - Spain format supports cheques, electronic funds transfers (EFT) for foreign payments, and EFT for domestic payments. You specify in a processing option whether the system processes payments as foreign EFT, domestic EFT, or cheques.

Understanding Payment Format Templates for Spain

Use the Media Objects program (P98TMPL) to create header text for these payment formats:

R74S572B for check with letter.
R74S572C for draft.
R74S572D for transfer order (domestic currency).
R74S572E for transfer order (foreign currency).

You attach the header text to these payment formats by entering the name of the payment format template in the processing options of the payment formats.

Note. The Media Objects program is not available in the web client. You must access an non-web client to create the payment format templates.

See JD Edwards EnterpriseOne Tools 8.98 Foundation Guide.

Setting Processing Options for Print Automatic Payments - Check - Spain (R74S572A)

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

Translation

Translation Program

Specify which translation program to use to translate the payment amount into words. The value that you enter must exist in the Check Translation (98/CT) UDC table. If you leave this processing option blank, the system uses the translation program associated with the payment currency.

Conversion

First Line Size	Enter the size of the first line of the check format. If you leave this processing option blank, the system uses the maximum value of 85.
Second Line Size	Enter the size of the second line of the check format. If you leave this processing option blank, the system uses the maximum value of 85.
Convert Decimals	Enter 1 to prevent the conversion of decimal numbers (cents) to words.

Payment

Company Name

Enter 1 to print the company name and address on the payment. If you leave this processing option blank, no company information is printed.

Form Type (Future)	This processing option is not used.
City Name	Enter the name of the city to print on the check. If you leave this processing option blank, no city is printed.

Setting Processing Options for Print Automatic Payments - Check with Letter - Spain (R74S572B)

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

Translation

Translation Program

Conversion

First Line Size	Enter the size of the first line of the check format. If you leave this processing option blank, the system uses the maximum value of 85.
Second Line Size	Enter the size of the second line of the check format. If you leave this processing option blank, the system uses the maximum value of 85.
Convert Decimals	Enter 1 to prevent the conversion of decimal numbers (cents) to words.

Payment

Company Name	Enter 1 to print the company name and address on the payment. If you leave this processing option blank, no company information is printed.
Purchase Order	Enter 1 to print the purchase order number on the stub instead of the supplier invoice number.
Alternate Stub Information	Enter 1 to print the suppler name on the payment stub. Enter 2 to print the supplier invoice number. Leave this processing option blank to print the remark.

Form Type (Future)	This processing option is not used.
City Name	Enter the name of the city to print on the check. If you leave this processing option blank, no city is printed.
Template Name	Enter the name of the template that will be used to retrieve the header text.

Setting Processing Options for Print Automatic Payments - Draft - Spain (R74S572C)

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

Translation

Translation Program

Form Type (Future)	This processing option is not used.
City Name	Enter the name of the city to print on the check. If you leave this processing option blank, no city is printed.
Template Name	Enter the name of the template that will be used to retrieve the header text.

Conversion

First Line Size	Enter the size of the first line of the check format. If you leave this processing option blank, the system uses the maximum value of 85.
Second Line Size	Enter the size of the second line of the check format. If you leave this processing option blank, the system uses the maximum value of 85.
Convert Decimals	Enter 1 to prevent the conversion of decimal numbers (cents) to words.

Payment

Company Name	Enter 1 to print the company name and address on the payment. If you leave this processing option blank, no company information is printed.
Purchase Order	Enter 1 to print the purchase order number on the stub instead of the supplier invoice number.
Alternate Stub Information	Enter 1 to print the suppler name on the payment stub. Enter 2 to print the supplier invoice number. Leave this processing option blank to print the remark.

Setting Processing Options for Print Automatic Payments - Funds Transfer Order - Spain (R74S572D)

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

Translation

Translation Program

Conversion

First Line Size	Enter the size of the first line of the check format. If you leave this processing option blank, the system uses the maximum value of 75.
Second Line Size	Enter the size of the second line of the check format. If you leave this processing option blank, the system uses the maximum value of 75.
Convert Decimals	Enter 1 to prevent the conversion of decimal numbers (cents) to words.

Form Type (Future)	This processing option is not used.
City Name	Enter the name of the city to print on the check. If you leave this processing option blank, no city is printed.
Template Name	Enter the name of the template that will be used to retrieve the header text.

Processing Options for Print Automatic Payments -Transf. Order (Foreign) - Spain (R74S572E)

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

Address

Address Format

Enter an override address format to use for the payee or company addresses. If you leave this processing option blank, the address does not print.

Translation

Translation Program

Conversion

First Line Size	Enter the size of the first line of the check format. If you leave this processing option blank, the system uses the maximum value of 75.
Second Line Size	Enter the size of the second line of the check format. If you leave this processing option blank, the system uses the maximum value of 75.
Convert Decimals	Enter 1 to prevent the conversion of decimal numbers (cents) to words.

Payment

Purchase Order

Enter 1 to print the purchase order number on the stub instead of the supplier invoice number.

Form Type (Future)	This processing option is not used.
City Name	Enter the name of the city to print on the check. If you leave this processing option blank, no city is printed.
Summarize Statistic Codes	Enter 1 to summarize detail lines by the Statistic Code. If you leave this processing option blank, the system prints detailed information.
Template Name	Enter the name of the template that will be used to retrieve the header text.

Setting Processing Options for Print Automatic Payments - Tape Format, (CSB 34/1) - Spain (R74S572FA)

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

Address

1. Address Line #	Specify the address line that contains the address of the payee. If you do not complete this processing option, the system prints the value that exists in the Address Line 4 field (data item ADD4) in the Address Book Master table (F0101).
2. City Line Number	Specify the Address Line that contains the city of the payee. If you do not complete this processing option, the system prints the value that exists in the City field (data item CTY1) in the Address Book Master table (F0101).
3. Zip Code Field	Specify whether the system uses the value that exists in the Postal Code field as the postal code. Values are: Blank: The system uses the value that exists in the Postal Code field (data item ADDZ) in the Address Book Master table (F0101). 1: The system uses the first five characters of the value that exists in the City field (data item CYT1) in the Address Book Master table (F0101).
4. Second Company Address Number	Enter the Address Number of a second company if the order belongs to other company. If the order belongs to another company, use this processing option to specify the address number of the company.
5. Suffix	Specify a suffix for the file. The value that you enter must be between 111 and 999.

1. Form Type (Future Use)

This processing option is not used.

Tape Format

1. Transaction Type	Specify whether the tape contains cheques, or is a domestic or cross-border transfer. Values are: 1: Cheques 2: Domestic transfer 3: Cross-border transfer
2. Expenses	Specify whether expenses are paid by your company or by the payee. Values are: 1: Expenses are paid by company. 2: Expenses are paid by the payee. 3: Expense costs are shared.
3. Charge Detail	Specify whether the system prints detailed information about the expenses. Values are: Blank: No details are printed. 1: Details are printed.
4. Payment City Name	Specify the city of origin for the payment.

Currency Code	Enter the code that identifies the currency of the fees.
Months Outstanding	Enter the number of months between the draft emission date and the draft due date.
Effective Date	Enter the date on which stamp fees become effective.
Check Amount	Enter the upper limit of the receipt amounts to which the fee applies. For example, if you enter a check amount of 4000 on the first line with a corresponding stamp fee of 10, all receipts less than or equal to 4000 will require a stamp fee of 10. The check amount you enter also becomes the lower limit for the next line. For example, if you enter a check amount of 4000 on the first line and a check amount of 8000 on the second line, all receipts that are greater than 4000 and less than or equal to 8000 require the stamp fee that corresponds to the 8000 check amount.
Stamp Fee	Enter the fee amount (Timbre) paid to the government when a draft (Efecto) is created. The fee is based on these factors: The amount of the draft receipt. The number of days between the draft origination date and the draft due date. The currency code. The effective date.
Additional Fee Amt (additional fee amount)	Enter the additional fee amount that will be added to the original fee amount obtained from the fee table. An additional fee amount is added when the draft amount is beyond the upper limit that is listed on the table.
For Each Amt (for each amount)	Enter the additional draft amount for which you have to pay an additional fee. For example, if you must pay a 3 euro fee for each additional 1000 euros of the draft amount, you would enter 1000 in this field and enter 3 in the Additional Fee Amount field.