• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 364
  • Last Modified:

Smartlists

Hello all! We are looking to switch over from Quickbooks to dynamics and are currently looking at licensing options. Once option is SmartList Builder, and i'm trying to determine if the builder has value to us. Can someone please explain the advantages of SmartList builder, vs reports or customizing reports? Is it simply that any user can query SQL through creating a SMartlist without needing to know anything about sql?
0
jasonritchey
Asked:
jasonritchey
1 Solution
 
Abdulmalek_HamshoCommented:
Smartlist is a great tools to give you all possible data/rows/colums you need from Dynamics GP tables with ability to put up to four filters on the rows. But, in some cases you may need something like:

1- You need External tables (not originally in Dynamics GP) to be shown in SmartList for users to make filters and reporting.

2- You need to add calculated columns/values which aren't not calculated by Dynamics GP by default.

3- You need to link Dynamics GP tables in a different way, other than the original way or traditional relashionship.

HTH.
0
 
jasonritcheyAuthor Commented:
Not a complete answer
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

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