Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

EFT History Tracking

(1) ShareShare
ReportReport
Posted on by 1,610
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
Categories:
  • Joseph Markovich Profile Picture
    Joseph Markovich 3,900 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 11,003 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,610 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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans