I need a report showing user who posted and user who approved

(0) Share

Report

Posted on by Community Member

Hi,

I need a report (preferably in excel) that shows the user who posted and the user who approved each journal for a particular month. How can I produce this report?

My main problem at the moment is getting hold of the fields that contain the approval data - they don't appear in fields in Smartlist (or I can't find them). I know the tables the approval data sits in (APRVLUSERID) but I don't know how I get hold of this data.

Thanks

Robin

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Lyn Barr 1 on at

Like (1)

Report

The GL20000 & GL30000 tables both have APRVLUSERID and APPRVLDT (id & date). Those are the open year & historical year GL transaction tables.

Since you are on GP2015, you can easily add these fields to your SmartLists, using the SmartList Designer. Since you want this information in Excel, another option would be to create a refreshable Excel report by creating & using an .odc connection.

If you're unsure how to begin with either of these, here is a link to an introductory video on Designer: https://www.youtube.com/watch?v=Vz-d6RC2SYI

And here is a link that talks about publishing Designer reports to Excel: https://www.youtube.com/watch?v=C9h_3a_eumk

FYI, there are tons of ways to create refreshable Excel reports that are connected to your GP data. This video is one option of many.

Good luck, and have fun! Designing custom reports is one of my favoritest things. (bad grammar intentional!)

Side note: I actually found 16 tables in my TWO database with the APRVLUSERID column, using this script:

select TABLE_NAME from information_schema.columns

where COLUMN_NAME = 'APRVLUSERID'

order by TABLE_NAME

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Lyn

Was this reply helpful? Yes No