Objects4NAV

SQL Views

Localized SQL views for NAV 2013 R2

In Dynamics NAV 2009 and older we had an option to maintain views in the database. Activating this caused NAV to create a view for each language and every table in the database. This is a useful thing if you are building BI on top of your SQL and would like to skip all the translation work. This however had some drawbacks. Every table in the database is maintained Option…