One additional tool that you can use to debug Nav is the SQL Profiler. This comes with most SQL installations. With it you can see all the SQL commands that Nav runs. The only issue with using it right away is that you get a lot of commands that done mean a whole lot.
Posted inDynamics NAV & BC Tips & tricks