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

Introduction

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.

Overview

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.

Setup

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.

Resolution

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”).

More information

You can 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.