Announcements
No record found.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 528 Most Valuable Professional
André Arnaud de Cal... 455 Super User 2026 Season 2
CU10121822-0 376
