Applications Server
 

Microsoft Dynamics GP 2010 : Tailoring SmartLists by adding Fields

11/15/2011 4:22:58 PM
Default SmartLists contain predefined sets of fields. However, users always want to add additional fields or rearrange existing columns. Fortunately, Dynamics GP provides this functionality out of the box.

Users can add fields to SmartLists, remove fields, or rearrange their order allowing users to fine tune SmartLists to meet their needs. In this recipe, we'll look at adding and rearranging fields in SmartLists.

How to do it...

To add a field to a SmartList:

  1. 1. Click on the SmartList button on the menu bar at the top or select Microsoft Dynamics GP from the top and click on SmartList.

  2. 2. Select Financial, then Account Transactions in the left pane.

  3. 3. Click on Columns:

  1. 4. Click on Add. This exposes all of the available fields for a SmartList, not just the defaults:

  1. 5. Select Account Type and click on OK to add this field to the SmartList:

To rearrange fields on a SmartList:

  1. 1. Continue on the current screen and select Account type

  2. 2. Click on the Up arrow button twice to move Account Type above Credit Amount:

  1. 3. Click on Debit Amount and click on the Up arrow button once to move it ahead of Credit Amount:

  1. 4. Click on OK to finish

How it works...

The ability to add, remove, and rearrange fields on a SmartList gives users even more control over SmartList reporting. When users can satisfy their own custom reporting needs it significantly reduces the reporting burden for administrators.

There's more...

Sometimes users need to remove fields from SmartLists as well. Also, field changes are NOT saved from one session to another. So saving the SmartList as a Favorite after the changes are made is important. Finally, it is possible to add, remove, and rearrange fields on the default SmartLists.

Removing fields

Sometimes a SmartList just has more information than needed. To remove fields and clean up a SmartList click on Columns, select the column to delete, and click on Remove.

Favorites

Field changes to SmartLists are not saved. Clicking on another SmartList or otherwise moving off of a SmartList will cause field changes to reset. Saving the SmartList as a Favorite after the changes is the only way to preserve field changes. The recipe Speeding up access to information with SmartList Favorites has specifics on saving SmartLists.

Default SmartLists

The default SmartLists can also be modified to include or exclude columns and adjust the order as well. This is done by selecting Administration from the Navigation Pane and then selecting SmartList Options under Setup.

In this window, fields are added or removed by selecting or deselecting the checkbox next to a column. These can be reordered using the arrows at the right:

 
Others
 
- Microsoft Dynamics GP 2010 : Controlling data with SmartList Record Limits
- Upgrading and Configuring SharePoint 2010 : Configuring a content database
- Upgrading and Configuring SharePoint 2010 : Creating and associating content databases to a specific web application and site collection
- Administering Active Directory Domain Services : Working with Active Directory Snap-ins (part 2) - Saving and Distributing a Custom Console
- Administering Active Directory Domain Services : Working with Active Directory Snap-ins (part 1)
- Microsoft Dynamic CRM 2011 : Canceling and Reopening a Service Request Case
- Microsoft Dynamic CRM 2011 : Resolving a Service Request Case
- Systems Management Server 2003 : Server Modifications After Installation
- Systems Management Server 2003 : Modifying the Installation
- Creating a SharePoint Form with InfoPath Designer : Create a Form Library from InfoPath & Design a SharePoint Form Using the SharePoint Form Library Template
- Creating a SharePoint Form with InfoPath Designer : Publish Your Form & Use Your Form in SharePoint
- Microsoft Dynamics AX 2009 : Code Access Security
- Microsoft Dynamics AX 2009 : Classes and Interfaces
- Determining Exchange Server 2007 Placement
- Understanding AD Design Concepts for Exchange Server 2007
- Configuration Manager 2007 Overview : What is New in ConfigMgr 2007
- Configuration Manager 2007 Overview : Key Concepts
- Active Directory Domain Services on Server Core (part 2)
- Active Directory Domain Services on Server Core (part 1)
- Microsoft Dynamics GP 2010 : Improving information returned with SmartList Search
 
 
Most View
 
- Windows 8 : Sharing Settings (part 1) - To access sharing settings
- Windows Server 2012 : Deploying Dynamic Access Control (part 1) - Preparing Claims
- Windows 8 : Sharing files and folders (part 2) - Enabling folder sharing using the Windows 8 interface, Enabling folder sharing using the traditional interface
- Microsoft Word 2010 : Creating an Index (part 1) - Adding an Index to a Document - Marking an Index Entry
- Microsoft Project 2010 : Maintaining Baselines (part 2) - Rolling-Wave Planning with Baselines
- The Windows 8 Apps (part 3) - Mail, Maps
- Windows Server 2008 : Using netdom (part 3) - Querying and Resetting Secure Channels with netdom
- Upgrading to Sharepoint 2013 : Upgrading Content (part 3) - Fixing the Issues, Additional Parameters
- Installing Exchange Server 2010 : Command-Line Setup (part 1) - Command-Line Installation Options
- Windows 8 : Working with file systems (part 4) - Understanding Encrypting File System, BitLocker
 
 
Top 10
 
- Microsoft PowerPoint 2010 : Working with Charts - Modifying and Formatting Charts (part 3) - Formatting Charts
- Microsoft PowerPoint 2010 : Working with Charts - Modifying and Formatting Charts (part 2) - Modifying Your Chart’s Layout
- Microsoft PowerPoint 2010 : Working with Charts - Modifying and Formatting Charts (part 1) - Modifying Chart Design
- Microsoft PowerPoint 2010 : Working with Charts - Inserting a Chart from Excel
- Microsoft PowerPoint 2010 : Working with Charts - Inserting Charts
- Microsoft PowerPoint 2010 : Working with Charts - Understanding Charts
- Sharepoint 2010 : Windows PowerShell Remoting (part 2) - Entering a Remote Session, Running SharePoint 2010 Cmdlets Remotely
- Sharepoint 2010 : Windows PowerShell Remoting (part 1)
- Sharepoint 2010 : Windows PowerShell Scripts (part 3) - Writing Comment-Based Help Topics in Scripts,Using Functions in Scripts , Customizing Windows PowerShell with Profile Scripts
- Sharepoint 2010 : Windows PowerShell Scripts (part 2) - Executing Scripts, Using Parameters in Scripts