Journal Entry Listings

Hi all, I am trying to obtain a listing of who can initiate, approve, and post
journal entries. I need the complete list of Journal entries from 2006. Is
there a canned report that already exists OR is there a method (SQL query)
to pull this information from the SQL database? Thank you in advance!

The client is running Axapta 3.06.

Hi IT-auditor,

Something like this?

SELECT dbo_LEDGERJOURNALTABLE.JOURNALNAME, dbo_LEDGERJOURNALTABLE.APPROVEDBY, Count(dbo_LEDGERJOURNALTABLE.POSTED) AS CountOfPOSTED
FROM dbo_LEDGERJOURNALTABLE
GROUP BY dbo_LEDGERJOURNALTABLE.JOURNALNAME, dbo_LEDGERJOURNALTABLE.APPROVEDBY
ORDER BY dbo_LEDGERJOURNALTABLE.JOURNALNAME;

Best regards,

Jan-Luuc