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
Thanks Lyn
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (