(ESP) Processing the 347 Tax Declaration

This chapter provides an overview of the 347 tax declaration and discusses how to:

Generate the Model 347 workfiles.
Generate the 347 tax declaration tape file.
Revise Model 347 records.

Understanding the 347 Tax Declaration

Businesses in Spain with an annual volume exceeding 3.005,06 euros must submit the 347 tax declaration to the Spanish tax authority. The 347 tax declaration includes information about all accounts payable and accounts receivable transactions. The tax declaration also includes information about insurance and leasing transactions, as well as leasing information for buildings that are owned or maintained by the company.

If a large company is subdivided into subcompanies within the system, the parent company should report the consolidated information for all subcompanies.

The first step in processing the Model 347 declaration is to run the Model 347 - Generate Acquisition Records (R74S100) and Model 347 - Generate Sales Records (R74S110) programs to generate the Model 347 workfiles.

The Model 347 workfiles consist of these tables:

F74S70 - Model 347 - Record Type 0 - Spain.
F74S71 - Model 347 - Record Type 1 - Spain.
F74S72 - Model 347 - Record Type 2 - Spain.
F74S73 - Model 347 - Record Type 3 - Spain.
F74S75 - Model 347 - Link Between Rec.Type 0 and Rec. Type 1 - Spain.
F74S76 - Model 347 - Record Type 0 Tag File - Spain.
F74S77 - Model 347 - Record Type 1 Tag File - Spain.

This table explains the record types:

Record Type	Description
Record Type 0	Contains information about the number of records being submitted. Record type 0 is necessary only if you are using a single file to present tax information about two or more companies with different tax identification numbers.
Record Type 1	Contains information about company addresses, as well as the amount and number of records that are associated with each company. Record type 1 contains one record for each company with a different tax identification number for which the tax declaration is being made.
Record Type 2	Contains a summary of the amounts of selected transactions from AR and AP. Records are distinguished by the tax identification number of the customer or supplier, and by the type of operation (acquisitions or sales). Insurance operations and leasing operations are also identified.
Record Type 3	Contains the total amount of leasing operations and the address of the leased commercial site. Record Type 3 is necessary only if the company leases a commercial site to a customer.

The system uses the information in the Model 347 workfiles to produce the Model 347 - Dec. Companies Report and the 347 - Operations Report. You use the Model 347 - Print Records Type 1 - Spain program (R74S71) and the Model 347 - Print Records Types 2 & 3 - Spain program (R74S72) to print these required reports. The Model 347 workfiles are also used to generate the tape file that you submit to the Spanish tax authority.

This graphic illustrates the Model 347 process:

Processing the 347 Tax Declaration

Prerequisites

Before you complete the tasks in this section:

In the JD Edwards EnterpriseOne Address Book system, enter a tax identification number for each company, customer, and supplier.
If the business leases a commercial site, set up additional information for the site.
Set up additional information for the company that is submitting the tax declaration to the tax authority.

Generating the Model 347 Workfiles

This section provides an overview of the Model 347 workfiles and discusses how to:

Run the 347 - Generate Acquisitions (R74S100) program.
Set processing options for 347 - Generate Acquisitions (R74S100).
Run the 347 - Generate Sales (R74S110) program.
Setting processing options for 347 - Generate Sales (R74S110).

Understanding the Model 347 Workfiles

Use the Model 347 - Generate Acquisitions program (R74S100) to add information from the JD Edwards EnterpriseOne Accounts Payable system to the Model 347 workfiles. Use the 347 - Generate Sales program (R74S110) to add information from the JD Edwards EnterpriseOne Accounts Receivable system to the Model 347 workfiles.

The 347 - Generate Acquisition and 347 - Generate Sales programs summarize transactions by the customer's or supplier's tax identification number.

The 347 - Generate Acquisitions and the 347 - Generate Sales programs retrieve information from these tables to build the Model 347 workfiles:

F0101 - Address Book Master.
F0411 - Accounts Payable Ledger.
F03B11 - Customer Ledger.
F74S74 - Additional Information for 347 & 349 Models - Spain.

The system populates the Zip Code field in the Model 347 workfiles based on information in the address book. For domestic customers and suppliers, the system appends three zeros to the first two digits of the customer's or supplier's zip code from the address book. For international customers and suppliers, the system uses 99 plus the customer's or supplier's three-digit country code from user-defined code (UDC) (00/CN).

You use the processing options on the 347 - Generate Acquisitions and the 347 - Generate Sales programs to specify general information that must be included on the declaration.

Important! You must define specific data selection to generate the correct information in the Model 347 workfiles. For example, you might define the data selection based on company, GL period, and document type that correspond to a specific operation type and class. You need to run the generation programs several times with different data selections to record information on all operation types and classes.

You should set the processing options to regenerate the workfile only the first time that you run one of the generation programs to clear existing information for the company and declaration year that are specified in the processing options. Whether you run 347 - Generate Acquisitions or 347 - Generate Sales first does not matter.

Running the 347 - Generate Acquisitions (R74S100) Program

From the Process 347 - Spain menu (G74S8011), select 347 - Generate Acquisitions.

Setting Processing Options for 347 - Generate Acquisitions (R74S100)

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

Presentation

1. Company

Enter the Company who is sending the declaration. (Required)

Common Data

1. Declaration Year	Enter the Declaration Year (4 Digits). Specify the year of the 347 or 349 declaration to be presented.
2. Tax Office Number	Enter the Tax Office Number. Specify the Tax Office Number where the declaration has to be presented. The number is assigned by the Spanish Tax Organism for the company.
3. Code	Enter the County Code ( 3 digits) for the company.
4. Line Number	Enter the Line Number to get the Contact Name from Company's Who's Who. If it is left blank, the default value will be 1.
5. Declaration Type	Declaration Type Blank = Current Declaration 1 = Complementary 2 = Substitute
6. Previous Declaration Number	Previous Declaration Number

