Poland: VAT declaration with registers JPK-V7M (VDEK) in Excel format in Dynamics 365 Finance

On July 4, 2019 the Act on Tax on Goods and Services, binding from September 1, 2019 introduces the obligation to report in an electronic document that consist of Jednolity Plik Kontrolny VAT (JPK_VAT) with the declaration (Jednolity Plik Kontrolny  VDEK – “JPK_VDEK”).

Microsoft Dynamics 365 Finance supports JPK_VDEK format. Please find details on the initial feature release in KB 4540232, supplemented pack I for JPK_VDEK in KB 4552887 and supplemented pack II for JPK_VDEK in KB 4550662.

This article is dedicated to implementation of additional format for preview JPK-V7M report in Excel format. It is planned that this format will replace VAT registers in SSRS format: Polish SSRS reports: Sales VAT register, Purchase VAT register, EU summary VAT register – Feature reference PL-00014.

The changes described in this article are supported in following or later versions of Finance:

Import and use the following versions of Electronic reporting configurations, which deliver changes described in this article:

Import the latest versions of these configurations. The version description usually includes the number of the Microsoft Knowledge Base (KB) article that explains the changes that were introduced in the configuration version.

Note: After all the ER configurations from the preceding table are imported, set the Default for model mapping option to Yes for “Standard Audit File model mapping” configuration.

For more information about how to download ER configurations from Microsoft Dynamics Lifecycle Services (LCS), see Download Electronic reporting configurations from Lifecycle Services.

Import and use the latest version of Electronic messaging setup package from Shared asset library of LCS portal: PL JPK_V7M EM setup v.4 KB4575386 (from 10.0.14 only).zip.
This version introduces the following changes in the setup:

• New “Podgląd w programie Excel” action of “Message execution level” type linked to “JPK-V7M Excel format (PL)” ER format.

Import of electronic messages setup

If you previously imported and used setup of Electronic messages delivered as package of data entities of previous version (1, 2 or 3), you can import the new version (4) without deleting previous setup. Execution of this re-importing will be partially succeeded because of the attempt to overwrite already existing information.

As a result of re-importing new “Podgląd w programie Excel” action will be added to the “JPK-V7M” processing.

Do not use “Truncate entity data” option on importing new version of data entities if you previously used JPK-V7M feature, this may result loosing access from application user interface to the previously created electronic messages.

Import application specific parameters

Structure of application-specific parameters of “JPK-V7M Excel format (PL)” format is completely the same as of “JPK-V7M XML format (PL)” format.

Export as XML file previously prepared setup of application specific parameters for “JPK-V7M XML format (PL)” format by using “Export” button on “Application specific parameters” page and then import it for the latest version of “JPK-V7M Excel format (PL)” format by using “Import” button. Change the state of application-specific parameters setup to “Completed”, click "Save" button and close the page.

This hotfix introduces to “JPK-V7M” processing new “Podgląd w programie Excel” action.

“Podgląd w programie Excel” action can be run when a new electronic message is created, before or after XML report is generated, until electronic message is not marked as “Reported” (“Zmień status” to “Zgłoszone JPK-V7M”).