How to: Create a Bankers' Automated Clearing Service File

In Microsoft Dynamics NAV, you can use Bankers' Automated Clearing Service (BACS) to process financial transactions electronically. To use BACS as the default vendor payment method, you must set export vendor payments to a BACS file using the Export BACS option. The resulting file can then be read by third-party applications to allow electronic bank payments.

You can keep track of BACS events, such as exporting and voiding, with the BACS Ledger Entry table. You can keep track of BACS transmissions using the BACS Register table.

To create a BACS file, you must follow these sequence of activities:

  • Set up vendor payment information in the Vendor card window.

  • Create the vendor payment using BACS.

  • Export the BACS payment file.

To set up vendor payment information in the vendor card

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

  2. Select the relevant vendor. On the Home tab, choose Edit.

  3. In the Payments FastTab.

  4. In the BACS Account No. field, select the BACS account for the vendor.

  5. Choose the OK button.

To create the vendor payment using BACS

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

  2. In the Vendor List window, select the relevant vendor for whom BACS payment was set up in the Vendor card window.

  3. To open the Payment Journal window, on the Home tab, in the Process group, choose Payment Journal.

  4. Fill in the fields as described in the following table.

    Field Description

    Document No.

    Specifies the document number for the journal line.

    Account Type

    Select the account type as Vendor.

    Account No.

    Specifies the code of the vendor that you selected in the Vendor Card window.

    Bank Payment Type

    Specifies that the payment type to be used for the entry on the payment journal line is BACS.

    Amount

    Specifies the total amount including VAT.

  5. Choose the OK button.

To export the BACS payment file

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

  2. In the Payment Journal window, select the payment journal for which the Bank Payment Type field was set to BACS.

  3. On the Navigate tab, in the Payments group, choose Export BACS.

  4. To create the BACS Export report, in the BACS Export window, select the Create BACS File check box.

  5. Choose the Print button to print the report or choose the Preview button to view it on the screen.

    The BACS information is now exported, and you can either save the data to a file, or you can open the file in the appropriate format.

See Also

Reference

BACS Ledger Entry
BACS Register

Concepts

Great Britain Local Functionality

Other Resources

Payment Journal