- [Narrator] What's new in Microsoft Dynamics GP 2016?
The SmartList Designer, go to the "Main Menu"
click on SmartList and if you click
the "new" button you'll see this new feature
the SmartList Designer which was new
in Dynamics GP 2016.
You may be familiar with earlier versions
of Dynamics GP and so you're familiar
with the SmartList Builder.
SmartList Builder is still available
as an add-on product from E1 Business Solutions.
It's available in 2016 and 2018
and that's a great product too.
But this is a new product that's now
a native inherent feature of the SmartList
and it's great!
Let me show you what it can do.
If we go to the SmartLists and we look under
the "Sales" series for instance you'll see
there is no "list" for sales reps.
As you see under the Sales series
under the "cards" which are the master records
we do have sales persons in the system
and maybe I want to list those sales persons.
But I'm not able to get that in the SmartList
if you just look at the out of the box SmartList.
I can't get that, because it's not available.
I can get an address, I can get a prospect
I can get the sales transactions,
well with this great new feature
we can now add it.
Click on "New" I give it a "List Name"
I'm going to call it "Sales Reps"
I can call it whatever I want.
I'm going to put it in the "Sales" series.
I've no fields selected yet I need to start selecting field.
First you select the table, then you select
the fields within the table.
Microsoft Dynamics GP I click on "Tables"
I click on the proper series, in this case
"Sales Reps" would be in the "Sales" series,
click the plus sign now it's going to show me a lot of tables
because it's showing me every table
in that sales series:
"Sales order processing, Invoicing,
Receivables Management, et cetera".
So I do have to scroll through quite a bit here
but there it is, "Sales Persons Master"
and if I click here it's going to give me
every single field, in that table
and that's probably too much for my needs.
So what I like to do is to click on
the plus sign and then simply pick out
the fields I'm really interested in seeing.
I need the "Sales Person ID"
I don't really need the middle initial
so I can skip over that.
I'd like to have the "Inactive" flag
and the "Sales Territory" and that may be all I need.
If I execute the query I can see that it's working.
And once I'm happy with it I can hit "Okay"
and there it is.
I've built my own SmartList using the SmartList Designer.