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

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

I believe you can find out it from CM20203

select userid,EFTGenerationTimestamp from CM20203

Was this reply helpful? Yes No
Althea ADS 10 on at

Like (0)

Report

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!

Was this reply helpful? Yes No