A country specific update to support Swiss QR-bills

Applies to: Dynamics 365 for Finance and Operations

Summary


In 2020 it would become mandatory to process QR-bills (QR-slips) which should be issued in addition to the invoice. This update introduce possibility to generate QR-bills and process incoming QR-slips in Microsoft Dynamics 365 for Finance and Operations.

More information


Prerequisites

Feature activation

To enable the QR-bill functionality, it is required toactivate following options in the Feature management module:

  • Configurable payment ID
  • (Switzerland) QR-bills

Upon activation, Swiss QR-bill functionality is availablefor extended set of countries: CH, DE, AT, FR, IT (depending on the address ofthe legal entity).

 

GER configurations

Latest versions of the following GER configurations shouldbe imported from LCS repository:

  • Swiss QR-Bill text
  • Swiss QR-Bill Structured information
  • ISO20022 Credit transfer (CH)
  • ISO20022 pain.002
  • ISO20022 Camt.054

All requiredmodel and model mapping configurations would be imported automatically.

Common setup

Company Bank account

On the Bank account form, it is possible to specify theQR-IBAN field. QR-IBAN could be used simultaneously with ordinary IBAN and hassimilar validations in the system.

image.png

Cash discount and Tax codes descriptions

Cash discount and Tax codes used should have the QR-billdescriptions populated which would be used for QR-bill printing.

 

image.png

Legal entity Registration Id

To correctly populate the UID number on the generated QRslip, the value should be filled in in the Registration Id section should befilled in on the Legal entity setup with the Registration categorycorresponding to the VAT Id.

Accounts Receivable Setup

Payment Id

On this form you can configure the structure of the PaymentId which would be applied during the generation of the outgoing QR slips fromAR. Payment Id length is expected to be set up to 27 digits and generating thecheck digit using the Modulo11 algorithm.

Non-digit symbols are excluded from the Payment Id uponexecution, however it is recommended that number sequences used for Customeraccount and Invoice to have digits only.

image.png

The Payment Id type which would be applied on the invoice couldbe defaulted on the following level hierarchy.

  • AR parameters, tab Ledger and sales tax
  • Customer groups
  • Customer account, tab Payment Defaults
  • Method of payment, tab Payment control

Methods of payment – customers

Method of payment should be set up on the customer accounts whichwould be using the QR-bills to define the details of the company bank accountto which QR slip would be issued. For processing the incoming payments incamt.054 format, the GER import configuration should be set up.

Customer account

It is required that the default Method of payment isselected, and the Payment Id type should be filled in if not specified in the defaultsetup for customer groups of Account Receivable parameters.

In the Associated payment attachment field group, anew type QR-bill is added. When selected, the QR slip would be printed when thedocument of dedicated type is printed.

Giro report processing group

The way how the Billinginformation section is filled on QR slipis controlled by the settings of the Giro report processing groups. Ifnecessary, it is possible to configure different structure of this section onthe QR bill in GER and set up to have different structure to be used in

  • Account code abilityto specify the general setting in the company, specific format dedicated forcustomer groups or for the specific customer account
  • Customer relation valueof specific Customer account or Customer group if applicable
  • QR-Bill information select the GER format configuration responsible forfilling the Billing information
  • Print scissors symbol define whether the scissors symbol would be printed onthe report (could be important when choosing whether to send prited orelectronic version of the QR-slip )

AP setup

Methods of payment – vendors

In the Method of payment-vendors it is required to specifythe Bank account associated, select the required GER configurations for the exportand import for payment file processing, and set up Payment specification. A newPayment specification parameter value is available, Tp3.QR for payments correspondingto the incoming QR-slips. In addition to Payment specification setup, aspecific option is also available on the Vendor bank account for redefining theSpecification parameter see Vendorbank account setup.

Payment ID should be activated on the Payment attributes tabin order to inherit the Payment Id during the payment proposal with QR-bills.

Return format error codes and Return format status mapping

If pain.002 is expected to be used as a return file format,the Return format error codes and Return format status mapping is expected tobe set up. For more information, see also the documentation for ISO20022 pain.002functionality.

