How can I modify the ACH file generated from process payments?
There are instruction on EpicCare. It is a C# file you can adjust if needed.
Look for Electronic Interface
1 Like
@gpayne I tried looking for the file but I cannot find it.
Also, we are on 2024.1 where this is not working.
It used to work on 2022.2 for us.
We got ours working by editing the PayrollElectronicDeposit_NACHA.cs file. Let me know if you need some help.
Here are some helpful pages, there is a validator but I would recommend sanitizing data first.
I had trouble with block count and had to write my own code to make that work properly, among other things. Lots of trial and error.
Generally something like:
E:\Epicor\WebSites\Kinetic\Server\Erp\EI
where “E:\Epicor\WebSites\Kinetic\Server” is your server installation folder.
1 Like
I compared our current ACH format to one produced in 2024.1.9 and they both look valid using the supplied Payment_US_ACH_Domestic EI file
In Kinetic - what is the proper code or object to get the Payroll settlement date into the NACHA file. It’s defaulting to Create Date
That’s not good. It was payment date. The files are not hard to edit, but did it change after 24.1?
This is on 2022.2.40
It is just creating a vDescDate variable from todays date.
What is the format of the Nacha file created within epicor? I am having an issue that the bank is saying the first 2 lines values - one variable is filling 2 different values. so I am looking for a breakdown of the fields that make up the nacha file that epicor generates so I use 2 different variables for these 2 values. It is the company ID if anyone is curious for 2023.2 Kinetic.
What positions are they saying are wrong. line 1 14-23 Immediate Origin and line 5 41-50 Company Identification both have the ID field from bank entry in them. It is in the code in 2024.2 and 2121.2 and my bank has never had an issue.
here is the file guide.
ACH File Details | ACH Guide for Developers
From the EI file
Interesting yes that is exactly what kinetic 2023.2.31 is doing for me and where the value is coming from on the epicor screen. My bank is saying that first value you mentioned Greg P is not supposed to be the same value as line 5. But the value is supposed to be the Bank number that is 222222223 value. Thanks for your confirmation also Greg P. I am getting a meeting with my bank IT tech person now.
Well, you have to make your bank happy. I have been able to use as is with two banks with no issues.
The file is on the server where Kevin says it was and well documented, so it should be not hard to adjust.