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.

A country-specific update for German ISO20022 urgent credit transfer and SEPA credit transfer of version 3.1 in Microsoft Dynamics AX


View products that this article applies to.

Business requirements

German recommendations for SEPA payments, including Urgent credit transfer, version 3.1 are located on EBICS.de page, document Appendix 3 Data Formats V3.1.pdf.

See paragraphs:

  • 10 Same-day urgent credit transfers (submission via pain.001)
  • 2.2.1 Credit Transfer Initiation – pain.001.001.03

↑ Back to the top


Overview

SEPA/ISO20022 credit transfers in Microsoft Dynamics AX 2012 R3, R2, 2012 and 2009 SP1

The SEPA credit transfer export payments are designed in Microsoft Dynamics AX 2012 R3, R2, 2012 and 2009 SP1 through the Application Integration Framework (AIF). More details can be found in Technet Article: https://technet.microsoft.com/en-us/library/hh227461.aspx

To generate the country/region specific version of the SEPA credit transfer file, in the Payment processing data form, in the Value field, type the following value:

  • For Germany, type "DE".

You may use this format if you need to generate the SEPA payment (euro payment to country in SEPA zone).

More info can be found in SEPA CT Whitepaper.

No change in AIF SEPA payment format is introduced with this feature.

For Germany, the extension of ISO20022/SEPA payment formats for generating Same day urgent credit transfer in ISO20022 format is implemented by using the payment formats functionality. The new payment format is available:

  • Generic ISO20022 CredTrans DE.

You may use this format if you need to generate the SEPA or ISO20022 same day urgent credit transfer following German guidelines. You may also use this format if you need to generate the ISO20022 generic credit transfer (for example, for cross border payments in foreign currency).

The following payment types are described in country-specific implementation guidelines and user is able to initiate them from the payment journal:

Country

Details

GERMANY

SEPA – domestic and cross border [TRF]:

Vendor bank account country is Domestic, EU or EFTA in Foreign trade parameters AND

Currency = EUR AND

Service level in payment journal = <Empty> or "SEPA"

Urgent credit transfer

Vendor bank account country is Domestic, EU or EFTA in Foreign trade parameters AND

Currency = EUR AND

Service level in payment journal <> <Empty> or "SEPA"

User should always choose "URGP" in the Service level field and "INTC" or "CORT" in the Category purpose field for this payment type, following German guidelines.

Note: No bank specifics are considered in the generated file. Any bank specific requirements which are not directly defined in German implementation guidelines should be implemented as customization.

Generic

All other payments

Not described in German guidelines and thus, if generated, follows ISO20022 generic rules without German specifics.

Currently, such payments in Germany are generated through DTAZV German-specific payment format, but ISO20022 as trend may be extended in the future for this payment type as well.

↑ Back to the top


Setup

Before you can create ISO20022 and SEPA export files, you must set up the legal entity and bank account information in Microsoft Dynamics AX.

Set up legal entity information

Use the Legal entities form to set up legal entity information for ISO20022/SEPA payments.

For the legal entity initiating the payment and debtor legal entity, set up Name, Address of legal entity (make sure, ISO country code is set on Country/region of legal entity).

Set up company bank accounts for ISO20022/SEPA credit transfers

Use the Bank accounts form to enter the bank account information for your legal entity (Cash and bank management > Common > Bank accounts) to make ISO20022/SEPA payments for bank account for the legal entity that is requesting the transfer.

Country

Details

GERMANY

Bank account identification: You should set up IBAN.

Enter IBAN in the Additional identification > IBAN field.

Bank identification: You could provide SWIFT code (BIC).

Enter SWIFT/BIC in Additional identification > SWIFT code.

Set up vendors and vendor bank accounts for ISO20022/SEPA credit transfers

Use the Vendor form to set up vendor information for ISO20022/SEPA payments (Accounts payable > Common > Vendors > All vendors).

Set up Name and Address of the vendor.

Note:

For Germany for Urgent credit transfer payment type, Creditor address line (including Country code) may not exceed 70 characters in total and the value from the Address will be cut to meet this requirement.

Make sure that ISO country code is set on Country/region of a vendor.

Use the Vendor bank accounts form to set up information about vendor bank accounts.

Address identification:

Make sure that the address is set up for a vendor bank account, and the country code of the vendor bank account address is set up in the Foreign trade parameters, Country/region properties tab and the country/region type is assigned to it: Domestic, EU, EFTA, or Third party since the identification of payment type depends on this setup.

Identification of SEPA and Urgent credit transfer payments:

Payments in EUR and to bank accounts in countries with Country/region type = Domestic, EU or EFTA are automatically identified as SEPA payments or Urgent credit transfer.

All other payments are identified as Other payments and exported via generic ISO20022 rules with no German specifics.

Vendor bank account identification:

You should provide bank account identifiers and bank identifiers for a vendor bank account that is used for ISO20022/SEPA payments:

Enter IBAN in the General > IBAN field.

Vendor bank identification:

You could provide SWIFT code (BIC):

Enter SWIFT/BIC in Additional identification > SWIFT code.

Set up Methods of payment for ISO20022/SEPA credit transfers

Use the Methods of payment – vendors form to set up the method of payment.

Field

Description

Payment type

Choose "Electronic payment" for SEPA and Urgent credit transfer payment types.

File formats \ Export format

Choose

  • Generic ISO20022 CredTrans DE for Germany

General \ ISO20022 codes \ Charge bearer

Generic: Choose the default code for identification of who pays charges.

For ISO20022 format, one of the following codes can be applied: DEBT, CRED, SHAR.

The default value will be transferred to a payment journal line where can be changed by user manually.

Note for Germany:

For SEPA and Urgent credit transfer, always constant "SLEV" is exported.

General \ ISO20022 codes \ Service level

Generic: Choose default code for priority of payment.

Example codes for ISO20022 format: URGP, NURG, SDVA

The default value will be transferred to a payment journal line where can be changed by user manually and will be exported to a payment file if filled.

Note for Germany:

For SEPA payments, always constant "SEPA" is exported.

For Urgent credit transfer, choose "URGP".

General \ ISO20022 codes \ Category purpose

Generic: Choose the default code for payment category, for example, "CORT" for trade settlement payments.

The default value will be transferred to a payment journal line where can be changed by user manually and will be exported to a payment file if filled.

Note for Germany:

For SEPA and Urgent credit transfer, choose either INTC or CORT as per German guidelines

↑ Back to the top


Transactions

Create and post invoices from vendors in a usual way.

Create and export payments using ISO20022 generic payment format

Use the Payment journal form to create and export vendor payments.

  1. Click Accounts payable > Journals > Payments > Payment journal. Create or select a journal.

    For Germany: On Tab General in the group ISO20022 codes, fill the default values for the current payment journal: Charge bearer, Service level, Category purpose.

    The values on the Payment lines will be defaulted with the chosen values on the journal header, or with the default values from method of payments (if filled).

    You can change the default values for each payment line on the Payment tab, group of fields ISO20022 codes.

  2. Click Lines to open the Journal voucher form for the payment journal lines.

  3. Create the payment lines by using the Payment proposal function.

  4. In the Journal voucher form, on the Overview tab, select a line.

  5. For Germany: On the Payment tab, you can fill the fields valuable for payment initiation:

Payment ID – Review or enter an ID to be used in Unstructured creditor reference information (German specifics).

Note – Enter payment notes to be presented in Unstructured remittance information, if applicable.

Tip – Set up Organization administration > Default descriptions for automatic generating Payment notes with information about settled invoices.

  1. Click Functions > Generate payments. In the Method of payment field, select a method of payment: Generic ISO20022 CredTrans DE for Germany.

  2. And then in the Bank account field, select the bank account that the payment is drawn from.

  3. Click Dialog. In the Dialog form, enter information for the export file. The following table provides information about each field.

Field

Description

Processing date

Enter the date when the bank should process the payments.

Remittance information

Select the format for remittance information, depending on the requirements of your country/region or bank:

  • Structured – Select this option to export Structured creditor reference information. This option is not allowed for SEPA and Urgent credit transfer in Germany.
  • Unstructured – Select this option to export Unstructured payment reference (payment Id, payment notes or list of settled invoices).

Batch booking

Request batch booking if needed:

  • No – batch booking = FALSE
  • Yes – batch booking = TRUE

Generic (not allowed for SEPA and urgent credit transfer)

  • Unknown – "Batch booking" tag is not exported.

File name

Enter or select the file name for the ISO20022 XML file. Use the file extension .xml. The file name is also displayed on the Attending note report.

Control report

Select this check box to print a report that contains the payment information. You can specify the report options by clicking the Control report button.

Attending note

Select this check box to print the Attending note report. You can specify the report options by clicking the Attending note button.

Payment advice

Select this check box to print the Payment advice report. You can specify the report options by clicking the Payment advice button.

Main account/customer number

Enter the main account number or the customer number. This number is displayed on the Attending note report.

Sequence number

Enter a sequence number to identify the file. The sequence number is displayed on the Attending note report.

Covering letter from quantity of invoices

Enter the value of the quantity of invoices, from which a covering letter report is printed.

  1. Click OK.

  2. In the Generate payments form, click OK to create the payment file.

Send the credit transfer file to the bank

When you generate payments, the payments are saved to the location that you specify in the Dialog form. The next step is to send the .xml file to your bank. This process varies from bank to bank. Follow the instructions from your bank to submit the files to the bank for processing.

↑ 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.

Prerequisites

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

  • Microsoft Dynamics AX 2012 R3
  • Microsoft Dynamics AX 2012 R2
  • Microsoft Dynamics AX 2012
  • Microsoft Dynamics AX 2009 SP1

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, kbexpertiseinter, kbexpertisebeginner, kbexpertiseadvance, kbqfe, kbsurveynew, kbnoloc, kbmbsquickpub, kbmbspartner

↑ Back to the top

Article Info
Article ID : 4037721
Revision : 18
Created on : 10/26/2017
Published on : 10/26/2017
Exists online : False
Views : 378