web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

EFT File effective date

(0) ShareShare
ReportReport
Posted on by 105

How do I set the Generate EFT file effective date.   Our bank requires the effective (transmission date) to be 1 to 2 days in the future, however when I generate the EFT file, it defaults to the date created.   This is creating problems in our transmission of NACHA files for expense reimbursements.  Any help out there? Thank you.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    Hi Dawn,

    EFT settlement dates are included in the next releast of GP - GP2013.

    Up until then you could look at using a calculated field to add two days to the creation date.

    You could also possible use the Posting date? and set this to be the required transmission date?

    Ian.

  • Robert Wary Profile Picture
    5 on at

    I too am struggling with this. I dont see how you can do a calculated field for a date. Is there any way you could show an example of this?

  • John Earle Profile Picture
    120 on at

    I have just recently run into this request with a client who is running GP2010.  I don't see a way to do this as a calculated field for EFTs since that option in the format looks fairly rigid in what you can do.

    Has anyone worked around this in any way? I could see using the posting date but would that cause issues if the EFT fell at month end and was posted in the next period?

  • Brenda Willey Profile Picture
    2,520 on at

    Is there a setting somewhere in GP2013 that allows the settlement date on the batch.  my installation on my machine has it but my client does not and my machine is actually one behind the client.

  • Napolo Profile Picture
    766 on at

    Hello,

    Did you find any resolution? We are facing the same thing!

    I have GP13 and in teh EFT File Format Maintenance window i can see where the settlement date is mapped. However, it is unclear how to add 2 days into the future.

    Was anyone successful with this?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans