Using SmartList to create your own version of an existing SmartList can give you more flexibility and allow you to quickly and easily find the exact data you seek within Dynamics GP. This gives you access to your data without needing to access SQL Management Studio.
First Step - Open a SmartList
Open a SmartList of your choice by clicking Microsoft Dynamics GP | SmartList. Expand the Module of your choice, expand the SmartList you want to see, and then click the asterisk to populate the default SmartList. In my example, I have expanded the Financial | Accounts SmartList.
Add a Typical Balance column
To do this, follow these steps:
Click the columns button and then click the add button.
In the Columns window that opens, click the dropdown next to Available Columns, and choose All Columns. This allows you to see all the columns that you could possibly add to this SmartList.
Scroll down and find Typical Balance, click it, and click OK.
In the Change Column Display window, you can highlight the newly added field and use the buttons on the right to move the field up or down.
Click OK, and you will now see the newly added column on your SmartList.
Search this SmartList by Posting Type and by Typical Balance
The steps to do this are:
- Click the Search button at the top of my SmartList.
- In Search Definition 1, click the lookup and select Posting Type.
- The Filter will default to ‘is equal to’ because there are only two possibilities.
- Choose Balance Sheet as the Value.
- In Search Definition 2, click the lookup and select Typical Balance.
- The Filter will default to ‘is equal to’ because there are only two possibilities.
- Choose Debit as the Value.
- Click OK, and now you will see the results of your search.
The final step to preserve all of the changes made to this SmartList, click the Favorites button, give your new SmartList a Name, and click the Add dropdown. This will allow you to either Add the Favorite or Add the Favorite with a Reminder. Your new SmartList Favorite will appear in the list on the left as shown:
|
More Posts By Mark Rockwell, Rockton Software
- GP Optimizer Summer 2019 Edition is now Available
- 7 Ways Distributors Drive Profits
- Dynamics Report Manager vs. Dynamics GP Reporting
- How to Party with the Right 3rd Party Solution
- New Release: GP Optimizer Summer 2018
Related Posts
- Increase equipment first-time fix rate and keep data secure with DynaRent PowerApps
- Data visualization for rental companies: What makes a visual interface easy to use?
- You need to know about the emerging trend: Transportation as a Service
- Demand forecasting: Find out how to do it the right way
- How DynaRent for Dynamics 365 can increase your business efficiency
