Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans