A country-specific update for Spain: SII addition for issued and received invoices, Intra-community transactions, payments information in Microsoft Dynamics AX 2009 SP1

#3842837: Vendor simplified invoices with code F2 are rejected

For Vendor invoices an additional check is added: if NIF is blank then report will include an empty tag. This will cause an analyzable error from the SII system and let user correct the data and re-send the invoice with correct data.

#3842798: Customer simplified invoices with code F2 are rejected

For Customer invoices an additional check is added: if an invoice is “F2” or “F5” type then the following block of fields will not be included into the report:

<sii:ImporteTransmisionSujetoAIVA>10000.00</sii:ImporteTransmisionSujetoAIVA>

<sii:EmitidaPorTerceros>N</sii:EmitidaPorTerceros>

<sii:VariosDestinatarios>N</sii:VariosDestinatarios>

#3843681: Customer simplified invoices have contraparte section and it is not required

For Customer invoice the following algorithm was implemented in regard the <Contraparte> block of fields:

TipoFactura != 'F2' && TipoFactura != 'R5'

block Contraparte OUTPUT, regardless TaxAmount ( =0 or !=0 ) or RegNumber (empty or not empty )

( TipoFactura = 'F2' || TipoFactura = 'R5' ) and TaxAmount != 0

block Contraparte OUTPUT, regardless RegNumber (empty or not empty )

( TipoFactura = 'F2' || TipoFactura = 'R5' ) and TaxAmount = 0 and RegNumber (NIF or ID) != ‘’ (empty)

block Contraparte OUTPUT

( TipoFactura = 'F2' || TipoFactura = 'R5' ) and TaxAmount = 0 and RegNumber (NIF or ID) = ‘’ (empty)

block Contraparte NOT OUTPUT

#3841779: SII When posting several invoices from just one order, the base and VAT reported are wrong

An algorithm of tax base and tax amount calculation in case of several invoices from one order additionally adopted for AX 2009 SP1.

#3843675: SII When 2 tax codes are applied on the same invoice line, Node ImporteTransmisionSujetoaIVA amount is wrong in SII XML file

Calculation for value for <ImporteTransmisionSujetoaIVA> tag was corrected in case of two tax codes applied on the same invoice line.

#3842521: SII Vendor Invoices with Tax Value = 0, are not including details in Node DesgloseFactura in SII register XML file

Vendor Invoices with Tax Value = 0 are included into the report not depending on Negative sales tax percentage parameter.

#3841915: SII Spain Export transactions should be reported as SUJETA-EXENTA (to third countries and EU countries)

An algorithm of identification of a transaction type is updated as follows:

Sujeto - Exempt:

ExemptTax = Yes

Sujeto - NO Exempt:

TaxValue <> 0

and ExemptTax = No

NO Sujeto:

TaxValue = 0 and Exempt = NO

or ( No postings in TaxTrans )

#3841335: SII send invoice in batch mode retrieves an error

Implementation of a batch mode function was corrected.

#3842520: SII Register is including all the vendor payments, not only Special Regimen for Cash accounting transactions

SII Register Add records function is corrected to include vendor payments with Special Regimen for Cash accounting transactions only.

#3843680: SII Financial reasons do not appear in sales orders

A correction implemented to show the Financial reason field in Sales order.

#3843454: SII For vendor invoices: PeriodoImpositivo node should be calculated considering transaction/posting date to the authorities and not considering the document date,

#3844172: SII FechaRegContable is still not right,

#3842456: SII FechaExpedicionFacturaEmisor , FechaOperacion y FechaRegContable are retrieved from the transaction date

An algorithm of identification values of different dates in the report is updated as follows:

Customer invoices:

<PeriodoImpositivo>

<Ejercicio> InvoiceDate (year)

<Periodo> InvoiceDate (month)

</PeriodoImpositivo>

<FechaExpedicionFacturaEmisor> DocumentDate or InvoiceDate (if DocumentDate is empty)

<FechaOperacion> InvoiceDate.

Vendor invoices:

<PeriodoImpositivo>

<Ejercicio> InvoiceDate (year)

<Periodo> InvoiceDate (month)

</PeriodoImpositivo>

<FechaExpedicionFacturaEmisor> DocumentDate or InvoiceDate (if DocumentDate is empty)

<FechaOperacion> DeliveryDate or InvoiceDate (if DeliveryDate is empty)

<FechaRegContable> createdDate

#3842107: SII Error Intracommunity Op. SII_Dynamics IDType= 04 in the transactions, the value should be 02,

#3843411: SII Error Intracommunity Op. SII_Dynamics IDType= 04 in the transactions, the value should be 02. STILL WRONG,

#3843886: SII Error Intracommunity Op. SII_Dynamics IDType= 04 in the contraparte, the value should be 02 also. STILL WRONG

An Customer/Vendor TAX ID identification algorithm is updated as follows:

If “Tax exempt number” value from the invoice header (from invoice journal) is not empty -> IDNumber

If Customer/Vendor Country region type = “Domestic”:

Tag NIF = IDNumber

If Customer/Vendor Country region type = “EU” or “Third country/region”:

Tag NIF = blank

If Customer/Vendor has Registration ID of any type from [ TAXID, Passport, OfficialIdDoc , ResidenceCertificate, OtherIdDoc ] (these match to SII's IDTypes [ "02", "03", "04", "05", "06" ])

Tag IDOtro = { IDType= *corresponding SII's IDType*; ID = IDNumber }

Else

Tag IDOtro = { IDType= 02; ID = IDNumber }

Otherwise -> Registration IDs algorithm (taking into account date effective of RegIDs)

But if ISO code = ES and NIF is blank then IDType= 07

#3844152: SII Equivalence charge code is not reported in XML

#3840466 (KB #4033894): SII Equivalence charge code is included in XML file as a “normal” sales tax code and it reports an error when invoice XML file is sent to Authorities

Reflection of “Equivalence charge” tax transactions is corrected to filled in <CuotaRecargoEquivalencia> and <TipoRecargoEquivalencia> tags with the corresponding values.

#3841312: SII Customer invoices that are not subject of VAT, are wrong declared if the base amount is zero

Invoices with tax base amount = 0.00 and tax amount = 0.00 are included into the report in <NoSujeta> block of fields.

#3842468: SII CuotaDeducible is wrong when Vendor invoice contains withholding tax

Corrected calculation algorithm of values for <CuotaDeducible> tag by excluding tax amount with Negative sales tax percentage Sales tax code.

#3843466: For Prorrata and companies with certain activities such as training, healthy,.. The exempt amount must increase the cost because the VAT is not deductible

Updated algorithm of calculation values for:

CuotaSoportada – non-deductible tax amount is not taken into account.

CuotaDeducible – take into account non-deductible tax amount.

#3843868: After installing xpo, the node DesgloseTipoOperacion is empty and we get an error if the transaction is posted in Free text invoice.

An algorithm of filling in <DesgloseTipoOperacion> tag for invoices posted in Free text invoice additionally adopted for AX 2009 SP1.

#3842503: SII BOM item are reported as Services in Customer invoices in SII XML file

An algorithm of identification of <TipoDesglose> is additionally adopted for AX 2009 SP1.

#3844859: Invoice register add unnecessary VAT detail

The algorithm of invoice reporting is corrected to not include unnecessary VAT details.