The Payments and Reconciliations (DK) Extension for Microsoft Dynamics for Finance and Operations, Business edition

Article
09/15/2017

Make fast, error-free payments by exporting files that are formatted specifically for exchanges with your vendor or bank. These files speed up the payment and reconciliation processes, and eliminate errors that can happen when you manually enter the information on a bank website.

This extension supports file formats for several Danish banks. When you export payment information to a file, the extension packages the data into the format that your bank requires. For example, the formats include Bankdata-vl, BEC, SDC, and FIK, which many different banks use, and some that are more specialized for certain banks, for example, Danske Bank and Nordea. The extension also includes some formats for importing and reconciling bank statements.

Note

To use the extension, you must know the format that your bank or vendor requires. Some banks or vendors provide this information on their websites; however, you might need to contact their customer service to get the information.

Supported Bank Formats

This extension can apply the following file formats for payment files:

BANKDATA-V3
BEC-INDLAND
BEC-CSV
DANSKEBANK-CMKV
DANSKEBANK-CMKXKSX
DANSKEBANK
FIK71
NORDEA-ERHVERV-CSV
NORDEA
NORDEA-UNITEL-V3
SDC
SDC-CSV

To set up the extension

There are a few steps to get started.

Allow payment data exports. To help protect your data, this is not readily available.
Set up purchase and payables so that you do not require external document numbers on invoices. If needed, you can use the reference number to refer to a specific invoice.
Specify the payment method for each vendor. Payment methods define how you pay invoices from the vendor. For example, Bank, Cash, Check, or Account.
Specify the type of format to use for each of your bank accounts. For example, NORDEA, DANSKEBANK, SDC, and so on.

Additionally, you must assign vendors to a domestic Gen. Bus. Posting Group and a Vendor Posting Group. The Country/Region setting for the vendor must be Denmark (DK). For more information, see Setting Up Posting Groups.

To allow Dynamics NAV to export payment data

Choose the icon, enter Payment Journal, and then choose the related link.
In the Edit Payment Journal window, choose the Bank batch.
Choose the Allow Payment Export check box.

To specify a payment method for a vendor

The following table shows the combinations of FIK and GIRO payment methods that Dynamics NAV supports.

Element	GIRO Account	GIRO Account	FIK Creditor	FIK Creditor
Giro Account No. or FIK Creditor No.?	Giro Account No.	Giro Account No.	FIK Creditor No.	FIK Creditor No.
Allows Message to Recipient?	Yes	No	No	Yes
Contains Payment Reference number?	No	Yes, 16 digits.	Yes, 15 digits.	No

Choose the icon, enter Vendors, and then choose the related link.
Open the card, expand the Payments tab, in the Payment Method field choose the payment method.
Depending on your selection, you must complete other fields. See the table above for a description of the combinations.

To specify the format to use for a bank account

Choose the icon, enter Bank Accounts, and then choose the related link.
Open the card for the bank account.
In the Payment Export Format field, choose the format for your export file.

Choosing the FIK or Giro payment information for vendor invoices

Choose the icon, enter Purchase Invoices, and then choose the related link.
Choose the vendor. Remember, this must be a Danish vendor with an address in Denmark.
Create an invoice. The Payment Method and Vendor Number fields are filled in based on settings on the Vendor card. You can change them if you want.
In the Payment Reference field, enter the 15-digit number from the vendor invoice.

Tip

You only have to add the last 11 digits of the number. Dynamics NAV will add four zeros to the beginning of the number.
Post the invoice.

To use the extension to export payment data

Choose the icon, enter Payment Journals, and then choose the related link.
Choose the Suggest Vendor Payment Journals action.

Tip

If you want to export only specific payments, use the options for filtering the data.
If needed, you can add filters to export only specific payments.
In the Bank Payment Type field, choose Electronic Payment.
Choose the Export action.

Share via