QAD Internationalization Extensions, Spain 1.4 > User Guide > Spanish Reports > Model 349 Statement
  
Model 349 Statement
Business Requirement
Spanish legal requirements include the Model 349 statement, a monthly VAT statement that lists every transaction related to movements of goods within the EU (European Union), either supply of goods from Spain to another EU country or goods purchased from an EU country coming into Spain.
Two different formats for Model 349 should be provided:
• State format
• Regional format
Model 349 must be declared using the Web site of the government tax authority, and an electronic media format is required to upload the records.
QAD Solution
QAD has developed the Model 349 Statement report to meet Spanish requirements.
Prerequisites
• Business relation records must include telephone numbers for the delivered Model 349 Statement. Contact person names are optional in setup records, although they are required on the report output.
• System and GTM setup must be complete.
• Sequence number setup must be complete.
• Generalized codes setup must be complete.
• AR and AP invoice transactions must exist.
Sequence Number Setup
Use Number Range Maintenance (36.2.21.1) to create a sequence for the Model 349 Statement ID number, as in Number Range Maintenance. Each time that you print the statement, you can select a field in the selection criteria—Final Print—to specify that the statement contains an incremented ID number based on the sequence defined in Number Range Maintenance.
For more information on number range maintenance, see QAD System Administration Guide.

Number Range Maintenance
Generalized Codes Setup
Use Generalized Codes Maintenance (36.2.13) to set up the generalized codes that the statement requires.

Generalized Codes Maintenance for the Model 349 Statement

List of Generalized Codes for the Model 349 Statement
 
Field Name
Description
349_TAXTYPE_ES
Comma-separated list of default values for the Tax Type report filter.
349_TAXCLASS_ES
Comma-separated list of default values for the Tax Class report filter.
349_TAXUSAGE_ES
Comma-separated list of default values for the Tax Usage report filter.
349_TAXUSAGE_SERVICE
Tax usage for service. This value appears as a default value in the Tax Usage report filter.
349_OUT_DIR_ES
Default value for the output directory where the Model 349 Statement is saved.
Tax Type, Tax Box, Tax Group, and Tax Usage Setup
A number of values need to be set up for tax class, tax type, tax box, tax group, and tax usage setup. See Report Access for more information.
Report Access
Access Spain Model 349 (29.6.3.34.4).

Model 349 Statement Report, Selection Screen
Most of the fields on the Model 349 Statement report screen are identical to those described for the Model 340, beginning on here. The differences are as follows:
• The Declaration type and Last Edition fields are not included on the Model 349 Statement.
• The Format field includes an additional option. You can enter D to generate the report output to disk in a human-readable format.
• The government-specified naming convention applied when Create File is selected is different. This is determined by the value of Model:
• State: IEU.MMYY
• Regional: IEUForal.MMYY
• If you want to generate the final version of the statement, select the Final Print field so that a new sequential declaration identification number is added in positions 108-120 of the statement.

Model 349 Statement, Output File for a Regional Report