Country-specific update for Italy which supports Quarterly VAT payment communication generation in XML format in Microsoft Dynamics AX

This article applies to Microsoft Dynamics AX 2009 SP1, AX 2012, AX 2012 R2, AX 2012 R3 for Italy (IT).

Introduction

According to Legislative Decree no. 127/2015, art. 1 and Decree Law 78/2010, art. 21 all companies in Italy must transmit electronically in XML format the Periodic VAT payment Communication (COMUNICAZIONE IVA PERIODICA CON PROSPETTO DI LIQUIDAZIONE) on a quarterly basis.

To meet this new legislative requirement an existing Dynamics AX functionality Yearly tax communication was modified.

This update introduces the changes in Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 RTM and Microsoft Dynamics AX 2009 SP1 that will allow users in legal entities in Italy to generate Quarterly VAT payment communication in XML format.

Quarterly VAT payment communication Guidance

Setup

Setup for Yearly tax communication valid until January 1^st of 2017 was not changed. To do it open General ledger > Setup > Sales tax > External > Periodic VAT communication setup and select Yearly communication in Communication type field.

To setup Quarterly VAT payment communication use the same form General ledger > Setup > Sales tax > External > Periodic VAT communication. Select Quarterly communication in Communication type field.

Add all the tags from the XSD schema that are applicable for your company in Field setup table. Compliance with the order of adding tags in accordance with the scheme is desirable, but not necessarily because it can be corrected when creating a report. Field setup table fields description:

Field name	Description
Report level	Select one of the following values: Header – if the tag you are going to add is from Header <Intestazione> block of the schema. Communication – if the tag you are going to add is from Communication header <Frontespizio> parts of the schema. Accounting data
Field ID	Enter tag name according to schema. For example: TotaleOperazioniAttive. Do not add the following tags as these tags will be added automatically by the system: CodiceFornitura – value “IVP17” IdSistema – empty value CodiceFiscale – Fiscal code from the Company information AnnoImposta – the year that a user will set up on a dialog form as an input parameter on creating a new report. PartitaIVA - Tax Registration number from the Company information IdentificativoProdSoftware - Software name (Microsoft Dynamics AX) Mese – months related to the quarter that a user will set up on a dialog form as an input parameter on creating a new report Trimestre – quarter number that a user will set up on a dialog form as an input parameter on creating a new report
Description	Add a text description of the tag.
Format	Select one of the values from the combobox. The corresponding field’s value will be checked automatically by the system according to the specific rules described in the table below.
Calculation	Select one of the following values: Manual – for the tags value for which a user will add manually Tax transaction – for the tags values for which should be collected from tax transactions Total – for the tags values for which should be calculated by a formula composed of other (not Total) fields values. Previous year VAT credit – for tag CreditoAnnoPrecedente only Previous period VAT credit – for tag CreditoPeriodoPrecedente only Previous period VAT debit – for tag DebitoPrecedente only
Value	This column can be edited for field with Calculation set up to Manual. Enter a value that will be used as a default value. For tags from Modulo block the value should be entered for month.
Tax	Select one of the following values: Tax base – for tags that should represent a taxable amount. For example: TotaleOperazioniAttive, TotaleOperazioniPassive. Tax amount – for tags that should represent a tax amount. For example: IvaEsigibile, IvaDetratta.
Sign	Set “1” if the value should be represented as is. Set “-1” if the value should be inversed. For example, for tags: TotaleOperazioniAttive, IvaEsigibile, ImportoACredito
Sales tax charge	Select this checkbox when Calculation = Tax transaction and Tax = Tax amount if you suppose that the calculated tax amount should be reduced on the calculated nondeductible tax amount. For example, for tag IvaDetratta.

Fields Formats description

