ACH Settlement Date

(1) Share

Report

Posted on by Haydee Mirador

120

We are currently using Microsoft Dynamics GP 11.00.1752 (SP2) and implementing ACH for US HSBC bank. US -NACHA-CCD format type has been selected with pad locks.

US HSBC is requiring us to change the effective date field in the Batch Header to be at least one day AFTER the Transmission Date.

Any ideas would be appreciated.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

MG-16101311-0 26,225 on at

Like (0)

Report

I believe what you are wanting here is the Settlement Date instead. You can enter a settlement date to be one day after the transmission date and this is controlled/entered in the Generate EFT Files window.

Was this reply helpful? Yes No
Haydee Mirador 120 on at

Like (0)

Report

Yes I want a Settlement Date to be one day after the transmission date.

How would I do that in GP2010? Any workarounds?

Thanks,

Was this reply helpful? Yes No
MG-16101311-0 26,225 on at

Like (0)

Report

On the Generate EFT File window, enter the Settlement Date for the file.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Are there any other solutions for this on GP 2015? Is there a setting somewhere to default the settlement date so it is always +1 days past transmission date?

I tried to select the calculated field option in the EFT file format window but doesn't look like I can create an actual calculated field off the date.

Otherwise the user will need to remember to change the settlement date in the Generate EFT Files window every time, correct?

Thanks!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello. I, too, am hoping there is a way to set a default settlement date so it is always +1 day past the transmission date. We would still need to be able to manually change the effective date to allow for weekends and holidays. But the default currently is the same date as the transmission date.

Banks are now allowing same day ACH transactions but with a fee for those. So if a user forgets to change the effective date in GP 2013 or 2015 field EFT generation window, we could get charged for the ACH being processed as a same day transmission.

Was this reply helpful? Yes No
Napolo 766 on at

Like (1)

Report

Were you able to find a resolution on this?

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

Nicole, This can be done by small custom code.

Was this reply helpful? Yes No