Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

GP Dynamics Navigation List is empty

Posted on by 5

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?

Categories:
  • LukUser Profile Picture
    LukUser 5 on at
    RE: GP Dynamics Navigation List is empty

    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.

  • Suggested answer
    RE: GP Dynamics Navigation List is empty

    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

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans