?
Solved

Question Smartlist Builder Microsoft Dynamics GP

Posted on 2012-03-28
7
Medium Priority
?
739 Views
Last Modified: 2012-04-02
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
Comment
Question by:rayluvs
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
7 Comments
 
LVL 18

Accepted Solution

by:
Steve Endow earned 2000 total points
ID: 37780051
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
 

Author Comment

by:rayluvs
ID: 37780076
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
 

Author Comment

by:rayluvs
ID: 37780082
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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 

Author Comment

by:rayluvs
ID: 37780349
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
 
LVL 18

Assisted Solution

by:Steve Endow
Steve Endow earned 2000 total points
ID: 37783018
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
 

Author Comment

by:rayluvs
ID: 37796368
Thank you very much!
0
 

Author Comment

by:rayluvs
ID: 37796404
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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses
Course of the Month10 days, 5 hours left to enroll

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question