Changes in XSD schema of Lithuanian SAF-T-file for 2018 in Microsoft Dynamics AX

Introduction

The changes in XSD schema of SAF-T file for 2018 reporting (XSD 2.0) are provided. Data for 2018 year and further can be provided only via XSD 2.0 version.

Legislation changes

On the 28^th of December 2017, Lithuanian tax authority has released new decree VA-127/2017-12-28. This decree represents the new version 2.0 of SAF-T file XSD schema.The old XSD schema 1.1. is valid for the 2017 data submission and the new XSD schema 2.0 is valid for the year 2017 and later periods.

There are no changes in business processes. Changes affect XSD shema and the way SAF-T file can be formed.

Lithuanian tax authority provided guidelines what information each part should include as well as additional information, how parts should be generated and numbered. All these changes will be described in details in chapters 4 and 5.

The relevant information can be found: https://www.vmi.lt/cms/saf-t

See the KB for the version 1. here https://support.microsoft.com/authoring/article/3207942?locale=en

Example of address types setup

In some cases, the reporting data should be transformed in a uniform way throughout the whole report (or multiple reports), especially to support data that does not exist in Microsoft Dynamics AX.

The Report should display Address Type codes according to the XSD file approved by Lithuanian tax authority instead of AX types. At least because Address type in AX contains much more values than XSD allows.

It is implemented in a separate XSLT AifOutboundPortReportSAFT_LT.xslt. Please find the example below:

1. Edit the XSLT file AifOutboundPortReportSAFT_LT.xslt (any text editor – from Notepad to Visual Studio)

   1. See the "Add replacement pattern(s)" area; it contains replacement patterns (one or multiple) (in the example - one pattern called AddressTypeSAFT); pattern is a list of replacement pairs "from - to"; hope the semantics is quite self-explanatory.

      <ReplacementPattern name="AddressTypeSAFT">

      <Replace>

      <From></From>

      <To>KT</To>

      </Replace>

      <Replace>

      <From>Business</From>

      <To>BA</To>

      </Replace>

      <Replace>

      <From>Korespondencijos adresas</From>

      <To>KA</To>

      </Replace>

      <Replace>

      <From>Sąskaitos išrašymo adresas</From>

      <To>SIA</To>

      </Replace>

      <Replace>

      <From>Registracijos adresas</From>

      <To>RA</To>

      </Replace>

      <Replace>

      <From>Prekės išsiuntimo adresas</From>

      <To>PIA</To>

      </Replace>

      <Replace>

      <From>Prekės pristatymo adresas</From>

      <To>PPA</To>

      </Replace>

      </ReplacementPattern>

   2. Edit (add/remove) replacement rules (and patterns, if more than one is needed).

   3. Edit (add/remove) replacement rules (and patterns, if more than one is needed).See the "Add XPath(s) to transform here" area; here XPath(s) that should be updated should be listed with what replacement pattern should be applied to each.

      <xsl:template match="//SAFT:AddressType">

      <xsl:call-template name="Replace">

      <xsl:with-param name="ReplacementPattern" select="'AddressTypeSAFT'"/>

      <xsl:with-param name="IfFromNotFoundUseOriginal" select="false()"/> </xsl:call-template>
      </xsl:template>

   4. By default, if the replacement pattern does not contain the applicable rule, the tag will be fulfilled with the value "KT". In the example above, Address type "Business”"will be replaced by "BA". To replace all non-set up types with blank values, use the parameter IfFromNotFoundUseOriginal set to "false()" (<xsl:with-param name = "IfFromNotFoundUseOriginal" select="false()"/>).

    2. Save the XSLT. 

    3. Note If multiple replacements are needed, multiple patterns can be created in one XSLT.

Business scenario

Scenario steps:

1. User runs "SAF-T data export" function.

2. On the request form user:

   1. Selects from – to date (year/month/day);

   2. Selects one of the types of the SAF-T file (F/ GL/ PS/ SI/ PI/ PA/ AS);

   3. Fills number of parts (by default 1 should be filled);

   4. Fills part number (by default 1 should be filled);

   5. Selects entity, for which the SAF-t file will be generated;

   6. Selects the route where the created XML file will be saved.

3. XML is created.

4. A created XML file is reported to the tax authority by uploading the file to SAF-T application.

Hotfix information