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