Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

ACH Settlement Date

Posted on by 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

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,003 User Group Leader on at
    RE: ACH Settlement Date

    Nicole, This can be done by small custom code.

  • Napolo Profile Picture
    Napolo 750 on at
    RE: ACH Settlement Date

    Were you able to find a resolution on this?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: ACH Settlement Date

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: ACH Settlement Date

    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!

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: ACH Settlement Date

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

  • Haydee Mirador Profile Picture
    Haydee Mirador 120 on at
    RE: ACH Settlement Date

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

    How would I do that in GP2010? Any workarounds?

    Thanks,

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: ACH Settlement Date

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans