web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Error while generating EFT file

(0) ShareShare
ReportReport
Posted on by

I usually generate EFT files twice a month. No issues

Today I got the following error. when I hit Generate EFT files

"The General Journal Line with Journal Template Name PAYMENT, Journal Batch Name TRANSFER and Line No. 10000 does not exist"

Please help

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Error while generating EFT file

    StelaP,

    On the Payment Journal you have the first row filled in an Bank Payment Type = Electronic xxx? I ask as you are the 2nd person to have this issue in under a week? Can you send me a picture of the Payment Journal? Check to make sure you have no filters set on the Template Payment, Batch TRANSFER to see if you have a blank line.  

    Please verify the reply if it answers your query.

    Thank you,

    Steve

  • Suggested answer
    Katrin Kinau Profile Picture
    on at
    RE: Error while generating EFT file

    Hi,

    If this issue remains, I would suggest to create a support ticket for this. We can then check this more in detail.

    You can do this yourself if you are a CSP / Dynamics 365 Partner or ask your reseller to create a ticket on your behalf.

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Error while generating EFT file

    StelaP,

    Just checking in on if the EFT was resolved.

    Happy New Year.

    Steve

  • Community Member Profile Picture
    on at
    RE: Error while generating EFT file

    Hi Steve,

    What I discovered in order to deal with the issue is to generate the EFT file before posting the payment journal.

    I am not sure if an update was introduced, but up till Dec 14  I was posting the payment journal and then I was generating the EFT file.

    To your question , yes I have completed Bank Payment Type.... ElectronicXXX .

    Thank you and Happy Holidays!

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Error while generating EFT file

    StelaP,

    OK, I think I know the issue. Do me a favor and look at the General Journal Batch list. Look at the Batch you are using and does it have a Balancing Account No. set with a Type of G/L Account. If yes, remove the No. as the Payment Journal Line defines the Balancing Account to the Bank.

    pastedimage1609436549076v3.png

    Try processing again.

    Thanks,

    Steve

  • Community Member Profile Picture
    on at
    RE: Error while generating EFT file

    Hi Steve

    My balancing account type is defaulted to bank account and Balancing Account No is TD .

    I do not know  why I cannot post a picture here to show you.

    I think it is not my issue

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Error while generating EFT file

    StelaP,

    When replying, click 'Use rich formatting' then try to paste a pic.

    OK, do me a favor and follow these steps to see if you get the message then:

    1.After creating the Payment Journal, on the Action bar, click Bank/Export. This generates the remittance advice email to the Vendor and logs a record in the Generate EFT file so you can process

    2. Under Actions/Functions/Generate EFT File. Do you see records? (my image below is blank but you should see the EFT lines you are remitting). Click Generate EFT Files to complete the process.

    pastedimage1609438187008v1.png

    Tell me if this works for you.

    Steve

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,202

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,248

#3
Sumit Singh Profile Picture

Sumit Singh 2,893

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans