- (Instructor) The Microsoft programmers who work on
Dynamics GP keep improving the product.
And I keep talking about smart lists,
because smart lists are so widely used.
It's the ad hoc query tool of Dynamics GP.
We click on the main menu, "Microsoft Dynamics GP",
and we click "Smart List".
And new in Dynamics GP 2016,
and available in Dynamics GP 2018,
is exporting of data to Excel
where it treats numbers as numbers,
which is what we want.
So when the number gets into Excel
we can run formulas on it.
And we don't have a problem where
it's treating the number as text,
which was something that users
had complained about in the past.
Let's take a look at that.
I have a smart list that I created under the sales series,
under customers, and I call it YTD.
Simple smart list, it just has three columns;
the customer number, the customer name,
and it has a dollar amount field.
And you see that there's some extra characters in there,
such as dollar signs, and commas,
and that would be treated more like a text field.
But that would cause a problem
if you're trying to do formulas in Excel.
In prior versions you had those kinds of problems.
You don't with the new smart list, and that's great.
I can add columns to the smart list
that are numeric fields.
We had a year to date sales.
And we have life to date sales, for example.
I can move that column up towards the front.
Click OK.
And now we have even more dollar amounts.
Okay, let's go ahead and see what happens
when we click the Excel button, and send this out to Excel.
It's creating a new worksheet, and it has put numbers in.
And you'll notice when I click in the individual cells here,
that's when you can see that the number is formatted
as a number, it is not formatted as text.
And therefore if I want, I can click in a cell
and put in formulas.
For instance, if I wanted to subtract column A
from column B, or multiply by some number,
or any other calculations, I'd like to deal with the numbers
that I've exported from my smart list into Microsoft Excel.