Format type Name (UI en-us)	Format type Name (UI it)	Type	Rule
Fiscal code	Codice Fiscale	String	[0-9]{11}\|[A-Z]{6}[0-9LMNPQRSTUV]{2}[A-Z]{1}[0-9LMNPQRSTUV]{2}[A-Z]{1}[0-9LMNPQRSTUV]{3}[A-Z]{1}
Numeric	Numerico	Numeric	use ',' as decimal separator
Flag	Flag	Boolean	"0" or "1"
Commitment submission	Impegno presentazione	Integer	"1" or "2"
Charge code	Codice carica	Integer	[1], [2], [3], [4], [5], [6], [7], [8], [9], [11], [12], [13], [14], [15]
Date	Data	Date	(It) ggmmaaaa = (en-us) ddMMyyyy
Vat registration	Partita IVA	String	11 symbols
String	Stringa	String	0..16 symbols
Exceptional events	Eventi eccezionali	Integer	[1], [9]
Last month	Ultimo mese	Integer	[1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [13], [99]

Additional setup for fields with Calculation type set up to Total.

The Additional setup for fields with Calculation type set up to Total allows to automatically calculate values for tags that should represent a result calculated by a formula composed of other (not Total) fields values.

Select in Field setup table a line related to a field value for which should be calculated, open tab Total amount and fill in the table:

Field name

Description

Sign

Set “1” if the value should be taken into account as is.

Set “-1” if the value should be inversed.

Field ID

Select a tag name the related value of which should be taken into account. Tags with Calculation type set up to Total cannot be selected here.

For example:

Field name

Example formula

IvaDovuta,

Sign	Field ID
1	IvaEsigibile
-1	IvaDetratta

IvaCredito

The same formula as for IvaDovuta but Sign in Field setup table should be set up “-1”

ImportoDaVersare

Sign	Field ID
1	IvaEsigibile
-1	IvaDetratta
1	DebitoPrecedente
1	InteressiDovuti
-1	CreditiImposta
-1	CreditoPeriodoPrecedente
-1	CreditoAnnoPrecedente
-1	VersamentiAautoUE
-1	Acconto

ImportoACredito

The same formula as for ImportoDaVersare but Sign in Field setup table should be set up “-1”

Additional setup for fields with Calculation type set up to Tax transactions.

The additional setup of fields with Calculation type set up to Tax transactions allow to automatically calculate values for tags that should represent values based on tax transaction. For example, tags: TotaleOperazioniAttive, TotaleOperazioniPassive, IvaEsigibile, IvaDetratta.

Select in Field setup table a line related to a field value for which should represent a taxable amount or tax amount, open tab Selected tax codes and fill in the table:

Field name	Description
Sales tax code	Select a Sales tax code from a Sales tax codes table tax transactions by which should be taken into account.

Click an Exceptions button to set up Main accounts that should be excluded from the query.

Click Query button on the menu on the top of the setup form and setup query as following:

Field name

Description

Sales tax direction

Select sales tax direction which a subject to a selected tag.

For example:

for tag TotaleOperazioniAttive sales tax direction can be set up to “Sales tax payable, Tax-free sale”
for tag TotaleOperazioniPassive sales tax direction can be set up to “Sales tax receivable”

Set up Number sequences for Quarterly VAT payment communication

Open General ledger > Setup > General ledger parameters, open Number sequences tab and set up a new Number sequence for Tax communication XML ID reference. It is preferable to set up a number sequence length to 5 and format to ##### as this number sequence will be used as part of the file name.

Create Periodic VAT payment report

You can create Yearly tax communication valid until January 1^st of 2017 as previously as the format and generation engine were not changed. To do it open General ledger > Reports > External > Periodic VAT communication. Click Create button on the top of the Periodic VAT communication form and setup a year for which you are going to create a new report. Leave Quarter field black. Click OK. System will create a new Yearly tax communication report according to rules predefined for this type of Periodic VAT communication.

To create a new Quarterly VAT payment communication, use the same form General ledger > Reports > External > Periodic VAT communication. Click Create button on the top of the Periodic VAT communication form and setup a year and a quarter for which you are going to create a new report. Click OK. System will create a new Quarterly VAT payment communication report according to rules predefined for this type of Periodic VAT communication.

Click Open button on the form menu on the top to open the created report.

This form represents the created report reflecting different schema blocks on different tabs:

Tab name	Description
Quarterly header	This block includes all the fields that were setup with Report level = Header. Related tags will be included into XML block under tag Intestazione.
Communication	This block includes all the fields that were setup with Report level = Communication. Related tags will be included into XML block under tag Frontespizio.
Report lines	This block includes all the fields that were setup with Report level = Accountinf data. Related tags will be included into XML block under tag Modulo.

Each of three tabs allow user to manually delete or add new tags and move tags up and down according the schema requirement. You can change values for fields with Calculation type = Manual.

The following tags will not be included into XML file:

If Calculation type = Manual and Value = 0,00 or empty,
If Calculation type = Total and Value is negative.

Generate Quarterly VAT payment communication

To generate an XML file for a Quarterly VAT payment communication, select a report in the General ledger > Reports > External > Periodic VAT communication, click Export to button on the form menu on the top and fill in the fields:

Field name

Description

File name

Enter a path and name for the XML file. System automatically generate the file name according to the specific rule and taking into account the Number sequence set up in General ledger paraments for Tax communication XML ID reference.

Accounting data schema

Select one of the following values:

Quarter – if you want to generate an XML file with one Modulo block related to the selected quarter.
Month – if you want to generate an XML file with three Modulo blocks related to three months of the selected quarter.

Click OK button to generate a file.

To cancel a check box Exported on the report click Delete export button on the form menu.

To delete a report, select it and use a hot keys combination of Alt+F9.

More Information

Hotfix information

A supported hotfix is available from Microsoft. There is a "Hotfix download available" section at the top of this Knowledge Base article. If you are encountering an issue downloading, installing this hotfix, or have other technical support questions, contact your partner or, if enrolled in a support plan directly with Microsoft, you can contact technical support for Microsoft Dynamics and create a new support request. To do this, visit the following Microsoft website:

https://mbs.microsoft.com/support/newstart.aspx

You can also contact technical support for Microsoft Dynamics by phone using these links for country specific phone numbers. To do this, visit one of the following Microsoft websites:

Partners

https://mbs.microsoft.com/partnersource/resources/support/supportinformation/Global+Support+Contacts

Customers

https://mbs.microsoft.com/customersource/support/information/SupportInformation/global_support_contacts_eng.htm

In special cases, charges that are ordinarily incurred for support calls may be canceled if a Technical Support Professional for Microsoft Dynamics and related products determines that a specific update will resolve your problem. The usual support costs will apply to any additional support questions and issues that do not qualify for the specific update in question.