Quick Tip: Smartlist Builder & Account Numbers

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!

(originally posted on www.kuntzconsulting.ca, and migrated to this site in October 2017)

3 thoughts on “Quick Tip: Smartlist Builder & Account Numbers

  1. Reply
    Bob McAdam - January 17, 2012

    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!

  2. Reply
    George Kuntz - October 21, 2015

    That is a great tip – thanks for sharing !

    1. Jen Kuntz - October 28, 2015

      Thanks George. PS you have a great last name! 🙂

Leave a Reply to Bob McAdam Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to top