Skip to main content

Notifications

Announcements

No record found.

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

ACH Batch Export "The file export has one or more errors" - But there are no error messages presented on any line

Posted on by 19

When attempting to export a payment journal batch for ACH payments to vendors we are receiving the error message of "The file export has one or more errors. For each line to be exported, resolve the errors displayed to the right and then try to export again" I found another post which states this maybe a chasing issue on the payment journal page. Based on what i have seen in my instance its not a cache issue, its consistent, I have cleared browser cache installed Edge update closed browser restarted tried incognito mode, nothing clears the generic error message of "The file export has one or more errors. For each line to be exported, resolve the errors displayed to the right and then try to export again". 

When I try Preview Posting i get an error message of "Check Exported must be equal to 'Yes'  in Gen. Journal Line: Journal Template Name=PAYMENT, Journal Batch Name=ACH, Line No.=60000. Current value is 'No'."  This is accurate error because Posting can not be completed until the Export process is done and that flag is set by export process. There are no other errors present on any line in the batch, none are red and we have clicked each line one by one and there are no errors listed for any line in the Payment File Errors section. We were able to run this exact same process last week and man many previous weeks without this error. Any help or direction on this would be appreciated. 

  • Suggested answer
    RS-18091740-0 Profile Picture
    RS-18091740-0 4 on at
    ACH Batch Export "The file export has one or more errors" - But there are no error messages presented on any line
    There may be more than 1 resolution to this error, and some responses included "delet and re enter" which worked for some. 
     
    For me, I found 2 fields not filled in on the actual Payment Journal Details.  I filled them in and the process flowed successfully. 
     
    I believe what is happening is the same, but 
    1. Others started over, and inadvertantly corrected or populated a Payment Journal field. 
    2. I didn't start over, but corrected or populated a Payment Journal field.
     
    Hopefullly this helps someone. 
  • RE: ACH Batch Export "The file export has one or more errors" - But there are no error messages presented on any line

    I have the same issue, but this is my first time setting up ACH/EFT payments in BC.  I have deleted everything and started over, but I am still getting the same error.  I have 2 documents I found online about how to setup this up.  I have been though both of them multiple times.  How can I see if there are orphaned records?  Any other advise would be appreciated.

  • Suggested answer
    ClementScanty Profile Picture
    ClementScanty 19 on at
    RE: ACH Batch Export "The file export has one or more errors" - But there are no error messages presented on any line

    This issue was solved by creating a new batch for the ACH payments seems there is some known issue with orphaned records on the DB table related to the original batch that was previously used which were causing the error but not visible on the Ui. Deleted the payment items from the original batch and Created and approved a new batch and loaded the items there and the export was able to complete successfully without presenting the error.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans