37 Generate the Yearly List (Spesometro)

This chapter contains these topics:

Note:

The JD Edwards World software for Italy supports the completion of the fields required for tax payers that are companies. The software does not complete the fields in the text file when the tax payer is an individual.

37.1 About the Yearly List (Spesometro)

The Italian Tax Authorities (Agenzia delle Entrate) require that you annually submit text files that include information about the invoices and vouchers that you generate. To generate the annual list, you run the IYL Elect. Communications -TXT Generator program (P74Y0047). The IYL Elect. Communications -TXT Generator program generates the Multi-Purpose VAT Communication, which includes the transactions that you need to report for the Yearly List when you set the processing options in the IYL Elect. Communications -TXT Generator program to generate the Yearly List.

You must include in the Yearly List report this information about your customers and suppliers:

  • Company tax ID

  • Company additional tax ID

  • Supplier and customer tax ID information

  • Intermediary information, if applicable

  • Total taxable amount of the transactions in the period

  • Total tax amount, based on the total taxable amount

  • Adjustments to vouchers and invoices, including the date, taxable amount, and tax amount of the adjustment

37.1.1 Threshold Amounts

You use processing options in the IYL Elect. Communications -TXT Generator program to specify threshold amounts for business-to-consumer transactions (B2C) with and without invoices. Business-to-consumer transactions are considered non-invoice transactions, and typically do not have a standard invoice.

The system uses the threshold amount that you specify to determine whether to include the transaction in the Yearly List for the reporting year. You specify whether a transaction is B2C transaction with or without an invoice by entering a value in the Special Handling Code field of the 74Y/DT UDC table. Transactions below the threshold are not included in the report.

37.1.2 Exclusions

The system excludes these transactions from the Yearly List (Spesometro) report:

  • Vouchers and invoices for imports and exports to non-European Union (EU) countries.

    The system searches the values in the 74/EC UDC table to determine if the country is a non-EU country.

  • Transactions for EU countries that are included on the Italian black list report or purchases from suppliers in San Marino.

  • Intra-EU transactions.

  • Transaction assigned a payment instrument that is listed in the 74Y/PY UDC table.

  • Transactions assigned a document type for which the value in the Special Handling Code field of the 74Y/DT UDC table is 2.

  • Voided documents.

  • Transactions excluded due to values in the processing options.

37.1.3 Record Processing

The IYL Elect. Communications -TXT Generator program selects records to process from the Sales/Use/VAT Tax file (F0018). These factors determine the records that the system selects:

  • The batch type must be V, W or I.

    Records with batch type G are excluded.

  • The G/L date of the transaction, as recorded in the F0018 table, must be within the declaration year defined in the processing options.

  • The document type must be listed in the 74Y/DT (Document Type - Annual Report) UDC table, and the value in the Special Handling Code field is not 2 (exclude).

  • The payment type must not exist in the 74Y/PY (Payment Instrument Excluded) UDC table.

37.1.3.1 Record Selection and the 74Y/DT UDC Table

The system uses the values in the 74Y/DT UDC, the tax ID of the supplier or customer, and the processing options to determine whether to include records in the data selection. This list describes the data selection:

  • If the Special Handling Code (SHC) field is blank, or the tax rate area is not set up in the 74Y/DT UDC table, then the system considers the transaction to have an invoice.

    An invoice might be for a business-to-business (B2B) or a business-to-consumer (B2C) transaction. If the address book record for the customer or supplier includes a Partita IVA, then the system treats the transaction as a B2B invoice. If the address book record of the customer or supplier includes a Fiscal Code or Codice Fiscal, then the system treats the transaction as a B2C invoice.

  • If the SHC field is 1, then the transaction has an invoice (B2B or B2C).

37.1.4 Process to Generate the Yearly List (Spesometro) Report

When you set the processing option in the IYL Elect. Communications -TXT Generator program to generate the Multi-Purpose VAT Communication to include the data for the Yearly List report, the program:

  • Writes records to the Electronic Italy Yearly List - WF - Summary (T74Y0047) and Electronic Italy Yearly List - WF - Detail (T74Y0049) files.

  • Reads the records in the T74Y0047 and T74Y0049 files to generate an audit report (R74Y0049) in summary or detail mode.

    The summary report includes accumulated transaction amounts by batch type, and the alpha name. The detail reports lists each transaction by record type and address book number.

  • If you set the processing options to do so, generates a text file (F74Y0050).

To generate the Yearly List for customer and supplier transactions:

  1. Set up your system with required information:

  2. Post all vouchers.

  3. Process all invoices.

  4. Classify transactions.

    See Section 36.5, "Classify Transactions for Declarations"

  5. Run the IYL Elect. Communications -TXT Generator program.

    See Section 37.2, "Running the IYL Elect. Communications -TXT Generator Program"

    You can run the program to generate an audit report with summary or detail lines. You can also specify whether to generate the text files.

37.2 Running the IYL Elect. Communications -TXT Generator Program

Navigation

From EMEA Localizations (G74), choose Italy

From Italian Localizations (G74Y), choose IYL Electronic Communications

From Yearly List Electronic Communications (G74Y003), choose Flat File Generation

37.2.1 Setting Processing Options for IYL Elect. Communications -TXT Generator (P74Y0047)

See Chapter 45, "Processing Options for IYL Elec. Communications - TXT Generator (Workfile Generation) (P74Y0047)"

37.2.2 Running the IYL Elect. Communications -TXT Generator Program

Navigation

From EMEA Localizations (G74), choose Italy

From Italian Localizations (G74Y), choose IYL Electronic Communications

From Yearly List Electronic Communications (G74Y003), choose Flat File Generation

37.2.2.1 Setting Processing Options for IYL Elect. Communications -TXT Generator (P74Y0047)

See Chapter 45, "Processing Options for IYL Elec. Communications - TXT Generator (Workfile Generation) (P74Y0047)"

37.2.3 Additional Parameters

You must set up specific parameters for the IYL Elect. Communications -TXT Generator (P74Y0047) program to generate the text file.

Access the Additional Parameters screen, and then access the Spooled File Export Parms screen (F6). On the Spooled File Export Parms screen:

  • Enter iylec.txt in the Import Export File field.

  • Specify a path in the IFS Path field.

  • Enable fields in the Export section as needed.

See "Work with Import/Export" in the JD Edwards World Technical Tools Guide.