Vendor account

Standard setup of the vendor account for ISO20022 paymentsis expected. For more info, see also Setup vendors and vendor bank accounts for ISO20022 credit transfers.

Vendor bank account

It is required to populate the QR-IBAN field in the Vendorbank accounts. Other fields are expected to be populated as per normal paymentprocedure for payment Type 3 in Switzerland.

 

Additional option added for selection of the Paymentspecification parameter directly on the vendor bank account. When filled in, thisvalue would be taken with priority higher than the payment specification of theMethod of payment during the credit transfer file generation.

Accounts receivable

Generate the QR-slips

To generate the QR-slip for the document (i.e. customerinvoice), run the document printing (i.e. invoice View-Original), and theQR-slip will be generated as an additional report automatically. After that,the QR-bill could be exported to PDF and printed or sent electronically.

Functionality supported for:

  • Sales order invoices
  • Free text invoices
  • Project invoices
  • Interest notes
  • Collection letters
  • Account statement

The Payment Id value is stored when invoice is posted in Customertransaction as well as on the Invoice journal.

Import payments in camt.054 format

To the bank statement in camt.054 format from the bank, openthe Customer payment journal line and run the Import payment function. The 27-digitlong reference is expected in the Ref tag (in the RmtInf section) of the file.After the import, the payment transactions would be created and settled with customertransactions based on Payment Id value. For more information, see also Importthe camt.054 credit advice file into the Customer payment journal.

Accounts payable

The scope of supported functionality covers the process of manualimport of the QR code values into the input dialog which could be achieved byscanning devices transmitting the text value of the QR-code. The structure ofthe information from QR-code should follow the standards available at the SIXgroup website at the moment of the release. In case of any derivation from thestructure in the information encrypted in QR code or any format changes requiredto follow the device-specific behavior, this could be configured using theGeneric Electronic Reporting (GER)module without code modifications.

Import QR bills

It is possible to import the QR bills either into theInvoice journal, or into Pending vendor invoice destinations.

To import QR-bills into the Invoice journal, run the ImportQR-Bill function available in the Invoice journal lines form.

On the importing dialog, in the QR bill field, the nameof the GER format configuration is shown. In case of different (derived) formatis expected to be executed, it could be selected on the dialog. Enter the QRcode value in the Plain text of the QR-Bill field and click Ok.

On the next QR-Bill form, parsed values of the QRbill are presented on the QR-Bill tab. On the General tab, the values of therecognized Vendor, bank account, amount and other details which would beimported in the system. After clicking Ok, the Invoice journal line would becreated. In case this QR slip was imported earlier, user would be notified by awarning message. The info of imported QR bill is stored and available forreview on the Imported QR bills form.

 

For invoices associates with Purchase orders, it is possibleto create Pending vendor invoice headers based on QR bill information. Toimport the QR-bill, run the Import QR-bill function from the Pending vendorinvoices form, tab Process. Insertion of the QR code and record review andimporting is similar to the described above.

It is also possible to import the QR bill when the vendorinvoice is opened from the Purchase order (Generate invoice function, on theopened form menu Process - Import QR-bill). Importing procedure is same as Pendingvendor invoice, association with the purchase order would be inheritedautomatically.

To process the QR bill without predefined destination or to acustom destination, a special option in Periodic Tasks is available in Accountspayable periodic tasks. In this case, it would be required to select thedestination manually.

When the Plain text of the QR Bill left blank, it ispossible to run import from the text file, located i.e. on the SharePoint folderbased on the setup of the Electronic Reporting source.

After the invoice is posted, the vendor transaction withimported Payment Id would be available for settlement in the payment journal.

Payment files processing

Create Vendor payment journal lines using the Paymentproposal function. For more details, see also the link.

For QR-bill related payments, the Credit transfer file wouldbe generated based on the Payment Id value, retrieved from the QR code.

Importing of the pain.002 and camt.054 files are also availablefrom the Payment transfers form. For more details, see also Importthe pain.002 status return or camt.054 debit advice files into the Vendorpayment journal.