Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / EFT file for foreign c...
Business Central forum
Suggested answer

EFT file for foreign currency transactions

(1) ShareShare
ReportReport
Posted on by Nirmala Karunarathna 229
Is it possible to generate an EFT file in a foreign currency.

I am using Australia version of Business Central. Let's say we are processing a foreign currency transactions (USD). Can we generate an EFT file for that? 
 
Categories:
Financial Management
  • Suggested answer
    DM-31071505-0 Profile Picture
    DM-31071505-0 on at
    EFT file for foreign currency transactions

    Yes, it is possible to generate an EFT (Electronic Funds Transfer) file in a foreign currency in the Australian version of Business Central.

    The process involves ensuring that the necessary configurations are in place to handle foreign currency transactions and generating the EFT file accordingly:

     

    1. Configure Bank Account for EFT in Foreign Currency

    Step 1: Set Up Bank Account

    1. Navigate to Bank Accounts:

      • Go to Bank Accounts from the search bar or navigate through Cash Management > Bank Accounts.

    2. Select or Create a Bank Account:

      • Select the bank account you will use for the EFT.
      • If necessary, create a new bank account by clicking New and entering the required details.

    3. Configure Bank Account for Foreign Currency:

      • In the Bank Account Card, set the Currency Code to the foreign currency (e.g., USD).
      • Ensure other required fields are correctly filled out, including SWIFT Code, IBAN, etc.
    Step 2: Set Up EFT File Format

    1. Navigate to Bank Account Card:

      • In the Bank Account Card, navigate to the Transfers tab.

    2. Select EFT File Format:

      • Set the Bank Export/Import Setup Code to the appropriate EFT format for your bank that supports foreign currency.

    2. Configure Vendor for Foreign Currency Payments

    Step 1: Set Up Vendor Card

    1. Navigate to Vendors:

      • Go to Vendors from the search bar or navigate through Purchases & Payables > Vendors.

    2. Select or Create a Vendor:

      • Select the vendor you will be paying in foreign currency.
      • If necessary, create a new vendor by clicking New and entering the required details.

    3. Configure Vendor for Foreign Currency:

      • In the Vendor Card, set the Currency Code to the foreign currency (e.g., USD).
      • Ensure other required fields are correctly filled out, including Payment Method Code and Payment Terms Code.

    3. Process Foreign Currency Transactions

    Step 1: Create Purchase Invoices

    1. Navigate to Purchase Invoices:

      • Go to Purchase Invoices from the search bar or navigate through Purchases & Payables > Purchase Invoices.

    2. Create a New Purchase Invoice:

      • Click New to create a new purchase invoice.
      • Select the vendor configured for foreign currency payments.
      • Enter the details of the purchase invoice, ensuring the amounts are in the foreign currency (e.g., USD).

    3. Post the Purchase Invoice:

      • Once the invoice details are entered, post the invoice.
    Step 2: Make Payment

    1. Navigate to Payment Journals:

      • Go to Payment Journals from the search bar or navigate through Cash Management > Payment Journals.

    2. Create a New Payment Journal Line:

      • Click New Line to create a new payment journal entry.
      • Select the vendor and apply the payment to the posted purchase invoice.
      • Ensure the payment amount is in the foreign currency (e.g., USD).

    3. Post the Payment Journal:

      • Once the payment journal entry is complete, post the payment.

    4. Generate EFT File

    Step 1: Prepare EFT File

    1. Navigate to Export Payments:

      • Go to Export Payments from the search bar or navigate through Cash Management > Export Payments.

    2. Select the Payment Journal:

      • Select the payment journal batch that contains the foreign currency transactions.

    3. Generate EFT File:

      • Click Export to generate the EFT file.
      • Ensure the file format selected supports foreign currency transactions.
    Step 2: Verify and Submit EFT File

    1. Download the EFT File:

      • Once the EFT file is generated, download it to your local system.

    2. Verify File Details:

      • Open the EFT file and verify that the transactions are correctly listed in the foreign currency (e.g., USD).

    3. Submit to Bank:

      • Upload the EFT file to your bank’s online banking portal or submit it as per your bank’s requirements.

    Important Considerations

    • Bank Compatibility: Ensure that your bank supports EFT files with foreign currency transactions.
    • Exchange Rates: Ensure that exchange rates are correctly maintained in Business Central to accurately reflect the foreign currency amounts.
    • Bank Fees: Be aware of any additional bank fees or requirements for processing foreign currency transactions.
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 39 on at
    EFT file for foreign currency transactions
  • Suggested answer
    Mustafa Omerbegović Profile Picture
    Mustafa Omerbegović 277 on at
    EFT file for foreign currency transactions
    Hello Nirmala,
     
    since you are using Australian localization, it would be better to ask your partner if that feature is possible.
    I found the post on the learn.microsoft about Electronic Funds Transfer (EFT) in the Australian Version but generating file in a foreign currency is not mentioned.
     
     
    But on another post, I found information about the EFT feature and that it is not working in foreign currency.
     
     
     
    Greetings

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,955 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,987 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans