A country-specific update for Spain: SII functionality extension in Microsoft Dynamics AX 2012 R3, 2012 R2, 2012 and 2009 SP1

Introduction

According to the new legislation changes in Spain (Real Decreto 596/2016, de 2 de diciembre), a new VAT management system based on Immediate Provision of Information (SII system) allows a two-way, automated and instant relationship between the AEAT and a taxpayer.

To meet this new legislation requirements in Microsoft Dynamics AX, there was implemented a new functionality - SII Register. See related articles to know more about SII register functionality:

AX version

KB article number

AX 2012 R3

4025232

AX 2012 R2

4025184

AX 2012

4025184

AX 2009 SP1

4025184

Overview

This document describes SII functionality extension with the following functions:

1. Enhanced Special scheme code setup (Adding more flexibility by providing to setup special scheme code for a Customers/Vendors on Sales tax group + Item sales tax group level. (Previously All/Group/Counterparty only)

2. Adding parameter to identify different types of Sales tax transaction that are subject to Vat rate 0.00%: ImportePorArticulos7_14_Otros, ImporteTAIReglasLocalizacion. (Previously <ImporteTAIReglasLocalizacion> is used for Intra-community reverse charge only and <ImportePorArticulos7_14_Otros> for all other Sales tax transaction that are subject to Vat rate 0.00%.)

3. Updating algorithm of adding Intra-community invoices into SII register by identifying them according to Foreign trade parameters > Country/regionproperties = "EU". (Previously all the invoices which have at least one Sales tax transaction with marked "Intra-community" check box are added into SII register. But currently this check box is used not only for Intra-community operations.)

4. SII register enhancement to allow re-send Rejected invoices with the filled in Tax exempt number which is unknown by Authority in IdOtro tag with code "07". It is expected that this sending approach will let to "Accept with errors" such invoices by SII system.

5. Update export XML generation to fill in NumSerieFacturaEmisor tag with invoice number. Update import XML parsing basing on 4 parameters: Invoice register type, Invoice number, Invoices date and Tax exempt number (NIF).

Detailed description

Enhanced Special scheme code setup

To work with SII register, Special scheme codes should be setup for both Customers and Vendors. To do so, open General Ledger > Setup > Sales tax > Spain > SII Customer special scheme code or General Ledger > Setup > Sales tax > Spain > SII Vendor special scheme code respectively.

Two fields are added on the Special scheme codes table and form to make this setup more flexible:

This image shows how to enhance Special scheme code setup.

Unique index was accordingly extended by adding these two new fields. These two fields are always enabled, and can be filled or left blank independently. The current algorithm of searching Special scheme code for the register consists of 3 stages:

1. Searching among records with Account code = Table for the particular customer/vendor.

2. In case record not found on the first stage, searching is performed among records with Account code = Group of the customer or vendor.

3. In case record not found on the second stage, searching is performed among records with Account code = All.

Searching on each stage valid dates of records are taken into account, and records which are valid on the register date should be selected only.

With adding two new fields, the whole algorithm remained the same (it still contains 3 main stages), but searching on each stage changed. When trying to search for the special scheme code for the register on each of the above-mentioned stages, now sales tax group and item sales tax group are taken into account. In order to get sales tax group and item sales tax group for the invoice, the first tax transaction is selected related to the current customer/vendor/project invoice. After that sales tax group and item sales tax group are passed as parameters to the method of searching special scheme codes.

Actually, searching by Sales tax group and Item sales tax group can also be divided into 4 sub-stages (they are all implemented for each of the above-mentioned 3 stages, until a suitable record will be found):

  1. First, we are trying to find a record which has Sales tax group and Item sales tax group not empty and equal to the values passed as parameters.

  2. If we can't find such record, we are trying to find a record having Sales tax group equal to the Sales tax group passed as a parameter and empty (empty means "any") Item sales tax group.

  3. If we can't find such record, we are trying to find a record having Sales tax group empty and Item sales tax group equal to the Item sales tax group passed as a parameter.

  4. Finally, if we can't find such record, we are trying to find a record having both Sales tax group and Item sales tax group empty.

Here are some examples. Let's say, we have invoice for the Customer = Cust001. The invoice has 1 line with 1 tax transaction having Sales tax group = TG and Item sales tax group = TIG. And we have the following setting of special scheme codes:

1. In this case, special scheme code 04 will be found for the invoice. Actually all 4 records meet the condition, but the 4th is selected because it corresponds to the invoice most fully.

Special scheme code

Account code

Account/group number

Sales tax group

Item sales tax group

01

Table

Cust001

02

Table

Cust001

TG

03

Table

Cust001

TIG

04

Table

Cust001

TG

TIG

2. In this case, special scheme code 02 will be found for the invoice, because it corresponds to the invoice most fully, and Sales tax group equality has priority over Item sales tax group equality.

Special scheme code

Account code

Account/group number

Sales tax group

Item sales tax group

01

Table

Cust001

02

Table

Cust001

TG

03

Table

Cust001

TIG

3. In this case, special scheme code 03 will be found for the invoice, because it corresponds to the invoice most fully.

Special scheme code

Account code

Account/group number

Sales tax group

Item sales tax group

01

Table

Cust001

03

Table

Cust001

TIG

4. In this case, special scheme code 01 will be found for the invoice, because it is the only one which meets the conditions.

Special scheme code

Account code

Account/group number

Sales tax group

Item sales tax group

01

Table

Cust001

03

Table

Cust001

SomeOtherTIG

So, schematically algorithm on each stage looks like this:

This image shows schematically algorithm on each stage.

Sales tax code parameter to identify different types of Vat rate 0.00%

Considering that in Spain there are different case when Sales tax codes with 0.00% rate are used and there was no option to differ the following cases:

- ImporteTAI ReglasLocalizacion – to reflect transactions with other Spanish areas that do not have VAT but some internal indirect tax different than VAT (for example Canary Island, Ceuta and Melilla).

- ImportePor Articulos7_ 14_Otros – to reflect some other specific transactions.

There was shared a Type of tax field on Sales tax code table:

This image shows the Type of tax field.

The Type of tax field may have different values but the followings should be used for Sales tax codes amounts on which should be reflected on corresponding tags:

Tag

Type of tax value

ImportePorArticulos7_14_Otros

VAT 0%

ImporteTAIReglasLocalizacion

Other

NOTE! Please update your setup of Sales tax codes before generating the reports to get "ImportePorArticulos7_14_Otros", "ImporteTAIReglasLocalizacion" tags filled in correctly.

Algorithm of adding Intra-community invoices

Previously the algorithm of Intra-community invoices identifying added all the invoices which have at least one Sales tax transaction with marked "Intra-community" check box into SII register. As in Spain "Intra-community" check box is used not only for Intra-community operations, the SII register was unnecessary filled in with extra invoices that should not be sent to SII system as Intra-community invoice.

To reduce a number of unnecessary intra-community invoices in the SII register, the algorithm was changed. To identify an invoice as intra-community, the following setup should be used: on Organization administration > Setup > Foreign trade > Foreign trade parameters form open Country/region properties tab and set up Country/region type = "EU".

This image shows how to identify an invoice as intra-community.

Thus, only invoices with counteragents whose primary address ISO code set up as Country/region type = "EU" will be added to the SII register as Intra-community invoice.

IdOtro tag with code "07"

Sometimes when a Spanish counteragent’s tax exempt number (NIF) cannot be found in SII system’s data base an invoice cannot be accepted by SII system. At the same time, a Customer's invoice with unregistered in SII system's data base counteragent can be sent to the SII system identifying Tax exempt number of a counteragent in <IdOtro> tag with <IdType> = "07". In this case, such invoice will be Accepted with errors by SII system.

To support possibility of sending Customers invoices in this way, Tax registration tab was added on SII register form:

This image shows how to add the Tax registration tab on the SII register form.

The Tax registration tab includes the following fields:

Field name

Field description

Registration number

Tax exempt number of the counteragent identified from the Counteragent's register information. If it is an EU counteragent, an ISO code added as prefix.

Can be manually updated if needed.

Tax ID type

This field can be filled in with a value from Registration IDs table or is empty is the Registration number is NIF.

Can be manually updated if needed.

Party ISO code

This field should be filled in by default with ISO code from the counteragent's primary address.

Can be manually updated if needed.

Values from the Tax registration tab will be used on XML report generating.

NumSerieFacturaEmisor tag - invoice number

Initially, SII register Export function generated XML report filling in the NUmSerieFacturaEmisor tag according to the official documentation:

This image shows the NUmSerieFacturaEmisor tag.

Using as "No Serie" a combination of TableID and RecordID. Such invoice identification let invoices to be accepted by SII system but they cannot be further processed in SII system. Because for this purpose, an invoice should not have any prefix but should be registered with the invoice number only.

To let invoice be processed in the SII system, the export XML generation algorithm was updated to fill in NUmSerieFacturaEmisor tag with invoice number.

The scheme of a response from the Authority includes the following information about each of the previously included invoices:

This image shows the scheme of a response from the Authority.

Taking into account that <NIF> tag in the response includes the ISO code in case of all non-Spanish countries the information form the Authority response can uniquely identify an invoice in AX for all EU and Spanish companies.

Import XML parsing was updated basing on four parameters: Invoice register type, Invoice number, Invoices date, Tax exempt number (NIF).

Hotfix information

How to obtain the Microsoft Dynamics AX updates files

This update is available for manual download and installation from the Microsoft Download Center.

Prerequisites

You must have one of the following products installed to apply this hotfix:

  • Microsoft Dynamics AX 2012 R3

  • Microsoft Dynamics AX 2012 R2

  • Microsoft Dynamics AX 2012

  • Microsoft Dynamics AX 2009 SP1

Restart requirement

You must restart the Application Object Server (AOS) service after you apply the hotfix.

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/northamerica/help/help/contactus

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.

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×