12

Suggested Fri, 06 Apr 2018 20:15:32 GMT by Amber BellNew
Category: Tools - Other

Navigation Lists are a great way to manage master records and transactions. When Business Analyzer (part of the SQL Reports setup) are enabled, users will receive an error when loading if they are not setup correctly in SQL. Business Analyzer also significantly slows down the loading of the Navigation List windows. Currently, companies/partners need to run the following scripts to disable. Please make these default to not show. If someone wants to turn them on, they can do this manually.

Here are the scripts:

Step 1 Remove it from existing NAV lists:
 
Use DYNAMICS
go
update DYNAMICS..SY07225 set FactBoxVisible = 0
go
 
Step 2 – Remove from future ‘save as’ navigation lists:
 
CREATE TRIGGER
dbo.Update_SY07225_FactBoxVisible ON dbo.SY07225 AFTER INSERT
AS
Update SY07225 SET FactBoxVisible = 0
go