I recently presented “NAV SQL from Friends to Foes” at the recent NAV User Group Summit.
Here’s a copy of the presentation:
Here’s the code I reference (in GitHuB).
My presentation is a whirlwind tour of the NAV database and SQL. But still, it’s a good starting point for folks who want to get comfortable with them both.
As I continue to build on this topic, I’m going to write about it here.
And I’m going to start by explaining how NAV is (and isn’t) a relational database.
And the first related topic is duplication of data — because this is a common source of confusion that all begins with NAV reports.Read more…