Generating Issued Invoice Register - ESP - 00 Report (R74S600)

Note: The Issued Invoices Register report requires the same setup as Model 340 VAT report for Spain. See "Processing the Model 340 VAT Report in Spain".

Use the Issued Invoice Register - ESP - 00 (R74S600) report to print all XML fields required in issued invoice additions/modifications.

Note: To print the issued invoices register report in XML format, you set processing options for version XJDE0001. To print in PDF, Excel, or RTF format, you set processing options for version XJDE0002.

Before you generate the Issued Invoice Register report, you should be familiar with this information:

Topic

Description

Issued invoice register transactions

The transactions that are included under Issued Invoices register are:

  • Issued invoices that are not for intracommunity VAT that have a batch type of IB when the value for the Description 2 field of the document type set up in UDC 74S/RL is a value other than P or it does not exist in UDC 74S/RL, and the value in the Description 2 field of the tax rate area set up in UDC 74S/RT is a value other than P or it does not exist in UDC 74S/RT.

  • Issued invoices with a batch type of G when the value for the Description 2 field of the document type set up in UDC 74S/RL is C, or the value in the Description 2 field of the tax rate area set up in UDC 74S/RT is C. If the document type doesn't exist in UDC 74S/RL, then the system looks at UDC 74S/RT. If neither UDC table includes the appropriate setup, the transaction is not included.

  • The positive line amount for VAT for a reverse charge transaction.

Reverse charges transactions

A reverse charges transaction satisfies the following conditions:

  • Tax rate area is set up in the F744008 table.

  • The transaction is not a special intra-community transaction as set up in the Tax Areas - Tag File Maintenance - ESP program (P74S408).

  • Either the value for the Description 2 field of the document type set up in 74S/RL is X, or the value in the Description 2 field of the tax rate area set up in 74S/RT is X. During the process, the system searches for the document type in 74S/RL. If the document type does not exist in the 74S/RL UDC table, then the system searches for the tax rate area in 74S/RT UDC.

Rectification Invoice

The rectification invoice satisfies the following conditions:

  • The invoice type is set up as R1, R2, R3, R4, or R5.

  • The original document(s) is associated with the invoice in the Related Invoices for CN/DN program (P7430016).

Before you generate the Issued Invoice Register report, you set the processing options:

Default

  1. Enter the Company ID of the Company sending the Declaration

  2. Enter the Invoice Year (4 digits)

  3. Enter the Declaration Period

  4. Enter the Tax Rate Area line for reverse charge (in%)

  5. Enter the Communication Transaction Type

Process

  1. Retroactive Reporting

    You can enable or disable retroactive reporting. When the feature is enabled, you can use it for:

    • Generating a report for 2017 semester 1 transactions.

    • Reporting transactions for customers that adhere to SII throughout the fiscal year.

      According to the retroactive reporting standards, these customers must submit all transactions of the same fiscal year or previous year to adhere to SII. For example, if a company adheres to SII on March 17, 2019, before year end (31 December 2019) they will have to submit transactions from January 1, 2019 through March 16, 2019 (both inclusive).

  2. Date Range

    If you enable retroactive reporting, you must specify the date range for data selection. The system retrieves the invoice year and invoice period from the values set up in the default tab processing options.

Note:
  • You must set up all the mandatory fields to print them in the XML file. The fields in the XML file that print VAT percentage value do not accept negative value; therefore you should set up the tax rate accordingly.

  • You can have a maximum of six different tax rate areas or tax rates for one transaction.