Understanding the Model 349 Workfiles

Use the 349 - Generate Acquisitions (R74S200) program to add information from the JD Edwards EnterpriseOne Accounts Payable system to the Model 349 workfiles. Use the 349 - Generate Sales (R74S210) program to add information from the JD Edwards EnterpriseOne Accounts Receivable system to the Model 349 workfiles. Both of the Model 349 generation programs create records 0, 1, and 2 in the Model 349 workfiles.

The 349 - Generate Acquisitions program summarizes transactions by company and by the customer's tax identification number from the customer's own EU country. The 349 - Generate Acquisitions program summarizes by supplier and the 349 - Generate Sales program summarizes by customer.

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

• F0101 - Address Book Master.

• F0411 - Accounts Payable Ledger.

• F03B11 - Customer Ledger.

• F740018A - Tax Rate Area and Transaction Type Mapping.

• F74S74 - Additional Information for 347 & 349 Models - Spain.

  Note: You can set the processing options to regenerate the workfile each time that you run the generation programs to create a new declaration. This is helpful, but not required.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 process transactions for the country selected or all transactions irrespective of the country. When you leave the country processing option blank, Model 349 works without considering company information in a country and shows all company transactions without filtering them by country.