1. Localizations for Spain Implementation Guide
  2. Understanding the Model 347 Workfiles

Understanding the Model 347 Workfiles

Use the 347 - Generate Acquisitions (R74S100) program to add information from the JD Edwards EnterpriseOne Accounts Payable system to the Model 347 workfiles. Use the 347 - Generate Sales (R74S110) program 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:

  • Address Book Master (F0101)

  • Accounts Payable Ledger (F0411)

  • Customer Ledger (F03B11)

  • Additional Information for 347 & 349 Models (F74S74)

  • Additional Information for 347 & 349 Models - Tag file - Spain (F74S78)

  • Additional Information for Model 347 - Record Type 2 Tag File - Spain (F74S79).

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 whether to run the report for a country and also to specify the 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.Also, you must define the processing options to specify whether to retrieve company information by country. When you process the report for a country, you can also process transactions for the country selected or all transaction irrespective of the country.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. It does not matter whether you run 347 - Generate Acquisitions or 347 - Generate Sales first.