Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

EFT file for foreign currency transactions

Posted on by 245
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? 
 
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 1,735 on at
    EFT file for foreign currency transactions
  • Jun Wang Profile Picture
    Jun Wang 7,152 Super User 2024 Season 2 on at
    EFT file for foreign currency transactions
    you need to ensure one of your bank accounts handles USD
  • Suggested answer
    DM-31071505-0 Profile Picture
    DM-31071505-0 23 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. 1,735 on at
  • Suggested answer
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,554 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,588 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans