Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

EFT History Tracking

Posted on by 1,467
We have a site that is implementing GP with EFT for Receivables and would like to create an EFT history report, something that that would provide details on prior file generation.  I know the system may be lacking in this area and that two of the core EFT transaction tables (CM20202 and CM20203) clear once the file is processed.  Is there any way to reconstruct that history.  I've also looked at activity tracking and not sure if we can set that up just for EFT processes.  I'm open to thinking out of the box, perhaps a SQL trigger or something that would allow us to duplicate or save that data?
 
Any thoughts or recommendations would be appreciated.
 
JG
  • Joseph Markovich Profile Picture
    Joseph Markovich 3,863 on at
    EFT History Tracking
    You could definitely go the trigger route. Or use an auditing tool like Rockton Software's Auditor product.
     
    Terry, great to hear this is going to be added to GP!!! Yay!
     
    Joe
  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 10,996 User Group Leader on at
    EFT History Tracking
    JGarcia,
     
    I have done few customization related to EFT and in those I did use triggers. Custom table can be created for history purpose.
    It would be a customization to do this piece of code.
     
     
  • JGarcia123 Profile Picture
    JGarcia123 1,467 on at
    EFT History Tracking
    Thank you, Terry,
     
    Appreciate the feedback.  Just a thought has anyone tried applying a trigger to one of the ACH tables?  Could we do that without impairing the normal EFT operations.  I'm thinking a trigger could send the the ACH record to the custom table.
     
    Any thoughts on that?
  • Suggested answer
    Terry R Heley Profile Picture
    Terry R Heley Microsoft Employee on at
    EFT History Tracking
    It is great that you bring this up as it is a highly requested suggestion out on our site and we are looking to add this to the next release of Dynamics GP in October of 2024.  The problem is exactly as you stated, we do not store it in the table so then how to get this data back.  
     
    This is a top priority for us to have in the next release
    When an EFT batch is posted, the EFT PAYMENT REGISTER report is generated and can be printed only at this moment. 
     
    Thanks
    Terry Heley
    Microsoft 

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans