Notifications
Announcements
No record found.
Hello, I created a Navigation List using the Navigation List Builder. The list is in the Financial navigation pane, and as a source I used sql script which is a "select * from " a view that I created using Victoria Yudin's example (https://victoriayudin.com/2011/04/27/sql-view-for-all-gl-transactions-in-dynamics-gp/). The view returns records when executed from SQL Management studio, and using "Options->Preview Data" in NL Builder, but when I save it and select from the Navigation sidebar, the list is empty. I granted the same permission to the view as I see on other views, like AccountTransations, but that didn't help. What am I missing?
If you're truly on Dynamics GP 2016 as it mentions here, then Navigation List Builder is part of SmartList Builder, and at that version, it is an eOne product, so it may be something that you want to run by them as well.
For a custom SQL view, usually we would assign the SELECT permissions to DYNGRP database role to it. I think the Grant.sql script also gives Delete, Insert and Update permissions to Views as well, though we don't really insert or update them like we do tables.
As a test, try creating a custom SmartList using the same view, does that show any data, or is that blank as well?
Thanks
Hello Derek. Thank you for your reply. The DYNGRP does have the Select rights. I created a SmartList using the same source, and it works fine. I also updated SmartList Builder as ours was several versions behind, but that also didn't help (I resaved the NL in the new Navigation List Builder). I suppose I'll try the eOne support next.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 584 Most Valuable Professional
André Arnaud de Cal... 499 Super User 2025 Season 2
Sohaib Cheema 254 User Group Leader
