Our customer on GP18R2 asked where GP stores the user who clicked to Generate EFT file. I cannot locate anywhere this may be in Company, Financial or PM tables. Any guidance is greatly appreacited!
I believe you can find out it from CM20203
select userid,EFTGenerationTimestamp from CM20203
I found this late yesterday in the CM900001 table. I created a new user and only created the EFT file as that user, then searched all db tables for that user ID and found it that way. Checking now, my CM20203 table is empty. Maybe that is only populated until the file is generated.
Thank you for getting back to me!
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 756 Super User 2025 Season 2
CA Neeraj Kumar 678
Martin Dráb 526 Most Valuable Professional
