Export a range of invoices in the required xml format starting from 01 Jan 2016 in the Hungarian version of Microsoft Dynamics AX R3, Microsoft Dynamics AX R2, and Microsoft Dynamics AX 2009 SP1

This article applies to Microsoft Dynamics AX for the Hungarian (hu) region.

According to the Hungarian legislation, starting from 01 January 2016 taxable entities are required to provide a range of invoices in the xml format.

This hotfix introduces the functionality that provides an ability to export a range of invoices for a period or an invoice number interval in the required xml format in the Hungarian version of Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, and Microsoft Dynamics AX 2009 SP1.

Note Prior to file generation, you need to set up services and AIF as it described in the Setup section below. Please refer to the sections for Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, and Microsoft Dynamics AX 2009 SP1 respectively.


Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
Exporting invoices

1. Open General ledger > Reports > External > Services and Application Integration Framework > Invoice list 2016 (Hungary)

    a. Select the invoice date and/or invoice ID ranges (fields Invoice date / "From", "To", Invoice ID / "From", "To")

        i. Selected dates / invoice IDs affect the query ranges, not vice versa. To use advanced filtering please use "Select" button.

    b. Select the "Format" value (by default the format created on Setup, step 2.a is used)

    c. Select the "Filename" value (by default the "Default export path" from Setup, step 2.c is used)

2. Click OK

3. The report in XML format is exported to the specified path



Setup

1. Open AOT, export XSLT file from the resource AifOutboundPortReportInvoiceList2016_HU into a folder (say, C:\TMP\XSL)

2. System administration > Setup > Services and Application Integration Framework > Outbound ports for electronic audit reports

    a. Click "Create / Update ports". The default port "Invoice list 2016 (Hungary)" will be created.

    b. Set "Import XSLT" equal to the path from step 1 (C:\TMP\XSL)

    c. [optional] Set "Default export path" to the path you expect the reports to be saved to. (say, C:\TMP\OUT)

    d. Click "Create / Update ports"

        i. The XSL is imported into Dynamics AX with the default ID "Invoicelist2016(Hungary)".

        ii. The "XSLT ID" field is set to reference the "Invoicelist2016 (Hungary)" transformation.

    e. The outbound AIF port "Invoicelist2016(Hungary)" is created and initialized with a list of needed services



Notes        

i. For better performance please make sure the parameter "Execute business operations in IL" is enabled (Tools > Options > Development > General). Please note that global compilation and rebuilding IL is a mandatory step after the hotfix installation.

ii. The folder where the XSL was exported to (step 1) is used only for editing the XSL (if needed) and uploading it back to Dynamics AX. The transformation does not use the file in the folder after the step 2.d.

iii. For debugging purposes, you may want to get the non-transformed XML. To achieve that clear the field "XSLT ID".



Microsoft Dynamics AX 2009 SP1
Exporting invoices

1. Open General ledger > Reports > External > Invoice list 2016 (Hungary)

    a. Select the invoice date and/or invoice ID ranges (fields Invoice date / "From", "To", Invoice ID / "From", "To")

        i. Selected dates / invoice IDs affect the query ranges, not vice versa. To use advanced filtering please use "Select" button.

    b. Select the "Format" value (by default the format created on Setup, step 2.a is used)

    c. Select the "Filename" value (by default the "Default export path" from Setup, step 2.c is used)

2. Click OK

3. The report in XML format is exported to the specified path



Setup

1. Open AOT, export XSLT file from the resource AifOutboundPortReportInvoiceList2016_HU into a folder (say, C:\TMP\XSL)

2. System administration > Setup > Services and Application Integration Framework > Outbound ports for electronic audit reports

    a. Click "Create / Update ports". The default port "Invoice list 2016 (Hungary)" will be created.

    b. Set "Import XSLT" equal to the path from step 1 (C:\TMP\XSL)

    c. [optional] Set "Default export path" to the path you expect the reports to be saved to. (say, C:\TMP\OUT)

    d. Click "Create / Update ports"

        i. The XSL is imported into Dynamics AX with the default ID "Invoicelist2016(Hungary)".

        ii. The "XSLT ID" field is set to reference the "Invoicelist2016 (Hungary)" transformation.

    e. The outbound AIF port "Invoicelist2016(Hungary)" is created and initialized with a list of needed services



Notes        

i. The folder where the XSL was exported to is used only for editing the XSL (if needed) and uploading it back to Dynamics AX. The transformation does not use the file in the folder after the step 2.d.

ii. Selected dates affect the ranges on the query. For more detailed selection ranges please use "Select" button.

iii. For debugging purposes, you may want to get the non-transformed XML. To achieve that clear the field "XSLT ID".