The Payments and Reconciliations (DK) Extension for Microsoft Dynamics for Finance and Operations, Business edition
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-V3, 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.
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:
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 Finance and Operations, Business edition 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 Finance and Operations, Business edition supports.
|Type 01||Type 04||Type 71||Type 73|
|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.
You only have to add the last 11 digits of the number. Finance and Operations, Business edition 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.
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.
Customizing Finance and Operations, Business edition for Finance and Operations, Business edition Using Extensions
Create SEPA Direct Debit Collection Entries and Export to a Bank File
Set Up SEPA Direct Debit
Post SEPA Direct Debit Payment Receipts
Collecting Payments with SEPA Direct Debit
Working with General Journals