Regeneration

1. Regenerate Files: Selection

Blanks - Add information into the files

1 - Regenerate files

Amount

1. Minimum Amount

Enter the minimum amount per supplier or customer that must be declared. If left this option in blank, the process will use 500.000 ESP.

Currency

1. Currency Code	Enter the Company Currency Code.
2. Currency Code	Enter the Third Currency Code.

Operation Type

1. Operation Type

Enter the Operation Type.

A = Acquisitions

D = Acq. EP

C = Payments

2. Operation Class

Enter the Operation Class.

0 = Regular Operations.

1 = Insurance Operations.

2 = Leasing Operations.

Running the 347 - Generate Sales (R74S110) Program

From the Process 347 - Spain menu (G74S8011), select 347 - Generate Sales.

Setting Processing Options for 347 - Generate Sales (R74S110)

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

Presentation

1. Company

Enter the Company who is sending the declaration. (Required)

Common Data

1. Declaration Year	Enter the Declaration Year (4 Digits). Specify the year of the 347 or 349 declaration to be presented.
2. Tax Office Number	Enter the Tax Office Number. This field contains the Tax Office Number where the declaration has to be presented. The number is assigned by the Spanish Tax Organism for the company.
3. Code	Enter the County Code ( 3 digits) for the company.
4. Line Number	Enter the Line Number to get the Contact Name from Company's Who's Who. If it is left blank, the default value will be 1.
5. Declaration Type	Declaration Type Blank = Current Declaration 1 = Complementary 2 = Substitute
6. Previous Declaration Number	Previous Declaration Number

Regeneration

1. Regenerate Files: Selection

Blanks - Add information into the files

1 - Regenerate files

Amount

1. Minimum Amount

Enter the minimum amount per supplier or customer that must be declared. If left this option is blank, the process will use 500.000 ESP.

Currency

1. Currency Code	Enter the Company Currency Code.
2. Currency Code	Enter the Third Currency Code.

Operation Type

1. Operation Type

Enter the Operation Type.

A = Acquisitions

D = Acq. EP

C = Payments

2. Operation Class

Enter the Operation Class.

0 = Regular Operations.

1 = Insurance Operations.

2 = Leasing Operations.

Generating the 347 Tax Declaration Tape File

This section provides an overview of the 347 tax declaration tape file and discusses how to:

Run the 347 - Generate Tape File (R74S120) program.
Set processing options for 347 - Generate Tape File (R74S120).

Understanding the 347 Tax Declaration Tape File

Use the 347 - Generate Tape File program to generate the tape file that you submit to the Spanish tax authority. The tape file contains information from these Model 347 workfiles:

F74S70 - Model 347 - Record Type 0 - Spain.
F74S71 - Model 347 - Record Type 1 - Spain.
F74S72 - Model 347 - Record Type 2 - Spain.
F74S73 - Model 347 - Record Type 3 - Spain.
F74S75 - Model 347 - Link Between Rec. Type 0 and Rec. Type 1 - Spain.
F74S76 - Model 347 - Record Type 0 Tag File - Spain.
F74S77 - Model 347 - Record Type 1 Tag File - Spain.

The 347 - Generate Tape File program creates Text File Processor batches that contain the declaration.

Running the 347 - Generate Tape File (R74S120) Program

From the Process 347 - Spain menu (G74S8011), select 347 - Generate Tape File.

Setting Processing Options for 347 - Generate Tape File (R74S120)

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

Company

1. Company

Enter the Company who is sending the declaration. (Required)

Default

Declaration Year	1. Enter the Declaration Year (4 Digits). Specify the year of the 347 or 349 declaration to be presented.
2. Transaction Currency	Enter currency for the transaction Blank = Peseta 1 = Euro
3. Declaration Number	Enter the Declaration Number
4. Media Type	Blank = Tape 1 = Disk
5. Create Record	Create Record Type 0 Blank = Yes 1 = No

Revising Model 347 Records

This section provides an overview and discusses how to revise model 347 records.

After you have generated the Model 347 workfiles, you can revise information in the Model 347 workfiles.

Note. The information that you can revise is the same information that appears on the 347 - Operations Report (R74S72) and the 347 - Dec. Company Report (R74S71) reports.

Forms Used to Revise Model 347 Records

Form Name	FormID	Navigation	Usage
Work With Pres. Companies	W74S349L	Process 347 - Spain menu (G74S8011), 347 - Operations Revision.	Select records.
Presented Company Revisions	W74S347M	On Work With Pres. Companies, select Company Revisions from the Row menu.	Revise the name and address of the presenting (parent) company.
Work With Declared Companies	W74S347B	On Work With Pres. Companies, click Select.	Access the Dec. Company Revisions form.
Dec. Companies Revisions	W74S347K	On Work With Declared Companies, select Edit Company from the Row menu.	Review acquisition and sales totals for a declaring company.
Work With C & V Operations	W74S347P	On Work With Declared Companies, click Select. On Work With C & V Operations, click Find.	Review transaction detail for a declaring company.
Work With C & V Operations	W74S347P	On Work With C & V Operations, select Change Tax ID from the Row menu. The system validates the tax ID that you enter.	Revise a customer's or vendor's tax ID.
C & V Operations Revisions	W74S347D	On Work With C & V Operations, select C & V Revisions from the Row menu.	Revise a customer's or vendor's name, province, and total operations amount.
Work with Leasing Operations	W74S347V	On Work With C & V Operations, select a row that represents leasing transactions, and then click Select.	Revise leasing information for a customer or vendor.