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
 
- Exchange Server 2013 : Defining a Highly Available Messaging Solution - Defining Terms for Availability
- Sharepoint 2013 : Welcome to the Central Administration Web Site (part 2) - System Settings, Monitoring
- Installing Exchange 2013 : Deploying an Exchange 2013 server (part 1) - Running Setup
- Microsoft Lync Server 2013 Edge Server : Edge Server Installation (part 2) - Edit the Topology, Deploying a Single Edge Server Pool
- Sharepoint 2013 : Installing and Configuring Windows Azure Workflow Server (part 3) - Testing and Verifying the Workflow Installation
- Windows Phone 7 to Windows Phone 8 : App publication (part 4) - Updates
- Microsoft Lync Server 2013 Edge Server : Edge Server Troubleshooting (part 2) - DNS Records
- Windows 8 : Creating a Windows Network - Installing a Wireless Network (part 3) - Getting Maximum Wireless Speed
- Microsoft Lync Server 2013 : Lync Online and Hybrid Deployments - AD FS Deployment for SSO (part 3) - Adding or Converting a Domain for SSO
- Windows Phone 8 : Walking Through the Bookshop Sample Application (part 1)
 
 
Top 10
 
- Microsoft Project 2010 : Setting Up Project for Your Use - Defining Project Information (part 2) - Defining Project Properties
- Microsoft Project 2010 : Setting Up Project for Your Use - Defining Project Information (part 1) - Understanding the Project Information Dialog Box
- Microsoft Project 2010 : Setting Up Project for Your Use - Setting the Task Mode
- Securing an Exchange Server 2007 Environment : Securing Outlook Web Access
- Securing an Exchange Server 2007 Environment : Protecting Against Spam (part 2) - Filtering Junk Mail
- Securing an Exchange Server 2007 Environment : Protecting Against Spam (part 2) - Filtering Junk Mail
- Securing an Exchange Server 2007 Environment : Protecting Against Spam (part 1) - Protecting Against Web Beaconing
- Securing an Exchange Server 2007 Environment : Securing Outlook 2007 (part 2) - Encrypting Communications Between Outlook and Exchange , Blocking Attachments
- Securing an Exchange Server 2007 Environment : Securing Outlook 2007 (part 1) - Outlook Anywhere
- Securing an Exchange Server 2007 Environment : Securing Your Windows Environment (part 3) - Keeping Up with Security Patches and Updates