Purchase and sales invoices communication in xml (DatiFattura) in the Italian version of Microsoft Dynamics NAV

Applies to: Dynamics NAV 2013 R2Microsoft Dynamics NAV 2015Dynamics NAV 2016

September 2017

According to Legislative Decree no. 127/2015, art. 1 and Decree Law 78/2010, art. 21, companies are required to transmit the following information electronically - DATIFATTURA [Invoices issued and Invoices received].

Purchases and Sales Invoices Communication must be transmitted to the Italian Inland Revenue quarterly. Companies must submit data for year 2017 on semiannual basis (every half year). For year 2018 and onwards, companies must submit this data by the last day of the second month following each quarter.

First communication of the Purchases and Sales Invoices Communication transmission in 2017 needs to be done by 18th of September.

Overview


This regulatory update provides users with functionality to collect, verify and export data about received and submitted invoices as per requirements defined by Italian Tax Authority (Datifattura requirement for Spesometro communication).

Reference Information


Reference No.

203663

Product Area

Financial Management

Discovered in

Microsoft Dynamics NAV 2013, 2013 R2, 2015, 2016 and 2017

Title

[IT] Purchase and Sales Invoices communication in xml

Released on

September 2017

Important notice to customers


We recommend that you contact your Microsoft Dynamics Partner before installing service packs or hotfixes. It is important to verify that your environment is compatible with the service pack(s), hotfix(es), or download(s) being installed. A service pack, hotfix, or download may cause interoperability issues with customizations, and third-party products that work with your Microsoft Dynamics solutions.

Important Notice to Partners


As per the SPA, it is non-compliant for partners to redistribute tax and regulatory updates to ERP customers not enrolled in the Business Ready Enhancement Plan. Partners can verify their customer’s status in VOICE. If they're not enrolled, Partners will need to get them current before they can distribute.

Installation


Before this update can be installed, the following prerequisites are required:

Installation Steps

 

For more information about how to install an update rollup, click the following article number to view the article in the Microsoft Knowledge Base:

  • 2834770  - How to install a Microsoft Dynamics NAV 2013 Cumulative Update
  • 2834770  - How to install a Microsoft Dynamics NAV 2013 R2 Cumulative Update
  • 3021418  - How to Install a Microsoft Dynamics NAV 2015 Cumulative Update
  • 3109325  - How to install a Microsoft Dynamics NAV 2016 Cumulative Update
  • 3204818  - How to install a Microsoft Dynamics NAV 2017 Cumulative Update

Note:

  • Existing customizations in objects that are included in this update file may break when you import the regulatory feature.
  • No data upgrade is required before you can use this feature. 

Licensing


Refresh your license to access the new objects that are added with this release.

Objects


The following object have been added / modified through this release:

Type

No.

Name

Added/Modified

Codeunit

740

VAT Report Mediator

Modified

Codeunit

741

VAT Report Release/Reopen

Modified

Codeunit

743

VAT Report Export

Modified

Page

472

VAT Posting Setup

Modified

Page

743

VAT Report Setup

Modified

Page

740

VAT Report

Modified

Page

741

VAT Report Subform

Modified

Table

254

VAT Entry

Modified

Table

325

VAT Posting Setup

Modified

Table

740

VAT Report Header

Modified

Table

741

VAT Report Line

Modified

Codeunit

12182

Datifattura Export

Added

Codeunit

12183

Datifattura Validate

Added

Table

12202

VAT Transaction Nature

Added

Page

12202

VAT Transaction Nature

Added

Report

12195

Datifattura Suggest Lines

Added

Setup


To start using this feature following activities need to be performed:

Setup VAT Transaction Nature mapping to VAT Posting Setup

VAT Transaction Nature attribute is required for Datifattura export and maps to <Natura> elements of XML file system needs to generate. To be able to export this information system needs a way of mapping VAT Business and Product Posting Group to VAT Transaction Nature.

To set up mapping of VAT Transaction Nature to VAT Posting Setup for Datifattura export user follows these steps:

  1. User searches for VAT Posting Setup.
  2. VAT Posting Setup window opens.

    Screenshot for the VAT Posting Setup window
  3. User click on lookup button in VAT Transaction Nature column and then advanced to open list of VAT Transaction Nature codes.
  4. VAT Transaction Nature window opens.
  5. User enters Code and Description for each VAT Transaction Nature.

    Screenshot for the VAT Transaction Nature window
  6. User selects VAT Transaction Nature he wants to map to VAT Posting Setup and clicks OK.

