What You Should Know About the Model 340 - Generate VAT Tape File Program

Before you generate the text file, you should be familiar with this information:

Topic	Description
Compatibility with the VAT Report by Tax Rate/Areas program (R74S450)	You must report the same transactions in the annual VAT Report by Tax Rate/Areas report as you report in the Spain Model 340 VAT report. The Model 340 VAT report enables you to include general ledger transactions that the VAT Report by Tax Rate/Areas report does not include. If you set up your system to include the additional general ledger transactions in the Model 340 VAT report, you must customize your VAT Report by Tax Rate/Areas report to include those transactions. Oracle does not support customizations to your VAT Report by Tax Rate/Areas report.
Report output	In addition to the text file, the Model 340 - Generate VAT Tape File program generates a PDF file that you can use to review the transactions. You can run the report in proof mode, review the PDF file, correct errors, and then run the report in final mode to update tables. The PDF file includes the information that appears in the Record Type 1 block of information, such as the reporting period, declarant name and NIF (Numero de Identificacion Fiscal), and so on. The report also lists the totals for the emitted and received invoices, and the special intracommunity VAT transactions, as well as a warning if the number of records exceeds the maximum allowed number for electronic transmissions. Note: If the records exceed 5,000,000, you must submit the file using a DVD-R or DVD+R.
Currency	All amounts in the text file are retrieved from domestic amount fields. The currency is the euro.
Formatting of values in the text file	Numeric fields are adjusted (aligned) to the right and padded with zeroes to the left. Numeric values are displayed without signs (+ or −). If the system does not write a value to a numeric field, the system completes the position of the field with zeros. Alphabetic and alphanumeric fields are adjusted (aligned) to the left and padded with blanks to the right. The text appears in capital letters and without accent marks, except that the characters Ç and Ñ are included. Alphabetic and alphanumeric fields for which the system does not write values are left blank.
System actions in proof, reprocess, and final modes	The system uses values for the processing mode and for the type of submission (original, complementary, or substitute) to determine how to process records. In final mode, if the report finished without errors or warnings, the system: Saves the data for the processed transactions to the V.A.T. Declaration Mark File table (F74S340). Updates the declaration number in the F74S340 table. You run the report in reprocess mode only if the report, while running in final mode, did not finish due to technical issues.
Errors and warnings	The system reports errors and warnings in the Work Center. The PDF report includes text referring you to the Work Center. The system codes the text file in the F007101 and F007111 tables with the code for corrupt/outbound if the report ends with an error and codes the text file with the code for unprocessed if the report ends with a warning. If the tax rate area line processing option for a received invoice with tax amount equal to zero has tax rate other than 0, then the report generates a warning, indicating that this processing option must include a tax rate equal to 0.
Exclusions	The Model 340 - Generate VAT Tape File program does not process fixed asset transactions subject to prorate VAT.