SQL Server Central has a nice look at options for auditing SQL server in their article What, When and who? Auditing 101
Frankly, after looking through them, if you want to audit Dynamics GP just buy FastPath’s Audit Trail product and save yourself a lot of work.