Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Austria/AUT, Czech Republic/CZE: A fiscal service integration example in Microsoft Dynamics 365 for Operations


View products that this article applies to.

Symptoms

In Austria, all cash payments should be signed by an external device or service and securely stored.
In Czech Republic, all cash payments should be sent to the government portal for a fiscal signature.
In both countries, a cash receipt should be issued where the signature is printed.
The technical solution requires a device or service that can make a signature (in the Austrian case) or communicate electronically via the Internet (in the Czech Republic case). It is only the entrepreneur's decision what type of cashier equipment and software to choose for usage as long as the obligation to the signature or sending a data message and issue, the receipt is fulfilled.

↑ Back to the top


Resolution

The changes in this hotfix include:

An example integration to a fiscal service (EFR) with possibility to send the selected cash transactions to the fiscal service EFR, receive a fiscal response from the service EFR and print an example confirmation document (cash receipt) with fiscal codes from the fiscal response.

When any other Fiscal service or external cash register is chosen, integration to the chosen Fiscal service should be considered as customization: Request and Response GER configurations need to be created and set up for cash register, as well as X++ code may need to be updated with Fiscal-service specifics.

↑ Back to the top


Overview

This functionality is developed as an example of integration Microsoft Dynamics 365 for Operations application to a fiscal service compliant with specific requirements to the cash payments control in different countries. A fiscal service EFR provided by EFSTA (EUROPEAN FISCAL STANDARDS ASSOCIATION) is used in this integration example (here and below called Fiscal service).

A scope of integration example is the following:

  • After the completion of posting of the cash payment liable for registration, a cash register transaction with data to be signed is created and sent for the registration to Fiscal service in the specified XML format.

  • Response with a signature and fiscal codes (generated by Fiscal service per country-specific rules) is received from Fiscal service and stored in the Cash register fiscal transaction.

  • The cash receipt with transaction data and signatures/fiscal codes is printed.

It's assumed that all other specific country legal requirements concerning the registered transactions are fulfilled on the side of Fiscal service.

This is user's responsibility to properly setup and administer the third-party Fiscal service.

The format of Cash receipt, XML request to Fiscal service and XML response from Fiscal service are configured as Electronic reporting configurations.

The following configurations are available as part of this release:

Configuration Name

Configuration Description

Comment

GER configuration files in LCS Shared Asset Library

Cash Receipt Model

Data model for cash receipt format

Cash Receipt Model.version.1.xml

Cash Receipt Format

Basic format for cash receipt

Cash Receipt Format.version.1.1.xml

Cash Receipt Format (AT)

Format for cash receipt in Austria (incl. QR code)

Cash Receipt Format (AT).version.1.1.1.xml

Cash Receipt Format (CZ)

Format for cash receipt in Czech Republic (incl. BP Id)

Cash Receipt Format (CZ).version.1.1.1.xml

Cash Register Model

Data model for cash register integration

Cash Register Model.version.1.xml

ESR Request example

EFSTA Simple Receipt Request example

Basic format for Sample XML request to Fiscal service EFSTA (could be used in Austria)

ESR Request example.version.1.1.xml

ESR Request example (CZ)

EFSTA Simple Receipt Request example (CZ)

Format for Sample XML request to Fiscal service EFSTA in Czech Republic

ESR Request example (CZ).version.1.1.1.xml

ESR Response example

EFSTA Simple Receipt Response example

Basic format for Sample XML response to Fiscal service EFSTA (could be used in Austria)

ESR Response example.version.1.1.xml

ESR Response example (CZ)

EFSTA Simple Receipt Response example (CZ)

Format for Sample XML response to Fiscal service EFSTA in Czech Republic

ESR Response example (CZ).version.1.1.1.xml

↑ Back to the top


Setup

Create Cash registers

Create cash registers at Accounts receivable > Setup > Cash registers > Cash registers

This image shows how to create a cash register.

Fields description in the form Cash registers:

Field

Description

Cash register Id

Enter unique code of cash register in legal entity.

Cash register Code

Enter code of cash register in Fiscal service.

Description

Enter description of cash register.

Receipt number

Choose number series for cash receipt.

Cash register URL

URL to the location where Fiscal service is running.

WARNING: Third party services or other services that you configure here do not require a certification and they might not meet Microsoft privacy standards. You should review each service's privacy documentation and work with each service provider to learn more about each service's provided level of compliance. You are responsible for ensuring that these services meet your security, privacy and legal standards. You bear the risk of using it. Microsoft gives no express warranties, guarantees or conditions. It is strongly recommended that you use only services that provide secure and authorized connections (https://).

Key Vault name Choose the name of the Key Vault where the certificate is stored (see below for more details about Key Vault).

FAST TAB Configurations

Receipt format

Choose ER format for printing of a cash receipt.

For example, choose

  • "Cash receipt format (AT)" – for Austria
  • "Cash receipt format (CZ)" – for Czech Republic

Prior to this, you should Download Electronic reporting configurations from Lifecycle Services

Configurations are available under:

Cash Receipt Model

  • Cash Receipt Format
    • Cash Receipt Format (AT)
    • Cash Receipt Format (CZ)

Request format

Choose ER format for sending a request to fiscal service with payment details.

For example, choose

  • "ESR Request example" – for Austria
  • "ESR Request example (CZ)" – for Czech Republic

Prior to this, you should Download Electronic reporting configurations from Lifecycle Services

Configurations are available under:

Cash Register Model

  • ESR Request example
    • ESR Request example (CZ)

Response format

Choose ER format for receiving a response from fiscal service with fiscal acknowledgement.

For example, choose "ESR Response example".

Prior to this, you should Download Electronic reporting configurations from Lifecycle Services

Configurations are available under:

Cash Register Model

  • ESR Response example
    • ESR Response example (CZ)

FAST TAB Cash Register certificate settings

If Fiscal service is accessible at https:// secure connection, you should set up certificates and store them properly on both sides – Dynamics 365 for Operations and the third party Fiscal service.

The followings are guidelines for certificates on Dynamics 365 for Operations side. The certificates managed by Microsoft Dynamics 365 for Operations may be stored in Key Vault. You should Set up a Key Vault Client as a prerequisite to the below settings.

This is user's responsibility to properly setup and administer certificates on the third-party Fiscal service side.

Use self-signed certificate

Activate the parameter in case you are going to use a self-generated and self-signed certificate which you are not able to add in the list of trusted certificates.

Cash register certificate thumbprint

Enter thumbprint of the self-signed certificate stored in Fiscal service which will be used for validation of Fiscal service certificate validness.

Create Cash register locations

Create locations of cash registers at Accounts receivable > Setup > Cash registers > Cash register locations

This image shows how to create a cash register location.

Fields description in the form Cash register locations:

Field

Description

Location code

Enter a code of cash register location.

Description

Enter a description of location.

Operating unit

Choose an operating unit associated with location.

Buttons description in the form Cash register locations:

Button

Description

Cash register operators

Open a list of operators assigned to current location.

Cash register terminals

Open a list of cash register terminals in current location.

CZ/Czech Republic: Set up Business Premise Id for Cash register location

Create Tax registration type for Business Premises Id in Organization administration > Global address book > Registration types > Registration types.

Registration types

Associate created tax registration type with legislative type "Business Premise Id" in Organization administration > Global address book > Registration types > Registration categories.

This image shows how to associate the created tax registration type with legislative type of

Open Operating unit associated with Cash register location. (Go to Cash register locations, place cursor on a field Organization number, right click > View details or go directly to Organization administration > Common > Organizations > Internal organizations.)

Click More options > Advanced on address line in Addresses tab.

Click Add on Registration Id fast tab and add info about Business premise Id number.

This image shows how to add information about the business premise Id number.

 

Create Cash register terminals

Create cash register terminals at Accounts receivable > Setup > Cash registers > Cash register terminals.

This image shows how to create a cash register terminal.

Fields description in the form Cash register terminals:

Field

Description

Terminal code

Enter a code of cash register terminal.

Description

Enter a description of terminal.

Cash register location

Choose a location of the terminal.

Cash register

Choose a cash register where cash transactions logged in current terminal will be registered.

 

Assign the user to the person

Assign a User who is acting as cash operator and is allowed to log a cash transaction which will be registered in cash register, to a Person in System administration > Users.

 

Set up Cash register operators

Set up cash register operators and assign them to the cash register location in Accounts receivable > Setup > Cash register > Cash register operators.

This image shows how to set up a cash register operator.

Fields description in the form Cash register operators:

Field

Description

Operator code

Enter a code of cash register operator.

Worker

Choose a worker who has current Operator code.

Location

Choose a location for current Operator. Operator is allowed to log cash transactions to all terminals in the assigned location.

Default terminal

Optionally choose a default terminal. The chosen terminal will be pre-defaulted to documents for which the fiscal registration is required.

 

Set up methods of payment that require fiscal registration

Set up methods of payment, which needs to be registered in cash register at Accounts receivable > Setup > Cash registers > Cash register methods of payment.

This image shows how to set up methods of payment that require fiscal registration.

Fields description in the form Cash register methods of payment:

Field

Description

Method of payment

Choose a method of payment which needs to be registered in cash register and sent to Fiscal service.

Register tax amount

Activate the check box if the tax amounts related to the cash payment amount need to be registered in Fiscal service.

Important notices

In the following scenarios, the tax amounts related to the payment amount can be identified reliably from the posted transactions:

  1. For the cash payment posted automatically during posting of a COD invoice (cash on delivery terms of payment), tax amounts sent are equal to the tax amounts produced by an invoice posting.

  2. For the cash prepayment posted manually from the customer payment journal, when sales tax amounts are calculated and posted from the payment journal (tax amounts posted from the prepayment are always sent irrespectively from the parameter Register tax amount).

User should consult with local tax authority to identify the requirements to registering the tax amounts related to the cash payment in the cash register. User should split methods of payment if necessary.

In the following scenarios, the tax amounts related to payment amount can't be identified reliably from the posted transactions:

  1. For the cash payment posted manually from the customer payment journal and settled to the previously posted invoice which contains a posted tax amount.

If you set up to send these tax amounts to cash register, they can't be considered as fully correct tax amounts but rather rough tax amounts are calculated from the payment amount by a specific amount distribution logic. In these scenarios, the correct tax amounts are presented only in the settled posted invoice. Consult with local tax authority to identify the right way for submitting the invoiced tax amounts to tax authority checks for these scenarios.

Create Terms of payment for Cash on delivery scenarios

Create Terms of payment with Cash on delivery payment method if a cash payment can be received in the moment of an invoice posting, at Account receivables > Payment > Terms of payment.

Fields description in the form Terms of payment:

Field

Description

Payment method

Choose "COD".

Cash payment

Enable the parameter to create an automatic payment transaction.

Cash

Choose G/L account for posting of an automatically generated cash payment.

↑ Back to the top


Operations

Register automatically posted COD payment for the Free text invoice and print cash receipt

Go to Accounts receivable > Free text invoices > All free text invoices.

Create free text invoice in standard way.

On fast tab Payment, choose Method of payment which is set up as cash register method of payment. Choose Terms of payment with cash on delivery settings. Click Post.

In the dialog Post free text invoice:

This image shows how to post a free text invoice.

Activate the check-box Print receipt in the fast tab Parameters for printing the cash receipt after the invoice is posted.

On fast tab Cash register review Location, Terminal, Cash register and Operator code. Terminal code is pre-defaulted from the "Default cash register terminal" field in Cash register operators form. Change Terminal code if the cash payment is received in a different cash register terminal available for the current operator.

Click OK.

Review the generated cash receipt for the posted invoice. By default, the generated cash receipt is available as a file. You can set up additional and other destinations for cash receipt output: see Electronic Reporting Destinations for more details.

Register automatically posted COD payment for the Sales order invoice and print cash receipt

Go to Accounts receivable > Orders > All sales order.

Create sales order in standard way.

On fast tab Price and discount, choose Method of payment which is set up as a cash register method of payment. Choose Terms of payment with cash on delivery settings in the Payment field.

Click Invoice > Invoice.

In the dialog Posting invoice, in the fast tab Parameters, activate the check-box Print receipt for printing a cash receipt after the invoice is posted.

On the fast tab Cash register, review Location, Terminal, Cash register and Operator code. Terminal code is pre-defaulted from the "Default cash register terminal" field in the Cash register operators form. Change Terminal code if the cash payment is received in a different cash register terminal.

Register customer payment from Customer payment journal and print cash receipt

Go to Customer payment journal at Accounts receivables > Journals > Payments > Payment journal (or General journal at General ledger > Journals > General journal).

Create the journal lines with a customer cash payment in the standard way.

On tab Payment, choose Method of payment which is set up as a cash register method of payment. Activate the check box "Prepayment journal voucher" if this is a prepayment.

On tab Payment, review Location, Terminal, Cash register and Operator code. Terminal code is pre-defaulted from the "Default cash register terminal" field in the Cash register operators form. Change Terminal code if the cash payment is received in a different cash register terminal. Click Post > Post. Click Print > Cash receipt to print a receipt with fiscal codes.

CZ/Czech Republic: Register customer payment from Slip journal and print cash order with cash receipt information

Go to Cash and bank management > Journals > Slip journal.

Create the journal lines with a customer cash payment in the standard way. Review Cash register group of fields on tab Payment. Terminal code is pre-defaulted from the "Default cash register terminal" field in the Cash register operators form. Change Terminal code if the cash payment is received in a different cash register terminal.

Click Documents approval > Approve. Cash order number is assigned to payment.

Click Post > Post.  Click Print > Cash order to print a cash order with fiscal codes.

Cancel payment

If a payment which is being cancelled, has been registered in the cash register with a cash receipt number, the cancel payment will create a new cash receipt number with a negative amount which will also be registered in the same cash register. The payment cancellation cash receipt is presenting fully the same amounts as in an initial receipt but a negative sign.

Go to Customer transactions form. Place cursor on a payment transaction and click Reverse > Cancel payment.

In the dialog Cancel payment, fill necessary information and review values in group of fields Cash register. Click OK.

This image shows how to cancel a payment.

Place cursor on the new payment cancellation transaction. Click button Print > Cash receipt to print a cash receipt with fiscal codes.

Review Cash register fiscal transactions. Resend transaction to cash register.

You can review the registered cash payments, and also reprint Cash receipt original and copy at Accounts receivable > Inquires > Cash register fiscal transactions.

This image shows how to review cash register fiscal transactions and resend transaction to cash register.

If cash payment wasn't successfully registered for any infrastructural reason (not related with exception scenarios described in the law which should be correctly handled on Fiscal service side), a user will get respective an error message after a posting of cash payment. The cash register transaction in status "Created" will be available in the Cash register fiscal transactions form. User must fix infrastructural issues and manually resend the created cash transactions to the cash register. Otherwise, user is not able to print the cash receipt with fiscal codes. Correctly, the registered transaction gets status "Registered".

Fields description in the form Cash register payment transactions:

Field

Description

Tab Overview

Cash register

Id of cash register

Transaction Id

Id of transaction in cash register

This value is received from Fiscal service.

Cash register URL

URL of the place where Fiscal service is located.

Status

Status of transaction. Possible values:

Created. The payment transaction is posted, but not registered.

Registered. The payment transaction is posted and registered (sent to Fiscal service and received response with fiscal codes).

CZ/Czech republic: Offline

Indication that the cash transaction is registered in Offline regime (allowed exception) and PKP code is received.

Terminal

Code of cash register terminal

Operator

Code of cash register operator

Tab General

Voucher

Voucher number of posted cash transaction

Date

Date of transaction

Receipt number

Number of cash receipt

Transaction date and time

Date and time of registered transaction

This value is received from Fiscal service.

Receipt amount

Payment amount

Currency

Currency of payment

Tab Fiscal codes

Name

Name of fiscal code received from the fiscal service. Possible values:

   Info – additional information

   AT/Austria: Code - signature

   AT/Austria: Link – signature dependent link

Label

Label of the fiscal code received from the fiscal service

Possible values:

   CZ/Czech Republic: FIK – Fiscal Identification Code

   CZ/Czech Republic: BKP – Security Code

   CZ/Czech Republic: PKP – Signature Code (returned in case of offline registration)

Value

Value of fiscal code received from fiscal service

Tab Registered tax amounts

Value

% of registered tax

Sales tax amount

Amount of registered tax

Gross amount

Amount of registered payment

Buttons description in the form Cash register payment transactions:

Button

Description

Send

Send current transaction to fiscal service.

Send all

Send all not registered transactions to fiscal service for the chosen cash register code.

Log

Open the history log with requests and responses from Fiscal service.

Print

Print the cash receipt or copy of the cash receipt.

↑ Back to the top


Hotfix information

How to obtain the Microsoft Dynamics AX updates files

This update is available for manual download and installation from the Microsoft Download Center.

Note You can search for KB4041219 in the above link and download the related hotfix.

Prerequisites

You must have one of the following products installed to apply this hotfix:

  • Microsoft Dynamics 365 for Operations

The following hotfixes are required for this functionality:

Restart requirement

You must restart the Application Object Server (AOS) service after you apply the hotfix.

If you are encountering an issue downloading, installing this hotfix, or have other technical support questions, contact your partner or, if enrolled in a support plan directly with Microsoft, you can contact technical support for Microsoft Dynamics and create a new support request. To do this, visit the following Microsoft website:

https://mbs.microsoft.com/support/newstart.aspx

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

↑ Back to the top


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.

↑ Back to the top


Keywords: kbmbsmigrate, kbqfe, kbnoloc, kbsurveynew, kbmbspartner, kbmbspuickpub, kbexpertiseadvance, kbexpertisebeginner, kbexpertiseinter

↑ Back to the top

Article Info
Article ID : 4041219
Revision : 41
Created on : 10/10/2017
Published on : 10/10/2017
Exists online : False
Views : 686