This chapter contains the following topics:
Section 4.1, "Understanding Accounts Receivable Draft Processing in Spain"
Section 4.3, "Working With Draft Remittance Formats for Spain"
Section 4.6, "Entering A.E.B. Customer and Supplier Bank Information for Spain"
Section 4.7, "Generating Financial Statement Reports for Spain"
The JD Edwards EnterpriseOne system provides country-specific functionality for draft origination and draft remittance in Spain. To process accounts receivable drafts in Spain, perform these steps:
Set up the JD Edwards EnterpriseOne Accounts Receivable system base software for drafts, and also use the Maintenance of Stamp Fees program (P74S505) to set up fees for draft stamps for Spain.
Use Spain-specific programs to group invoices and print drafts.
Use the standard JD Edwards EnterpriseOne Accounts Receivable software to accept drafts.
Use Spain-specific programs to remit drafts.
Use the standard JD Edwards EnterpriseOne Accounts Receivable software to collect drafts.
Before you work with draft remittance for Spain:
Set up UDCs.
Set up draft stamp tables.
This section provides an overview of draft remittance formats and discusses how to:
Set processing options for Draft Remittance File Format AEB 19 - Spain (R74S6729).
Set processing options for Draft Remittance File Format AEB 32 - Spain (R74S6722).
Set processing options for Draft Remittance File Format AEB 58 - Spain (R74S6728).
The system provides these remittance formats to remit drafts to the bank:
Draft Remittance File Format AEB 32 - Spain (R74S6722).
Draft Remittance File Format AEB 58 - Spain (R74S6728).
To remit drafts using one of these formats, enter the program number and version of the format that you want to use in the Paper/Tape processing option of the Draft Remittance program (R03B672).
The Spanish remittance formats create Text File Processor batches that contain the remittance information.
Use the AEB 19 format to remit drafts for which the funds will be collected later.
The AEB 19 can be submitted in either of two formats. You specify the format in the processing options of the Draft Remittance File Format AEB 19 - Spain program (R74S6729). Format 1 contains the invoice number in the reference field. Format 2 contains the draft number in the reference field. The format that you select depends on the requirements of the bank to which you remit the drafts.
Processing options enable you to specify the default processing for programs and reports.
These processing options specify the format in which drafts are printed as well as where address information is stored on customer records in the JD Edwards EnterpriseOne Address Book system.
Specify the format that the system uses. Values are:
Blank: Format one.
2: Format two.
Specify the address line number in the address book record that contains the street address of the client. Values are:
Blank: Address line 1.
1: Address line 2.
2: Address line 3.
Specify the address line number in the address book record that contains the city of the client. Values are:
Blank: Address line 1.
2: Address line 2.
3: Address line 3.
4: Address line 4.
This processing option specifies the currency in which the system creates remittances.
Specify whether the system creates remittances using euros or the currency of the company. Values are:
Blank: Use the company currency.
1: Use euros (EUR).
These processing options specify processing information that the system uses when creating remittances.
Specify the date on which the remittance is created. If you leave this processing option blank, the system uses the system date as the default value.
Specify the company that is issuing the remittance. Blank is not a value.
Processing options enable you to specify the default processing for programs and reports.
Specify the address line number in the address book record that contains the street address of the client. Values are:
Blank: Address line 1.
1: Address line 2.
2: Address line 3.
Specify the address line number in the address book record that contains the city of the client. Values are:
Blank: Address line 1.
2: Address line 2.
3: Address line 3.
4: Address line 4.
This processing option specifies the currency in which the system creates remittances.
Specify whether the system creates remittances using euros or the currency of the company. Values are:
Blank: Use the company currency.
1: Use euros (EUR).
These processing options specify processing information that the system uses when creating remittances.
Specify the date on which the remittance is created. If you leave this processing option blank, the system uses the system date as the default value.
Specify the company that is issuing the remittance. Blank is not a value.
Specify the type of draft that the system uses to create remittances. Values are:
Blank: Receipt.
1: Letra
2: Receipt
3: Pagare
Specify the customer draft acceptance status. Values are:
Blank: Drafts are not accepted.
1: Drafts are accepted.
2: Drafts are not accepted.
Specify the draft fees choice. Values are:
0: Without fees.
1: With fees.
9:Orden de protesto notarial.
Specify the geographic area code (UDC 00/S) that the system prints on remittance records. If this processing option is left blank, the system uses the first two digits in the zip code.
Specify the name of the city of the company.
Processing options enable you to specify the default processing for programs and reports.
This processing option specifies the currency in which the system creates remittances.
Specify whether the system creates remittances using euros or the currency of the company. Values are:
Blank: Use the company currency.
1: Use euros (EUR).
This processing option specifies the date that the remittance is created.
Specify the date on which the remittance is created. If you leave this processing option blank, the system uses the system date as the default value.
This processing option specifies the company number issuing the remittance.
Specify the company that is issuing the remittance. Blank is not a value.
Enter the suffix for the tax ID. This value should be from 000 to 999.
This section provides an overview of Spanish draft origination, the Print Receipt with Letter Program, and the Print Drafts from Invoices program, list prerequisites, and discusses how to:
Group invoices for drafts.
Set processing options for Invoice Group by Draft (R03B5052).
Print drafts with letters.
Set processing options for Print Receipt with Letter (R74S500).
Print drafts from invoices.
Set processing options for Print Drafts from Invoices (R74S502).
The draft process begins when you originate (print) a draft. The draft shows the amount to be paid, the due date, and information about the underlying liabilities (invoices).
The first step in draft origination is grouping invoices for drafts. You use the Invoice Group by Draft program (R03B5052) to group invoices for drafts.
The Invoice Group by Draft program groups open invoices from the F03B11 table by either customer number or payor number; and by company, currency code, and net due date. You can also use detail mode to group each invoice pay item with the same net due date on one draft.
For each group, the program assigns the draft number of the draft as a control number. The program also produces a report that includes a total for each group of invoices. This total is the amount of the draft.
The system processes only invoices that have an open amount and that have an empty Control/Statement field (CTL) in the F03B11 table. The system excludes invoices with record types R1, R5, or RU, as well as invoices for customers who have a Send Invoice To (SITO) value of N for Company 00000 in the Customer Master by Line of Business table (F03012).
|
Note: You must group records in the Invoice Group by Draft program in the same way that you process records in the Print Drafts from Invoices program. For example, if you set the processing options on the Invoice Group by Draft program to group by customer, you must also set the processing options on the Print Drafts from Invoices program to process by customer. If you specify the Print Drafts with Invoices program in the processing options of the Invoice Group by Draft program, the processing option value for grouping does not get passed from the Invoice Group by Draft program to the Print Drafts with Invoices program. You must set up matching processing options for both programs. |
You can use the processing options on the Invoice Group by Draft program to run a program that prints the drafts, such as the Print Drafts from Invoices program (R74S502). You can also print the drafts separately after running the Invoice Group by Draft program.
You can use the processing options on the Invoice Group By Draft program (R03B5052) to run either of these draft print programs:
Print Receipt with Letter (R74S500)
Print Drafts from Invoices (R74S502)
Both of these programs create drafts based on invoices (document type RI). Print Receipt with Letter does not group invoices according to their stamp fees, whereas Print Drafts from Invoices does.
The Print Receipt with Letter program prints statements of invoices and their corresponding drafts using the groupings that are produced by the Invoice Group by Draft program (R03B5052).
The system uses the customer number to retrieve bank transit information from the Bank Transit Master table (F0030). The system first looks for a record with a bank type of D (A/R Drafts, Auto Debit). If no record with a bank type of D exists, the system looks for a record with a bank type of C (Customer Bank Account). The system retrieves additional bank information from the A.E.B. Bank - Spain table (F74SCSB) by cross-referencing the transit number from the F0030 table with a bank code and control digit in table F74SCSB.
If no record with a bank type of either D or C exists for the customer in the F0030 table, the system does not print bank transit information on the draft.
|
Note: You must process records in the Print Receipt with Letter program in the same way that you group records in the Invoice Group by Draft program. For example, if you set the processing options for the Invoice Group by Draft program to group by customer, you must also set the processing options for the Print Receipt with Letter program to process by customer. If you specify the Print Receipt with Letter program in the processing options for the Invoice Group by Draft program, the processing option value for grouping does not get passed from the Invoice Group by Draft program to the Print Receipt with Letter program. You must set up matching processing options for both programs. |
The Print Receipt with Letter program retrieves information from the F03B11 table.
The Print Drafts from Invoices program (R74S502) uses the groups that are produced by the Invoice Group by Draft program (R03B5052) to prints drafts. The total amount of each draft, which is the total open amount of each group of invoices, determines the amount of the stamp that is required on the draft.
The system retrieves fee amounts from these tables:
Stamps (Timbres) Fee Detail (F74S502)
Stamps (Timbres) Fee Header (F74S505)
If the system cannot find a fee that corresponds to the draft amount, it sends an error message to the work center and does not print the draft.
The Print Drafts from Invoices program produces one printer spool file for each fee amount. All of the drafts that have the same fee amount are included in one printer spool file. This grouping enables you to load the paper with the appropriate stamp for each group of drafts.
|
Note: You must group records in the Print Drafts from Invoices program in the same way that you group records in the Invoice Group by Draft program. For example, if you set the processing options for the Invoice Group by Draft program to group by customer, you must also set the processing options for the Print Drafts from Invoices program to group by customer. If you specify the Print Drafts with Invoices program in the processing options for the Invoice Group by Draft program, the processing option value for grouping does not get passed from the Invoice Group by Draft program to the Print Drafts with Invoices program. You must set up matching processing options for both programs. |
The Print Drafts from Invoices program selects RI documents from the F03B11 table.
It is recommended that you set up data selection based on a currency code.
Before you complete the tasks in this section:
Set up the fee table for draft stamps.
Enter bank information for Spanish customers in the AEB Bank Revisions - Spain program (P74SCSB) and in the Bank Accounts by Addresses program (P0030A). The bank transit number in the Bank Accounts Addresses program corresponds to the bank code and office code in the AEB Bank Revisions - Spain program. The first four digits of the bank transit number are the bank code, and the second four digits are the office code.
See Entering A.E.B. Customer and Supplier Bank Information for Spain.
Select Spanish Draft Processing (G74S03B161), Invoice Group by Draft.
Processing options enable you to specify the default processing for programs and reports.
This processing option specifies a default value for the pay status code on R1 draft records.
Specify the Payment Status code (UDC 00/PS) that the system assigns to processed invoices.
These processing options specify how the system selects invoices for payment.
Specify how the system groups invoices and assigns draft numbers when it processes invoices. You can specify that the system process the invoices in detail mode, in which case the system assigns one draft number to each invoice or group of pay items with the same net due date. For example, for an invoice with two pay items whose net due dates differ, the system generates two drafts. For an invoice with two pay items whose net due dates are the same, the system generates only one draft.
Alternatively, you can group invoices by customer and assign one draft number to all invoices that have the same company, currency code, net due date, and customer number.
Finally, you can group invoices by payor and assign one draft number to all invoices that have the same company, currency code, net due date, and payor number.
Values are:
Blank: Process invoices in detail mode.
1: Group invoices by customer (AN8).
2: Group by invoices payor (PYR).
Specify the threshold amount that the system uses to suppress draft creation. If the total draft amount for the group of invoices is less than this threshold amount, no draft number is assigned to the invoices in the group. The system compares the threshold amount that you enter to the total domestic open amount, regardless of the currency code.
These processing options specify the program number and version to use to print drafts.
Specify the program that the system uses to print the drafts that are generated by this program. If you leave this processing option blank, you must manually run a draft print program to print the drafts.
Specify the version of the program that you specified in the Program ID processing option that the system uses to print drafts. If you leave this processing option blank, the system runs version ZJDE0001. If the ZJDE0001 version does not exist, the report does not run. If the Program ID processing option is blank, the system disregards this processing option.
Select Spanish Draft Processing (G74S03B161), Print Receipt with Letter.
Processing options enable you to specify the default processing for programs and reports.
Use this processing option to enter the date that you want to appear on the receipt and letter. If you leave this processing option blank, the program uses the current system date.
Specify the city of origin of the receipt. The system prints the city that you enter here on the receipt. If you leave this processing option blank, no city of origin appears on the receipt.
Specify the address number that the system uses to determine where to send the receipt. Values are:
Blank: Use the customer number (AN8).
1: Use the payor number (PYR).
Use this processing option to indicate whether you want tax amounts to appear on the letter. Values are:
Blank: Do not print tax amounts.
1: Print tax amounts.
Specify whether the system prints the invoice currency code and currency amounts on the receipt and the letter. Values are:
Blank: Do not print currency information.
1: Print currency information.
If you enter 1, the system prints foreign invoices with foreign amounts. If currency processing is not enabled, the system prints invoices with domestic amounts.
Use this processing option to indicate whether you want generic text associated with an invoice to be printed on the letter. Values are:
Blank: Do not print associated generic text.
1: Print associated generic text.
Select Spanish Draft Processing (G74S03B161), Print Drafts from Invoices.
Processing options enable you to specify the default processing for programs and reports.
Use this processing option to indicate the date when the draft is created. If you leave this processing option blank, the program uses the current system date.
Specify the city of origin of the draft. The system prints the city name on the draft. If you leave this processing option blank, no city of origin appears on the draft.
Use this processing option to enter a plain text clause. If you leave this processing option blank, no clause appears on the draft.
Specify the address number that the system uses to determine where the draft is sent. Values are:
Blank: Use the customer number (AN8).
1: Use the payor number (PYR).
If you grouped invoices by customer when you ran the Invoice Group by Draft program (R03B5052), you should leave this processing option blank. If the Invoice Group by Draft program grouped invoices by payor, you should set the value of this processing option to 1. If you ran the Invoice Group by Draft program in detail mode, you can set the value of this processing option to either blank or 1.
This section provides an overview of draft reprinting, lists prerequisites, and discusses how to:
Reprint drafts by receipt with letters.
Set processing options for Print Draft (R1) by Receipt with Letter (R74S520).
Reprint drafts by receipt.
Set processing options for Print Draft (R1) by Receipt (R74S521).
Reprint drafts based on stamp fees.
Set processing options for Print Drafts from R1 by Efecto (R74S522).
After you have originated drafts and printed them with either the Print Receipt with Letter program (R74S500) or the Print Drafts from Invoices program (R74S502), you can reprint drafts using these programs:
Print Draft (R1) by Receipt with Letter (R74S520).
Print Draft (R1) by Receipt (R74S521).
Print Draft from R1 by Efecto (R74S522).
These programs print drafts based on existing draft (R1) documents. The first two programs do not group drafts according to their stamp fees, whereas Print Draft from R1 by Efecto does.
The Print Drafts (R1) by Receipt with Letter program (R74S520) prints duplicate copies of drafts (R1 documents) that were generated by the Print Receipt with Letter program (R74S500), but that have not been voided or collected.
Similar to the Print Draft (R1) by Receipt with Letter program (R74S520), the Print Drafts (R1) by Receipt program (R74S521) prints duplicate copies of drafts (R1 documents) that were generated by the Print Receipt with Letter program (R74S500), but that have not been voided or collected. However, the Print Drafts (R1) by Receipt program prints only the receipt format; it does not print the associated letter.
The Print Draft from R1 by Efecto program (R74S522) prints drafts for existing draft documents from the Receipts Header table (F03B13) and the Receipts Detail table (F03B14). You can also use this program to print duplicate copies of drafts that were generated by the Print Drafts from Invoices program (R74S502).
The Print Draft from R1 by Efecto program prints drafts that are based on the stamp fees for the drafts. The total amount of each draft determines the amount of the stamp that is required on the draft.
The system retrieves fee amounts from these tables:
Stamps (Timbres) Fee Detail (F74S502)
Stamps (Timbres) Fee Header (F74S505)
If the system cannot find a fee that corresponds to the draft amount, it sends an error message to the work center and does not print the draft.
The Print Draft from R1 by Efecto program produces one printer spool file for each fee amount. All of the drafts that have the same fee amount are included in one printer spool file. This grouping enables you to load the paper with the appropriate stamp for each group of drafts.
Before you complete the tasks in this section:
Group invoices using the Invoice Group by Draft program (R03B5052).
Print drafts using the Print Receipt with Letter program (R74S500).
Select Spanish Draft Processing (G74S03B161), Print Draft (R1) by Receipt with Letter.
Processing options enable you to specify the default processing for programs and reports.
Specify the city of origin of the draft. The system prints the city name that you enter here on the draft. If you leave this processing option blank, no city of origin appears on the draft.
Specify whether you want the system to print tax amounts on the letter. Values are:
Blank: Do not print tax amounts.
1: Print tax amounts.
Specify whether the system prints the invoice currency code and currency amounts on the draft and the letter. Values are:
Blank: Do not print currency information.
1: Print currency information.
If you enter 1, the system prints foreign invoices with foreign amounts. If currency processing is not enabled, the system prints invoices with domestic amounts.
Use this processing option to indicate whether you want the system to print attachments associated with an invoice on the letter. Values are:
Blank: Do not print associated attachments.
1: Print associated attachments.
Select Spanish Draft Processing (G74S03B161), Print Draft (R1) by Receipt.
Processing options enable you to specify the default processing for programs and reports.
Specify the city of origin of the draft. The system prints the city name that you enter here on the draft. If you leave this processing option blank, no city of origin appears on the draft.
Specify whether to print the invoice currency code and currency amounts on the draft and the letter. Values are:
Blank: Do not print currency information.
1: Print currency information.
If you enter 1, the system prints foreign invoices with foreign amounts. If currency processing is not enabled, the system prints invoices with domestic amounts.
Select Spanish Draft Processing (G74S03B161), Print Draft from R1 by Efecto.
Processing options enable you to specify the default processing for programs and reports.
Specify the city of the origin of the draft. The system prints the city name that you enter here on the draft. If you leave this processing option blank, no city of origin appears on the draft.
Use this processing option to enter a plain text clause. If you leave this processing option blank, no clause appears on the draft.
Specify the address number that the system uses to determine where the draft is sent. Values are:
Blank: Use the customer number (AN8).
1: Use the payor number (PYR).
If the Invoice Group by Draft program (R03B5052) grouped invoices by customer, you should leave this processing option blank. If the Invoice Group by Draft program grouped invoices by payor, you should set the value of this processing option to 1. If the Invoice Group by Draft program grouped invoices in detail mode, you can set the value of this processing option to either blank or 1.
This section provides an overview of A.E.B. bank account information, lists a prerequisite, and discusses how to:
Enter A.E.B. bank account information.
Upload A.E.B. bank account information.
The Spanish Bank Authority (A.E.B.) provides valid bank account information including the bank code, office code, control digit, and sort number. The system uses this bank information when printing the draft formats for draft remittance and during automatic payment processing. You must enter this bank information in the A.E.B. Bank - Spain table (F74SCSB) to validate the bank account information for your Spanish customers and suppliers. You can enter the bank information manually or upload the bank information that is provided by the A.E.B. directly to the F74SCSB table.
The system uses the information in the Bank Code and Office Code fields of the F74SCSB table to validate bank account numbers. The Bank Code and Office Code in the F74SCSB table are used to validate the Bank Transit Number in the Bank Account Cross-Reference program (P0030A) or the Bank Account Information program (P0030G). The system validates the first four digits of the Bank Transit Number against the Bank Code, and the second four digits against the Office Code.
Create an address book record for each bank, ensuring that both the name of the bank and the name of the local office are entered in the Alpha Name field.
| Form Name | FormID | Navigation | Usage |
|---|---|---|---|
| Bank Revision (A.E.B.) | W74SCSBB | Accounts Payable - Spain (G74S04), AEB Bank Revisions - Spain
On the Work With Banks (A.E.B.) form, click Add. |
Enter A.E.B. bank account information. |
Access the Bank Revision (A.E.B.) form.
Enter a valid four-digit code assigned by the A.E.B.
Enter a valid four-digit code assigned by the A.E.B.
Enter the control digit. This digit is a value generated by the A.E.B. using both the bank code and the office code. The bank or the A.E.B. must supply this number.
Enter a four-digit code that is assigned by the A.E.B. This code is used to sort the information for a specific Bank Number and Office Number.
Enter a code that identifies the business site where the office is located. The code that you assign usually matches the city, but such a match is not strictly necessary.
Enter the name of the bank. This must be the proper name used by the bank in business.
Enter the commercial name of the bank office. This is the name used in inquires or to look for a special commercial office of a bank.
Enter the complete address of a particular commercial office of a bank. This is the suitable address to contact this office with any inquiry.
Enter the Castilian proper name of the city where the office is located.
Enter the zip code of the bank office.
Enter the proper name of the city where the office is located, as the region commonly uses it.
Enter the type of the bank office, according to the A.E.B. criteria.
Enter the phone number of the bank office.
Enter the Telex number of the bank office, if available.
To upload bank information provided by the A.E.B. directly to the A.E.B. Bank - Spain table (F74SCSB), you import the A.E.B. bank information file into the Text Processor Detail Table (F007111) using the Text File Processor program (P007101). When you import a file into the F007111 table, the system stores the contents of the imported file in the Text field (GPTX) of the F007111 table. Because the A.E.B. bank information file has no common format, you must create a custom batch program or table conversion to parse the value in the Text field (GPTX) of the F007111 table to correspond to the fields in the F74SCSB table and to update the parsed values to the F74SCSB table.
This table lists the fields in the F74SCSB table. You can use this information when creating a custom batch program or table conversion to parse the value in the Text field (GPTX) of the Text Processor Detail Table (F007111).
| Alias | Description | Length |
|---|---|---|
| SBCO | Bank Code | 4 |
| SOCO | Office Code | 4 |
| SSNU | Sort | 4 |
| SBNA | Bank Name | 36 |
| SONA | Office Name | 36 |
| SOAD | Office Address | 40 |
| SCDI | Control Digit | 1 |
| SFI1 | Filler One | 1 |
| SCNC | City Name in Castilian | 40 |
| SCNL | City Name in Other Language | 40 |
| SOFT | Office Type | 1 |
| SBSI | Business Site Code | 9 |
| SACO | Area Code | 3 |
| SPNU | Phone Number | 7 |
| SENU | Extension Number | 7 |
| STNU | Telex Number | 7 |
| SZCO | Zip Code | 5 |
| SFI2 | Filler Two | 17 |
This section provides an overview of financial statement reports, lists a prerequisite, and discusses how to:
Run the Generate Financial Report program.
Set processing options for Generate Financial Report (R749110).
Use the Generate Financial Report program (R749110) to print profit and loss, balance sheet, and other financial statement reports for Spain. You use the Financial Report Setup (P749101) and Financial Report Account Setup (R749102) programs to identify the layout of the report and the accounts to include, and then use the Generate Financial Report program to print the reports that you set up.
Before you complete the tasks in this section, set up layouts for financial statement reports.
Select Financial Reports (G7410), Generate Financial Report.
Processing options enable you to set default processing values.
Specify the last two digits of the fiscal year for which the trial balance will be printed. For example, enter 07 for 2007. If you complete this processing option, you must also specify the ending period number in the Period Number processing option. If you leave this processing option blank, the program uses the fiscal year.
Enter the period for which the trial balance will be printed. If you complete this processing option, you must also specify the fiscal year for the ending period in the Fiscal Year processing option. If you leave this processing option blank, the program uses the current period.
Enter the company for which you process records.
Specify the format for printed account numbers. Values are:
1 or blank: Standard account number (The default is business unit.object.subsidiary)
2: Short account ID (The system assigns)
3: Third G/L number (Your organization can assign during account setup)
Specify whether the system includes or omits accounts with zero balances for the specified period. Values are:
Blank: Include accounts with zero balances.
1: Omit accounts with zero balances.
|
Note: Accounts that are assigned a posting edit code of N print even when you set this processing option to 1. Accounts that are assigned a posting edit code of N are header accounts, which do not have balances. |
Enter 1 to show account detail. Leave this processing option blank to suppress printing of account details.
Enter a value that exists in the Scale Factor (74/SF) UDC table to specify the factor by which the system divides the value.
Enter a value to override the cost center group definition in the report setup. The cost center group represents a subset of cost centers. Financial reports use the cost center group to filter the accounts that belong to the specified cost center.
Specify whether to print amounts for accounts with subledgers. Enter a specific subledger number to use that ledger. Enter * to include all subledgers. Leave this processing option blank to include only accounts without subledgers.
If you complete this processing option, you must also complete the Subledger Type processing option.
Enter a value that exists in the Subledger Type (00/ST) UDC table to specify the table containing the subledger numbers. For example, subledger type A identifies the Address Book Master table (F0101). If you complete this processing option, you must also complete the Subledger - G/L processing option.
Specify the currencies that the system includes in the report when you post account balances by currency. To limit the report to amounts for a specific currency code, enter the code for the currency. The value that you enter must exist in the Currency Codes table (F0013). To include amounts for all currencies, enter * (asterisk). Leave this processing option blank if you do not post balances by currency.
|
Note: If you specify the CA ledger type in the Ledger Type processing option, and the CA ledger type includes amounts for multiple currencies, the totals will be meaningless unless you enter a specific currency code for this processing option. |
Enter a value that exists in the Ledger Types (09/LT) UDC table. You can specify up to four ledger types.
Enter a report name that you set up in the Financial Report Setup program (P749101). The system uses this value to determine the report specifications.
Enter a value that exists in the Reports Layout (74/RL) UDC table to specify whether the report is generated in landscape or portrait mode.
Enter the version of the program that is specified in the Report Layout processing option.
Enter the text that the system prints for the first line of the report title. If you leave this processing option blank, the system does not print a title.
Enter the text that the system prints for the second line of the report title. If you leave this processing option blank, the system does not print a second line.
Enter 1 to reuse the account structure that was created by the last run. You can reuse the account structure only when recalculating or reprinting. If you enter 1 but have changed the report template or account structure, your system might generate invalid data.
Enter 1 to clear the work files. Oracle recommends that you clear the work files only when required, such as when the Work Center generates a message that you must do so.
In addition to the reports specified as part of a process in other sections of this implementation guide, these reports exist for Spain.
| Report ID and Report Name | Description | Navigation |
|---|---|---|
| R70470 | Validates information in legal reports and can be used as the basis for internal auditing. You can also use the report as a basis for external auditing by a third-party, such as a fiscal authority or auditing firm. | Spanish Reports (G74S09), G/L by Category Code |
| R7409C1 | Validates information in legal reports and can be used as the basis for internal auditing. You can also use this report as a basis for external auditing by a third-party, such as a fiscal authority or auditing firm. | Spanish Reports (G74S09), G/L by Object and Subsidiary |
| R74S440 | Use this program to print the company invoice to display the exempted VAT for intracommunity VAT transactions. | VAT Reports - Spain (G74S7011), Print Invoice Company. |
| R74S450 | Use this program to list all VAT-eligible transactions as well as total amounts of accounts receivable (input) and accounts payable (output) VAT. | VAT Reports - Spain menu (G74S7011), VAT Report by Tax Rate/Area. |
| R74S490 | Prints a general journal of all transactions to submit to the Mercantile Registration at the close of each fiscal year. The transactions are marked with a register number and are reported chronologically. The summarized report includes credit and debit totals for each object and subledger account and period. The detail report includes credit and debit amounts for each transaction. | Spanish Reports (G74S09), G/J by Obj. Account or Cat. Code - Spain |
| R74S540 | Prints a list of the total amount and the fee amount for each draft. | Print the Stamp Fee report as part of draft remittance by entering the program and version numbers of the report on the Custom Report processing option of the Draft Remittance program (R03B672) |
| R74S560 | Prints detailed information about account transactions. You can use the report to:
|
G/L Reports - Spain (G74S09), G/L by Obj. Account - Spain |
| R74S570 | Prints total debit and credit amounts for each account in any given ledger. | Spanish Reports (G74S09), T/B by Obj. Account |
A company invoice (autofactura) is a legal document that displays the exempted VAT for Intra-Community VAT transactions. You should keep this report on file for the tax authority in the event of an audit.
You must print a company invoice for each voucher that you create.
You use the processing option to indicate which rate from the Intra-Community VAT tax rate/area contains the positive tax rate.
Processing options enable you to specify the default processing for programs and reports.
In Spain, businesses are required to document all Accounts Payable and Accounts Receivable transactions that are subject to VAT. The VAT Report by Tax Area/Rate report lists all VAT-eligible transactions as well as total amounts of accounts receivable (input) and accounts payable (output) VAT.
You use the processing options on the monthly VAT reports to create both an accounts payable and an accounts receivable version of the report. You should run both reports monthly.
You use the processing options to indicate which rate from the Intra-Community VAT tax rate/area setup should be included on the report. On the accounts payable version, include the positive tax rate. On the accounts receivable version, include the negative tax rate. The exempt VAT (0 percent) prints on the Accounts Payable version.
Processing options enable you to specify the default processing for programs and reports.
Select 1 if you want to update as printed the selected records. If blank the records won't be marked.
Select the beginning number for the printed records. If left blank, the system will begin with one.
Print report total by:
Blank - Tax Rate
1 - Tax Area
2 - Tax Area and Tax Rate
Print Detail or summarized report
Blank - Detail
1 - Summarized
Select 1 whether summarizing by documents the report doesn't have to print zero balance lines. Otherwise the zero balance lines will be printed.
Select the type of report:
Blank - Account Receivable
1 - Account Payable
Select the Tax Rate Line Number for Intra-Community VAT depending on the information to be printing on the report AR or AP.
Blank - Tax Rate Line 2
1 - Tax Rate Line 3
From Date or Through Date
Enter the currency code for As If currency display. This option allows for amounts to display in a currency other than the currency they are stored in. Domestic amounts will be translated and displayed in this as-if currency. If left blank, the stored currency will be used.
Enter the As Of date for processing the current exchange rate for the as-if currency. If left blank, the current date will be used.
|
Note: A valid exchange rate must exist in the exchange rate table between the two currencies base on the As Of date. |
Businesses in Spain must submit a general journal of all transactions to the Mercantile Registration at the close of each fiscal year. The transactions must be marked with a register number and must be reported chronologically. Businesses can report individual transactions or transactions summarized by account for each month. The summarized report includes credit and debit totals for each object and subledger account and period. The detail report includes credit and debit amounts for each transaction.
You can run the G/J by Cat. Code by object and subsidiary, or by category code, depending on whether accounts are defined in the object and subsidiary or in category code 21, 22, or 23.
This information is included on the general journal report:
Register number.
General ledger date.
Object account and subsidiary.
Account description.
Transaction description.
Credit and debit totals for each period.
At the end of each page, debit and credit totals for the page.
At the beginning of each page except the first page, debit and credit totals from the preceding pages.
For the G/J by Cat. Code report, these features apply:
You can use processing options to specify which general ledger date the system uses.
If the processing option is set to print summarized transactions, the general ledger date is the end date of the period. If the processing option is set to print detail transactions, the general ledger date is the general ledger date of the transaction.
Accounts with the same object account and subsidiary, but with different business units, appear as the same account.
You can display information for multiple accounting periods.
Every record on the general journal is numbered sequentially.
You use the processing options to enter a specific starting number.
The sequence of information on the general journal report depends on whether the report is run in detail or summary mode, and whether the report is run by object account or by category code. To meet statutory requirements, information on the general journal is sequenced as follows:
| General Journal | Report Sequence |
|---|---|
| Detail mode, by object account | Report sequence:
|
| Detail mode, by category code | Report sequence:
|
| Summary mode, by object account | Report sequence:
|
| Summary mode, by category code | Report sequence:
|
Processing options enable you to specify the default processing for reports.
Enter the from number to begin numbering the lines of the report. If you leave this processing option blank, the numbering will begin with 1.
Specify the from period and fiscal year and the to period and fiscal year in which to show account balances in detail.
Specify whether to print summarized transaction. Values are:
Blank: Print detail transactions.
1: Print summarized transactions.
Specify the category code that contains the alternate chart of accounts. The report prints the corresponding accounts. Valid category codes are 21–23. If you leave this processing option blank, the accounts that print on the report are based on the object.account.subsidiary values.
Specify an as if currency code in which to print amounts for this report. This processing option allows you to review amounts in a currency other than the currency in which they are stored. Only amounts associated with the AA ledger type are converted to the as if currency. If you enter an as if currency code, the decimal point for the journal entry currency must be the same as the decimal point for the as if currency.
If you leave this processing option blank, use the data selection to select only ledger types that use the same currency. Amounts do not print in an as if currency and the As If Currency column does not appear on the report.
Specify the date on which to retrieve the exchange rate for the as if currency from the F0015 table. If you enter a value for the As If Currency Code processing option and leave this processing option blank, the system uses the current date.
Spanish law enables you to collect payment on multiple invoices by combining invoices on a draft. The government charges a fee for processing drafts. The amount of the fee depends upon the total amount of the draft. Spanish businesses can print drafts on special paper that is stamped with the correct fee amount. Alternatively, Spanish businesses can pay an additional fee to the bank to have the bank print the drafts.
The Stamp Fees Report (R74S540) lists the total amount and the fee amount for each draft. You can use this report to verify that the bank is charging the correct fee for each draft. The report includes only the fee that is charged by the government, not any additional fees that the bank might charge for the service.
You print the Stamp Fee report as part of draft remittance by entering the program and version numbers of the report on the Custom Report processing option of the Draft Remittance program (R03B672).
Processing options enable you to specify the default processing for programs and reports.
The G/L by Obj. Account - Spain report includes detailed information about account transactions. You can use the report to:
Review transactions within individual accounts.
Research accounts that are out of balance.
Verify account accuracy.
You also use this report to open and audit accounts with the same control totals as the journal report. The accounts and the totals are the basis of the trial balance.
In Spain, businesses use the G/L by Obj. Account - Spain report as a basis for:
Internal auditing, as a control of account accuracy.
External auditing by a third-party, such as a fiscal authority or auditing firm.
The report includes this information:
Beginning and ending balances for each account.
Transactions that are based on a period selection or a date range selection.
Prior year-end balance or previous-period balance, depending on the transaction types that you select.
Balance forward amount printed at the bottom of the page when a page break occurs within an account.
Previous balance amount printed after a page break within an account.
Option to omit account with zero balances.
Option to print posted and unposted transactions.
Detail information by subsidiary or by object account only.
Totals by period and by account.
Accounts with the same object account but different business units are recognized as the same account for the report.
Businesses print the G/L by Obj. Account - Spain report at least once a year for all accounts, typically, at the end of the fiscal year. The total debits and credits that print on the report should equal the total debits and credits of the Trial Balance and G/L Registration reports.
Processing options enable you to specify the default processing for reports.
Specify a from period or enter a from date to show account balances. For the from period, values are:
Blank: Year to date
1: Current period
2: Inception to date.
Specify a through period and fiscal year or enter or a through date.
Enter 1 to print units or leave this processing option blank to print amounts only.
Enter 1 to omit accounts without balances or leave this processing option blank to include accounts with balances.
Enter 1 to show detail information by subsidiary or leave this processing option blank to show detail information by object account only.
Enter 1 to create totals by company or leave this processing option to not create totals by company.
Enter the model business unit to use for descriptions of the accounts. If you leave this processing option blank, the system uses the descriptions of the first account found.
Enter a ledger type code or leave this processing option blank to specify ledger type AA (actual amounts).
Enter a document type to use if you entered a specific ledger type code or leave this processing option blank to include all document types.
Enter 1 to print posted and unposted transactions or leave this processing option blank to print only posted transactions.
Enter a specific subledger or enter * to include all subledgers.
Enter a subledger type if you entered a specific subledger in the Subledger processing option.
Enter a specific currency code or enter * for all currency codes.
Alternatively, specify an as if currency code in which to print amounts for this report. This processing option allows you to review amounts in a currency other than the currency in which they are stored. Only amounts associated with the AA ledger type are converted to the as if currency. Specify the date on which to retrieve the exchange rate for the as if currency from the F0015 table. If you enter a value for the As If Currency Code processing option and leave this processing option blank, the system uses the current date.
Businesses in Spain are required to submit a trial balance to the Spanish tax authority. The statutory trial balance must be organized and summarized by object account. Businesses often print the T/B by Obj. Account report to facilitate:
Internal audits and verify one or more accounts.
External audits as required by a fiscal authority or auditing firm.
You can print the T/B by Obj. Account report to review the total debit and credit amounts for each account in any given ledger. You can also find errors that cause the general ledger to be out of balance. Possible errors might include incorrect entries or missing transactions.
The T/B by Obj. Account report for Spain includes these features:
Recognition of accounts with the same object account but different business units as the same account in the report.
Information selection by a specific period and fiscal year, and for a specific level of detail.
Ledger type selection.
Selection of a specific business unit to retrieve the account descriptions.
Optional totals by company.
Option to include accounts with zero balances.
Processing options enable you to specify the default processing for reports.
Enter the accounting period and the fiscal year. If you leave these processing options blank, the system uses the period and fiscal year of the financial reporting date of the company.
Enter up to three ledger types. If you leave all three processing options blank, the system uses ledger type AA.
Enter the model business unit to be use for the account descriptions. If you leave this processing option blank, the transaction descriptions are used.
Enter 1 to print accounts with zero balances or leave this processing option to not print them.
Enter the 1–4 character totaling level for the account. For example, Totaling Level 2 = Class Total (1) and Sub-class Total (10).
If you leave this processing option blank, the system uses totaling level 2.
Enter 1 to run the report in final mode or leave this processing option to run it in proof mode.
|
Note: You can run this report in final mode only once for the selected period and fiscal year. If you run the report again in final mode, the transactions will not appear. |
Enter 1 to summarize all subsidiary accounts into one object account. If you leave this processing option blank, subsidiary accounts are not summarized.
Specify an as if currency code in which to print amounts for this report. This processing option allows you to review amounts in a currency other than the currency in which they are stored.
If you leave this processing option blank, the company or transaction currency is used.
Specify the date on which to retrieve the exchange rate for the as if currency from the F0015 table. If you enter a value for the As If Currency Code processing option and leave this processing option blank, the system uses the current date.