How to: Consign Payments to a Bank File

  • Article
  • 5 minutes to read

When you are ready to brand payments to your vendors, or reimbursements to your employees, you lot can export a file with the payment information on the lines in the Payment Periodical window. You can then upload the file to your bank to process the related money transfers.

In the generic version of Microsoft Dynamics NAV, a global provider of services to convert bank information to any file format that your bank requires is fix up and connected. In N American versions, the same service tin can be used to ship payment files as electronic funds transfer (EFT), even so with a slightly different procedure. Come across step 6 in the "To export payments to a bank file" section.

Y'all use the Credit Transfer Registers window to view the payment files that accept been exported from the payment journal. From this window, you lot can besides re-export payment files in case of technical errors or file changes. Note, however, that exported EFT files are not shown in this window and cannot be re-exported.

To consign payments to a bank file

  1. Choose the Search for Page or Report icon, enter Payment Journals, and and so choose the related link.
  2. Fill payment journal lines, for example, by using the Advise Vendor Payments function. For more information, encounter How to: Suggest Vendor Payments.
  3. Fill in the fields on the payment journal lines every bit necessary. Choose a field to read a short description of the field or link to more information.

Notation

If you are using EFT, you must select either Electronic Payment or Electronic Payment–IAT in the Banking concern Payment Type field. Different file export services and their formats crave different setup values in the Bank Business relationship Carte and Vendor Banking concern Account Card windows. You lot will be informed about wrong or missing setup values every bit yous try to export the file.

  1. When you take completed all payment journal lines, choose the Export activity.

  2. In the Export Electronic Payments window, fill in the fields as necessary.

    Whatever error messages will exist shown in the Payment File Errors FactBox where y'all can too choose an fault message to see detailed data. You must resolve all errors before the payment file can be exported.

    Tip

    When you use the bank data conversion service, a common error message states that the banking concern 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 Business relationship Card window and then, in the Banking company Account No. field, enter a bank account number in the format that your bank requires.

  3. In the Save Every bit window, specify the location that the file is exported to, and then choose Save.

    Annotation

    If yous are using EFT, salvage the resulting vendor remittance form equally a Word document or select to have it emailed straight to the vendor. The payments are now added to the Generate EFT File window from where yous can generate multiple payment orders together to save transmission toll. For more information, see the following steps.

  4. In the Payment Journal window, cull the Generate EFT File action.

    In the Generate EFT File window, all payments set up for EFT that you have exported from the payment journal for a specified bank business relationship but not all the same generated are listed on the Lines FastTab.

  5. Cull the Generate EFT File action to consign one file for all the EFT payments.

  6. In the Save Every bit window, specify the location that the file is exported to, and then cull Salvage.

The bank payment file is exported to the location that you specify, and you tin can go along to upload it to your electronic banking concern account and brand the actual payments. And so y'all tin can post the exported payment journal lines.

To export payments that correspond customer refunds

The following describes a piece of work-around for exporting electronic refund payments.

Caution

The resulting payment periodical lines cannot exist posted, deleted, or voided.

  1. Fix the customer as a vendor. Proper name it "Customer X for Refunds", for example. For more information, see How to: Register New Vendors.
  2. On the payment journal line for the customer, fix the Account Type field to Client, and the Document Type field to Refund.
  3. Perform the normal steps for payment consign as described in the "To export payments to a banking concern file" section.

To programme when to post exported payments

If you lot practice non want to mail service a payment periodical line for an exported payment, for example considering y'all are waiting for confirmation that the transaction has been candy past the depository financial institution, you can simply delete the journal line. When you subsequently create a payment journal line to pay the remaining amount on the invoice, the Total Exported Amount field shows how much of the payment corporeality has already been exported. Besides, yous can find detailed data almost the exported total by choosing the Credit Transfer Reg. Entries button to come across details virtually exported payment files.

If you follow a process where yous do not mail service payments until you have confirmation that they have been processed in the bank, yous can control this in two ways.

  • In a payment journal with suggested payment lines, yous can sort on either the Exported to Payment File column or the Total Exported Amount then delete payment suggestions for open invoices for which payments accept already been fabricated and you do not want to make payments for.
  • In the Propose Vendor Payments window, where you specify which payments to insert in the payment journal, y'all can select the Skip Exported Payments check box if yous do non want to insert journal lines for payments that have already been exported.

To run across information about exported payments, choose the Payment Consign History action.

To re-consign payments to a bank file

You can re-export payment files from the Credit Transfer Registers window. Before you delete or post payment periodical lines, you tin also re-consign the payment file from the Payment Journal window by simply exporting it again. If you lot have deleted or posted the payment journal lines after exporting them, you lot tin can re-export the same payment file from the Credit Transfer Registers window. Select the line for the batch of credit transfers that you want to re-consign, and then use the Reexport Payments to File action.

Note

Exported EFT files are not shown in the Credit Transfer Registers window and cannot be re-exported.

  1. Choose the Search for Page or Report icon, enter Credit Transfer Registers, and and so choose the related link.
  2. Select a payment export that y'all want to re-export, then choose the Reexport Payment to File action.

See Also

Dynamics 365 Concern Key
Payables
Setting Up Purchasing
Working with Dynamics NAV