Finance | Project Operations, Human Resources, ...

User who created EFT file stored in SQL?

(0) Share

Report

Posted on by Althea ADS

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!

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (0)

Althea ADS on at

Like (0)

Report

RE: User who created EFT file stored in SQL?

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!
Suggested answer

Almas Mahfooz 11,006 User Group Leader on at

Like (0)

Report

RE: User who created EFT file stored in SQL?

I believe you can find out it from CM20203

select userid,EFTGenerationTimestamp from CM20203