Sage 100

Am I missing something obvious? Trying to regenerate a direct deposit ACH file; I know the prefix and bank code are correct... I leave the dates wide open and only get the pre-notes? No actual Payroll Data. This is the first DD since upgrading to version 5.2. I know Direct Deposit can vary, but I think the processing is pretty standard, right? Any suggestions?

I'm looking forward to suggestions. The last time this happened, I had to take the rejected file and fix it manually. I could not get it to recreate.

Try changing Batches to Include in Transmission to ""Only Batches Previously Transmitted"" and enter the effective date

No luck @JaneCavanaugh still just the prenotes. I found this on the KB - but now it doesn't generate anything!! Open Library Master, Utilities, Data File Display & Maintenance Enter file name PR_03xxx.soa (xxx=company code) Click Key Scan button, find the applicable Batch ID Select applicable Employee(s) that need to be removed i.e. xxxxYYYYYYYYY (xxxx=batch ID, YYYYYYYYY=employee number) Verify amount and click Delete button Go back to Header record (just the xxxx batch number) Click Edit button Field=1, Position=17, Length=1 Change from Y to N Close out of Data File Display & Maintenance Regenerate the ACH File: Expand Payroll, Direct Deposit, Generate Direct Deposit Interface Select Option: Batches to include in transmission: Only Batches Never Transmitted Click Proceed

I should note, I didn't actually delete any employee data, just changed the field from Y to N at the end of the instructions since it says it resets the batch

Try checking the effective date in DFDM. Maybe something is wonky there.

Looks fine... from what I can tell. Uggh Legacy.

Just checking. Payroll was updated?

@JaneCavanaugh never hurts to ask! Yep, the file was generated once properly. Then we had to make a change to the interface setup (needed the debit info). So then we attempted to regenerate the ACH and it's just being difficult. I have a call into Sage, if they come up with anything I will report back.

Was Sage able to help?

No, they of course blamed it on the 3rd party Direct Deposit development. Which I can see... the PR3 file is populated... it is just not generating the ACH file. So I am not sure whose fault that is. I have the developer looking at it right now for possible errors. Needless to day, I have one pissed off client who has 170 Direct deposit checks to reverse and re-issue as paper.

No fun. Who is the 3rd party developer?

*cough* Eide Bailly *Cough*

Thanks for the laugh. I wish we could have come up with the magic answer. Is there any way to edit the ACH file based on what was in past files?

We don't think so, the time it would take to edit, transmit and edit again would be pushing the limits. It is unfortunate for sure.

Very true. And you always have the possibility of not getting something right in the edit and having the file bounce. Sorry it didn't work out.

And the pre-notes have been approved for all the employees?

@alanniergarth Yep, all approved. I can see everything populated in the PR_03 file, and the ACH file created without issue on the initial processing, it is just the reprocessing that isn't working. We are going to attempt to recreate the issue in the test company tomorrow. Finders crossed it was just a one-time error.

I had a client change the bank account number they would not pick because that didn't match.

Now there's a thought @LarryBradford, I will look at that and let you know! I do believe a digit was off. If that works I owe you Starbucks at MotM!