Tips, Tricks & Thoughts on Microsoft Dynamics GP
Quick Tip: Smartlist Builder & Account Numbers
Monday, January 16, 2012 Smartlist Builder, How To & Tips
This is a very short tip for those who use Smartlist Builder. I must say I see this ALL THE TIME. I hope to expand on little nuggets inside Smartlist Builder in the coming months because there are numerous time savers in there, that people have gone to great lengths to work around manually & unnecessarily!
The Issue
Someone creates a smartlist that has GL account numbers in it, perhaps it's a smartlist of a setup window, or of transaction distributions - whatever the case, they find the table and find Account Index fields, not Account Number fields. They don't know what to do, so they link in the Account Master table and/or the Account Index Master table to get the full account number in string format.
Linking to get the account description? That's normal. Linking to get the account number? THAT'S not needed... and I'll show you how.
How to display the Account Number instead of the Account Index
Here's a screen shot of a new Smartlist Builder window. Notice I have removed the Account Index Master link? I've linked the Account Master table still, because I wanted to get the Account Description field. In this screen shot, I've selected a field that is an Account Index field, meaning by default it will show a numeric value which is the primary key for that Account Number in every table in Dynamics GP. However Smartlist Builder has options, click on the Blue Arrow which is crudely shown in this picture.
Behind the blue arrow are several options. In this case, the one we want is circled: telling Smartlist Builder that this field is an account index and to show the Account Number instead.
The End Result
Using the field options, you can set all the account index fields to show the Account Number automatically, and if you don't need an account description for your particular smartlist, you just saved yourself from having to link unnecessary tables all the time!
RSS Feed
(1) Comments
Great post, and yes, that little blue arrow is SO subtle and easy to miss! There are lots of other goodies back there, too, and on more than one tab.
SmartList Builder cannot be blogged about enough, IMHO!
By Bob McAdam on Tuesday, January 17, 2012
Previous entry:
New Year’s Resolutions 2012
Next entry:
Why does the JE description say “Receivings Transaction Entry”?