Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 754
  • Last Modified:

Question Smartlist Builder Microsoft Dynamics GP

We started using Smartlist Builder and looks great.

We would like to know if we can use external databases or tables besided GP creates.

Thank you
0
rayluvs
Asked:
rayluvs
  • 5
  • 2
2 Solutions
 
Steve EndowMicrosoft MVP - Dynamics GPCommented:
Hi,

SmartList Builder allows you to query non-GP databases and tables.  Go to Tools -> SmartList Builder -> Security -> SQL Table Security and select the tables and views.

So if you have custom tables in your GP database, it's easy to include them in a custom smart list.

I prefer to create views first, and then attach to those in SmartList Builder, but you can select multiple tables and do joins within SLB.  Just make sure to use GRANT statements to give DYNGRP access to the view (e.g. GRANT SELECT ON <view> TO DYNGRP).

It appears that SLB only displays the databases in the GP SQL instance.  I haven't tried connecting to a different SQL Server or instance.

Let me know if you have any additional questions.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
0
 
rayluvsAuthor Commented:
Thank you very much.  

So if we were to add another table from another database, not being the GP database working on, the best way is using a View where it would join these tables from another database and then use this View in Smartlist Builder.

Am I correct?
0
 
rayluvsAuthor Commented:
Hi, just noticed that the Query created in Smartlist Builder doesn't appear in the regular Smartlist so we can run them.

Si this also within "Tools -> SmartList Builder -> Security" so it can be used by users to display them?
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
rayluvsAuthor Commented:
Discard the last entry.  I opened up my other GP version 10 and the Queries created do show in Smarlist.  There must be  something wrong with the version 9 we are working in.  Will verify and if help needed regards this issue, will place another question.
0
 
Steve EndowMicrosoft MVP - Dynamics GPCommented:
Hi,

Regarding your question about other databases, yes, creating a view to join in the other databases or external data sources should work.  Just make sure to test with non-sa users to ensure that there are no permission issues with the view accessing the non-GP data.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
0
 
rayluvsAuthor Commented:
Thank you very much!
0
 
rayluvsAuthor Commented:
Will proceed to close.

please revise the question regarding missing queue in smartlist
http://www.experts-exchange.com/Microsoft/Applications/Microsoft_Dynamics/Q_27658583.html

Thanx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now