How to: Export Payments to a Bank File

When you are ready to make payments to your vendors using the Payment Journal window, you can export a file with the payment information on the journal lines. You can then upload the file to your electronic bank to process the related money transfers.

In the generic version of Microsoft Dynamics NAV, a global provider of services to convert bank data to any file format that your bank requires is set up and connected.

Note

The bank data conversion service may impose a limit on the number of lines that can be exported in one file. You will receive an error message if the limit is exceeded.

In addition, the generic version of Microsoft Dynamics NAV supports the SEPA Credit Transfer format. In your country/region, other formats for electronic payments may be available. For more information, see Make Payments with Bank Data Conversion Service or SEPA Credit Transfer.

To enable export of a bank file formats that are not supported by the generic or local versions of Microsoft Dynamics NAV, you can use the Date Exchange Framework. For more information, see How to: Enable Import/Export of Bank or Payroll Files Using the Data Exchange Framework.

Before you can export from a payment journal, you must enable export on the related journal batch. In addition, you bank account and the vendor’s bank account must be set up for electronic payment. For more information, see How to: Set Up SEPA Credit Transfer or How to: Set Up Bank Data Conversion Service.

To export payments to a bank file

  1. In the Search box, enter Payment Journals, and then choose the related link.

  2. Fill payment journal lines, for example, by using the Suggest Vendor Payments function. For more information, see How to: Suggest Vendor Payments.

    Note

    You can select how posting dates are inserted on the journal lines. For more information, see How to: Insert Due Date as Posting Date on Payment Journal Lines.

  3. When you have completed all payment journal lines, on the Home tab, in the Bank group, choose Export Payments to File.

    Any error messages will be shown in the Payment File Errors FactBox where you can also choose an error message to see detailed information. You must resolve all errors before the payment file can be exported.

    Tip

    When you use the Bank Data Conversion Service feature, a common error message states that the bank account number does not have the length that your bank requires. To avoid or resolve the error, you must remove the value in the IBAN field in the Bank Account Card window and then, in the Bank Account No. field, enter a bank account number in the format that your bank requires.

  4. In the Save As window, specify the location that the file is exported to, and then choose Save.

    The bank payment file is exported to the location that you specify, and you can proceed to upload it to your electronic bank account and make the actual payments.

When you receive confirmation that the payments are successfully processed in the bank, you can post the exported payment journal lines.

Tip

If you do not want to post a payment journal line for an exported payment, for example because you are waiting for confirmation that the transaction has been processed by the bank, you can just delete the journal line. When you later create a payment journal line to pay the remaining amount on the invoice, the Total Exported Amount field shows how much of the payment amount has already been exported. Also, you can find detailed information about the exported total choosing the Credit Transfer Reg. Entries button to see details about exported payment files. If you follow a process where you do not post payments until you have confirmation that they have been processed in the bank, you may want to control the risk of not accidently exporting payments again for open documents for which payment exports already have been made and are in process at the bank. You can control this in two ways.

  1. In a payment journal with suggested payment lines, you can sort on either the Exported to Payment File column or the Total Exported Amount and then delete payment suggestions for open invoices for which payments have already been made and you do not want to make payments for.

  2. Alternatively, on the Suggest Vendor Payments batch job, where you specify which payments to insert in the payment journal, you can select the Skip Exported Payments check box if you do not want to insert journal lines for payments that have already been exported.

To see information about exported payments, on the Home tab, in the Bank group, choose Payment Export History. For more information, see How to: Re-export Payments to a Bank File.

See Also

Tasks

How to: Import Bank Statements
How to: Set Up SEPA Credit Transfer
How to: Suggest Vendor Payments
How to: Insert Due Date as Posting Date on Payment Journal Lines

Other Resources

Payment Export Format
Exported to Payment File
Preferred Bank Account
Total Exported Amount
Recipient Bank Account
Allow Payment Export
Suggest Vendor Payments
Bank Data Conversion Field Mapping in Microsoft Dynamics NAV
SEPA CAMT Field Mapping in Microsoft Dynamics NAV
Ext. Doc. No. Mandatory
How to: Enable Import/Export of Bank or Payroll Files Using the Data Exchange Framework