Preparing Datifattura export

At the end of the reporting period user prepares Datifattura export file that he uploads to Tax Authorities web site. User does this following these steps:

  1. User searches for VAT Reports.
  2. VAT Reports list opens.

    Screenshot for the VAT Report List window
  3. User creates new VAT Report by clicking New action.
  4. New VAT Report is created.

    Screenshot for the VAT Report window
  5. User selects VAT Report Config. Code Datifattura and enters Starting and Ending Date of reporting period for which Datifattura export is being prepared.
  6. User clicks Suggest Lines to have system bring in the lines for reporting period.
  7. Lines of VAT Report are filled in with data.

    Screenshot for the lines of the VAT report
  8. User clicks Release to verify data in VAT Report are valid for export.
  9. If there are issues with data, Error messages window pops up with the list of errors.

    Screenshot for Error Messages window
  10. Once all errors in VAT Report are addressed, VAT Report gets status Released which means it is ready to be exported
  11. User clicks Export to export Datifattura XML file.
  12. Once exported Datifattura XML file has been successfully uploaded to Tax Authorities web site, user enters Tax Auth. Receipt No. and Tax Auth. Doc. No. provided by Tax Authority in header of VAT Report. 
  13. After that, user clicks Mark as Submitted to change status of VAT Report to Submitted.

Canceling submittes datifattura file

In order to correct submittes datifattura file user sent to tax authorities, user can create cancelation file following these steps:

  1. User searches for VAT Reports.
  2. VAT Reports list opens.

    Screenshot for the VAT Report List window
  3. User creates new VAT Report by clicking New action.
  4. New VAT Report is created.

    Screenshot for a new VAT report
  5. User selects VAT Report Config. Code Datifattura and VAT Report Type Cancelation.
  6. After that user clicks lookup button in Original Report No. to select submitted report he wants to cancel.
  7. Once, Original Report No. is selected user clicks Export to prepare cancelation XML file.

Important notes regarding datifattura XML file

  • <TipoDocument> attribute is mapping notes:
    • TD05 (debit note) is not supported as Dynamics NAV does not distinguish between invoices and debit notes
    • TD07 and TD08 (simplified invoice/credit memo) handled as normal invoices/credit memos
    • TD10 and TD11 (intracommunity goods/services purchase invoices) are determined based on country/region of vendor being from EU and Base amount of VAT with EU Service flag (TD11) versus Base Amount of VAT without EU Service flag (TD10). If document contains both goods and services it will be categorized as TD10 or TD11 based on total base amount value of lines relating to goods and services (whichever is higher)
  • <ProgressivoInvio> are not supported at this point as corrections requirements were not clear at the moment of development of this feature
  • Corrective reports and positioning of documents with datifattura file are also not supported as corrections requirements were not clear at the moment of development of this feature
  • Feature supports only manual upload of datifattura file to Tax Authority

Support Information


If you are experiencing issues downloading the install file or documentation, please contact ITMBSSUP@microsoft.com.

For technical support questions, contact your partner or, if enrolled in a support plan directly with Microsoft, you can enter a new support request to Microsoft Dynamics® Technical Support from Customer Source or Partner Source under Support >> New Support Request.

You can also contact Microsoft Dynamics® Technical Support by phone using these links for country specific phone numbers.
Partners -
Global Support Contacts (requires Partner Source login)
Customers -
Global Support Contacts (requires Customer Source login)

Linguistic Quality Feedback


Thank you for taking the time to give us your feedback. It will be used to evaluate the linguistic quality of the translated Dynamics NAV user interface and make improvements if needed.

Please use this feedback link to provide your feedback to the below questions.

Q1: Which language and version of the product are you working on?

Q2: What is your role in your organization / company?

Q3: Is the used terminology correct for your market/locale?

Q4: Please include any other feedback you may have on the linguistic quality of the product.

Privacy Statement: Microsoft is committed to protecting your privacy, while delivering software that brings you the performance, power, and convenience you desire in your personal computing. This privacy statement explains the data collection and use practices. It does not apply to other online or offline Microsoft sites, products, or services.

If you choose to provide feedback about the linguistic quality of this regulatory feature, then your email address and any additional information that you choose to provide will be included. We will only use your feedback data to help improve the linguistic quality. Microsoft will not contact you to further investigate your feedback or to ask you for more information. Your email address will be removed from our systems after 90 days.