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.
See Also
Setting Up Accounts Receivable Drafts
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.
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:
|
Income Statement |
These account classes are included on the Income Statement:
|
Other |
These account classes are reserved for other reporting purposes:
|
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
See Also
Defining an Alternate Chart of Accounts for Statutory Reporting
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)
This section provides an overview of draft stamps and discusses how to set up fees for 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:
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:
|
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.
This section provides and overview of village codes for companies and discusses how to enter the village code.
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.
See Also
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. |
W74S0010A |
Click OK on the Company Setup form. |
Enter the village code. |
Access the Spain Company Additional Information Revisions form.
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).
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.
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.96 Foundation Guide.
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. |
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. |
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. |
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. |
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. |
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 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 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 |
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 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. |
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. |