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 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.

The SmartList Builder window shows a list called (partially blurred) "GL DETAIL" with the primary table Account Transaction History and links to the Account Index Master and Account Master tables. The Account Index Master table is highlighted and all of its fields except Account Index are marked for display, with Account Number String marked to be displayed.
The SmartList Builder window shows a list with links to the Account Index Master and Account Master tables.

Linking to get the account description?  That's normal.  Linking to get the account number?  That's not needed…

How to display the Account Number instead of the Account Index

Here's a screenshot 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 screenshot, 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.

A picture of the same SmartList Builder window with the Account Index Master table removed. The Account Index field in Account Transaction History is highlighted with an arrow pointing to the blue arrow expansion button on the headings of the field list, where the Field Options are set.
The same SmartList Builder window with Account Index Master removed.

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 Set Field Options window for Account Index is shown, with the Account Index - Show Account Number option circled in red and enabled.
The Set Field Options window with the Account Index - Show Account Number option enabled.

The End Result

Using the field options, all the account index fields can be changed to show the Account Number automatically, and if an account description isn't needed, there is no need for having to link unnecessary tables all the time!