Dynamics NAV – Query and Update System Indicator across multiple companies using SQL Script

Friday, July 24, 2015
Howdy from Dynamics Southwest! Starting from NAV 2009 R2, System Indicator can be used to differentiate between a production environment and a test environment, or identifying the companies with in the same instance, by displaying database, company name with coloring. For how to use the System Indicator, please refer to the online help: https://msdn.microsoft.com/en-us/library/hh879446(v=nav.80).aspx. In addition, Waldo covered this feature in the article http://dynamicsuser.net/blogs/waldo/archive/2011/01/10/nav-2009-r2-system-indicator.aspx, where the System Indicator Style codes get visualized. Because the System Indicator is configured at company level, in case you have many companies, this can be a pain to consistently set this up across all companies contained i  [Read More...]