90 Minds Community

After much back and forth with a small bank that doesn't seem to know how their software for accepting ACH files works we finally managed to upload/test a prenote file with a single employee's info in it.   Yea!

However when we tried to send the rest of the employees we were back to failing.

Looking in the ACH file  we were finding that some of the employee records appear to have a CR/LF immediately following the bank routing number so the record then appears on two lines and needless to say, get's rejected.  If it were every employee, I would suspect it was something in the set up.  Looking at the employee records,  I don't see anything obvious.

The test file we sent that succeeded did not have this problem.

I'm suspecting that the next thing to try might be to delete and re-enter the records for the employees with the problem.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
------------------------------

What version of Sage PR?

And as a general comment regarding bank ACH, it is a rare bank that know what is going on.  A lot of hit or miss uploads are the norm.,

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
------------------------------

How was the bank information entered?  Keyed or uploaded?  Have you dfdm'd the table to examine the raw information?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
------------------------------

Original Message:
Sent: 11-02-2022 13:16
From: Jeff Schwenk
Subject: Direct deposit set up from he** - payroll

What version of Sage PR?

And as a general comment regarding bank ACH, it is a rare bank that know what is going on.  A lot of hit or miss uploads are the norm.,

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
------------------------------

PR version is either 2.22.2 or 2.22.3 not sure which off hand.

It would have been hand uploaded.

I have looked using DFDM and did not see anything obvious.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
------------------------------

Original Message:
Sent: 11-02-2022 13:19
From: Jeff Schwenk
Subject: Direct deposit set up from he** - payroll

How was the bank information entered?  Keyed or uploaded?  Have you dfdm'd the table to examine the raw information?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
------------------------------


Original Message:
Sent: 11-02-2022 13:16
From: Jeff Schwenk
Subject: Direct deposit set up from he** - payroll

What version of Sage PR?

And as a general comment regarding bank ACH, it is a rare bank that know what is going on.  A lot of hit or miss uploads are the norm.,

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444

Currently working under the theory that whoever was entering the account numbers was doing a cut and paste from somewhere and was inadvertently picking up the CR/LF at the end of a line and pasting it into the direct deposit field and then the CR/LF is not visible even in DFDM.

We tried reentering one of the employees info and recreated the ACH file and it seems to have worked for that employee.  Fingers crossed.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
------------------------------

Original Message:
Sent: 11-02-2022 18:14
From: Thomas Rogers
Subject: Direct deposit set up from he** - payroll

PR version is either 2.22.2 or 2.22.3 not sure which off hand.

It would have been hand uploaded.

I have looked using DFDM and did not see anything obvious.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
------------------------------


Original Message:
Sent: 11-02-2022 13:19
From: Jeff Schwenk
Subject: Direct deposit set up from he** - payroll

How was the bank information entered?  Keyed or uploaded?  Have you dfdm'd the table to examine the raw information?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444


Original Message:
Sent: 11-02-2022 13:16
From: Jeff Schwenk
Subject: Direct deposit set up from he** - payroll

What version of Sage PR?

And as a general comment regarding bank ACH, it is a rare bank that know what is going on.  A lot of hit or miss uploads are the norm.,

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444

Copy / Paste from Excel does that.  Report to Sage and they can filter the extra blank characters out during data entry.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

Original Message:
Sent: 11-02-2022 18:42
From: Thomas Rogers
Subject: Direct deposit set up from he** - payroll

Currently working under the theory that whoever was entering the account numbers was doing a cut and paste from somewhere and was inadvertently picking up the CR/LF at the end of a line and pasting it into the direct deposit field and then the CR/LF is not visible even in DFDM.

We tried reentering one of the employees info and recreated the ACH file and it seems to have worked for that employee.  Fingers crossed.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
------------------------------


Original Message:
Sent: 11-02-2022 18:14
From: Thomas Rogers
Subject: Direct deposit set up from he** - payroll

PR version is either 2.22.2 or 2.22.3 not sure which off hand.

It would have been hand uploaded.

I have looked using DFDM and did not see anything obvious.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.


Original Message:
Sent: 11-02-2022 13:19
From: Jeff Schwenk
Subject: Direct deposit set up from he** - payroll

How was the bank information entered?  Keyed or uploaded?  Have you dfdm'd the table to examine the raw information?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444


Original Message:
Sent: 11-02-2022 13:16
From: Jeff Schwenk
Subject: Direct deposit set up from he** - payroll

What version of Sage PR?

And as a general comment regarding bank ACH, it is a rare bank that know what is going on.  A lot of hit or miss uploads are the norm.,

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444

Report to Sage?

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
------------------------------

Original Message:
Sent: 11-03-2022 12:06
From: Kevin Moyes
Subject: Direct deposit set up from he** - payroll

Copy / Paste from Excel does that.  Report to Sage and they can filter the extra blank characters out during data entry.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------


Original Message:
Sent: 11-02-2022 18:42
From: Thomas Rogers
Subject: Direct deposit set up from he** - payroll

Currently working under the theory that whoever was entering the account numbers was doing a cut and paste from somewhere and was inadvertently picking up the CR/LF at the end of a line and pasting it into the direct deposit field and then the CR/LF is not visible even in DFDM.

We tried reentering one of the employees info and recreated the ACH file and it seems to have worked for that employee.  Fingers crossed.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.


Original Message:
Sent: 11-02-2022 18:14
From: Thomas Rogers
Subject: Direct deposit set up from he** - payroll

PR version is either 2.22.2 or 2.22.3 not sure which off hand.

It would have been hand uploaded.

I have looked using DFDM and did not see anything obvious.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.


Original Message:
Sent: 11-02-2022 13:19
From: Jeff Schwenk
Subject: Direct deposit set up from he** - payroll

How was the bank information entered?  Keyed or uploaded?  Have you dfdm'd the table to examine the raw information?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444


Original Message:
Sent: 11-02-2022 13:16
From: Jeff Schwenk
Subject: Direct deposit set up from he** - payroll

What version of Sage PR?

And as a general comment regarding bank ACH, it is a rare bank that know what is going on.  A lot of hit or miss uploads are the norm.,

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444

Open a case, or post to Sage City, so they can scrub the blank characters from being stored in that field.  A couple years ago they did a fix for the same issue in Item Maintenance when creating a new Item Code (with a copy / paste from Excel)... and they should be able to do the same here, if you give them details.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

Original Message:
Sent: 11-04-2022 17:20
From: Thomas Rogers
Subject: Direct deposit set up from he** - payroll

Report to Sage?

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
------------------------------


Original Message:
Sent: 11-03-2022 12:06
From: Kevin Moyes
Subject: Direct deposit set up from he** - payroll

Copy / Paste from Excel does that.  Report to Sage and they can filter the extra blank characters out during data entry.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.


Original Message:
Sent: 11-02-2022 18:42
From: Thomas Rogers
Subject: Direct deposit set up from he** - payroll

Currently working under the theory that whoever was entering the account numbers was doing a cut and paste from somewhere and was inadvertently picking up the CR/LF at the end of a line and pasting it into the direct deposit field and then the CR/LF is not visible even in DFDM.

We tried reentering one of the employees info and recreated the ACH file and it seems to have worked for that employee.  Fingers crossed.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.


Original Message:
Sent: 11-02-2022 18:14
From: Thomas Rogers
Subject: Direct deposit set up from he** - payroll

PR version is either 2.22.2 or 2.22.3 not sure which off hand.

It would have been hand uploaded.

I have looked using DFDM and did not see anything obvious.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.


Original Message:
Sent: 11-02-2022 13:19
From: Jeff Schwenk
Subject: Direct deposit set up from he** - payroll

How was the bank information entered?  Keyed or uploaded?  Have you dfdm'd the table to examine the raw information?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444


Original Message:
Sent: 11-02-2022 13:16
From: Jeff Schwenk
Subject: Direct deposit set up from he** - payroll

What version of Sage PR?

And as a general comment regarding bank ACH, it is a rare bank that know what is going on.  A lot of hit or miss uploads are the norm.,

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444

Are you using this to look at that ACH file? https://sourceforge.net/projects/achviewer/

It's a great tool for helping see the layout of the file.

------------------------------
Wayne Schulz
wayne@s-consult.com
Schulz Consulting
(860) 516-8990
Moodus, CT
------------------------------

That looks cool.   However, I can see the format being messed up very easily even without it.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
------------------------------

Original Message:
Sent: 11-02-2022 14:27
From: Wayne Schulz
Subject: Direct deposit set up from he** - payroll

Are you using this to look at that ACH file? https://sourceforge.net/projects/achviewer/

It's a great tool for helping see the layout of the file.

------------------------------
Wayne Schulz
wayne@s-consult.com
Schulz Consulting
(860) 516-8990
Moodus, CT
------------------------------

Slightly related - found out my issue with that utility was I did not have a 64 bit java on my new laptop

------------------------------
Beth Bowers
(269) 358-0989
------------------------------

Original Message:
Sent: 11-02-2022 14:27
From: Wayne Schulz
Subject: Direct deposit set up from he** - payroll

Are you using this to look at that ACH file? https://sourceforge.net/projects/achviewer/

It's a great tool for helping see the layout of the file.

------------------------------
Wayne Schulz
wayne@s-consult.com
Schulz Consulting
(860) 516-8990
Moodus, CT
------------------------------