I am looking for a filemaker solution that can export payment information in NACHA bank format to send to my financial institution for processing
I believe that's a fixed field length format which means you have to export everything as a single field using tab-separated text format. Create a single calculation field that concatenates the fields in the format listed in this document:
Pay close attention to the length specified for each field. Your fields need to be padded with spaces if they don't fit exactly in the required length. You can accomplish the space padding using this formula (the example here uses a 10 character length):
Right(MyField & " "; 10) //There are 10 space characters between the quote marks
So, your calculation might like something like this:
Right(MyField1 & " "; 2) & Right(MyField1 & " "; 10) & Right(MyField1 & " "; 5)
Yay! good ole fixed-width. I wrote a blog about what I did (use as example)
Fixed Width for EDI and Other Reporting | FileMakerHacks
Essentially what Jaymo did. I just created a few custom functions to make it easier. Read the comments and by all means search for other custom functions that can help you get there!
P.S. I'd bet more than half the functions and scripting I know, I learned from Jaymo wonderful examples and trainings over the years.
Good old "SDF format" as I recall it being called back in the day.
Nice to see that old format still lives somewhere.
Let's bring back SDF!
This is tricky stuff. I would contact your bank and ask them for an example. Apparently banks can have custom requirements for some of the fields. Your bank also probably have a "test mode" for your account where you can test uploads until the format is correct.
There is at least one library to help with this file generation ... for you, or at least automating some of the tedious aspects.
So, from FMP, you would create a small micro-service and integrate this library with your app. The possible future benefit to you for using a micro-service is that a micro-service is not tied to or dependent on FMP. Thus, you could create these files in many ways, not just with FMP.
GitHub - mosscode/ach: A library for working with ach/nacha files
Doing a couple of quick searches, I also saw:
The good news is that most of us are experienced with generating these kinds of files so you'll be able to get lots of help regardless of your approach.
Retrieving data ...