Is there any way to log functions users do in NAV on the back end. So lets say i delete a record or alter the GL etc, shouldnt there be some type of log that would show this type of activity?
You can turn on the Change Log, but it will drag on the system depending on how many things you monitor. If you want to monitor who does things like clicks Line → Item Tracking Lines there’s not a way to do it. You can just monitor what table people hit and what they do to them, not what action initiated it.
If you are using SQL Server 2008 Enterprise you could also implement some quite detailed auditing e.g. using SQL Audit:
http://dynamicsuser.net/blogs/stryk/archive/2011/10/04/using-sql-server-audit.aspx