GP Dynamics Navigation List is empty

(0) Share

Report

Posted on by LukUser

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:

Other

All responses (2)

Answers (0)

LukUser 5 on at

Like (0)

Report

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

Derek Albaugh on at

Like (0)

Report

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