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 :
Finance | Project Operations, Human Resources, ...
Suggested answer

Electronic Reporting - NACHA File

(1) ShareShare
ReportReport
Posted on by 16
Hi Experts,
 
I was wondering how we best achieve the requirement for NACHA files via Electronic Reporting .  NACHA files have a “blocking factor” of 10. This means that the total number of lines in a file must be a multiple of 10. If the line count is not divisible by 10,  then the file is padded with lines of 9s until it meets this requirement.
 
For example,
 
1) If the file has 6 lines we need to pad it with another 4 lines of 9's. File therefore has 10 lines
2) If the file has 10 lines, no padding of 9's is needed - File already has 10 lines
3) If the file has 98 lines we need to pad it with another 2 lines of 9's. File has 100 lines which is a multiple of 10.
 
Using the standard oob file, no padding is provided when we produce the file.
 
Any ideas.....
I have the same question (0)
  • TG-30052024-0 Profile Picture
    40 on at
    Electronic Reporting - NACHA File
    Hi, I'm subscribing to this, because I'd also like to know.  In another system, I used txt file to create the nacha file.  I was able to edit the txt file directly.  You may not want a user to be able to do this, but it was a work around to get the system to work as expected.
  • Suggested answer
    BP-20051347-0 Profile Picture
    16 on at
    Electronic Reporting - NACHA File
    Hi,
     
    I wanted to share what the developer did to overcome the dynamic padding needed to cater for the NACHA requirement.
     
    1) 9 specific lines of padding were created. Each padding line is triggered if the formula is true.
     
     
    2) In each line of padding the following formula was added (see screenshot). +4 in the formula represents the 2 Header Lines and 2 Batch Control lines which are required in the file.
     
    So if the difference is >=1. This line would be invoked and added to file, bringing it to block of 10.
     
     
    3) Line 2 formula - Note the >=2
     
    4) This is repeated for each padding line and the value is incremented. Below is a screenshot for Line 9
     
     
     

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,167

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 867 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 617 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans