Dynamic Future – Vote: Resize the Left Pane on Smartlist


Mark highlights the Smartlist Left Pane curse (what else do you say if you see half of your screen is occupied by the Smartlist Favorites tree view and only half being allotted for results?) and a suggestion that was made by Sivakumar V.

The Connect suggestion post can be seen here: GP Smartlist Window Splitter to be made resizable.

But when I see this suggestion, it says Resolved:

So that means, is it going to be available on next release? Or on GP2013?

Nevertheless, visit the portal and vote for it.

VAIDY

Top Smartlist Builder Question – “Can I do a Multi-company Summary Smartlist?”


Collins Dynamics GP Blog tells us about the Top Smartlist Builder Question, which is Can I do a Multi-Company Summary Smartlist?

The answer is a very positive YES.

It’s basically a simple and easy-to-understand feature. This feature is quite important for all clients with multiple companies on a single GP environment.

Pay a visit their post and you will know how exactly to use this feature.

VAIDY

Smartlist Favorite Visibility


Most of the queries that I am receiving from my users regarding Smartlist is like below:

1. Why my Smartlist Favorite is being shown to all?
2. I created a Smartlist Favorite in one company. It is not showing up in other company. Why?

Answer is quite simple and straightforward. They had not selected an appropriate *Visible To* option.

Smartlist favorites can be created with either one of available four different visibility options.

1. System
2. Company
3. User Class
4. User ID

Shown below is how it looks like:

1. System: Visible to all users across all companies.
2. Company: Visible to all users, but visible only on that particular company.
3. User Class: Visible to all users under the user class in which the user who creates this favorite is, but visible across all companies.
4. User ID: Visible only to this user, but across all companies.

Related PostChanging a smartlist favorite’s visibility thru’ SQL

VAIDY

Resizing left pane in Smartlist – Frank Hamelly


Frank, thank you very much for getting this from Microsoft Team. We all are grateful, as I know the pain in scrolling horizontally for each Smartlist item.

Alright, for all GP users and consultants out there. You all better download this from Frank’s site. This is going to be most likable thing.

Here it is: Resize the left pane in Smartlist.

VAIDY

Changing a Smartlist Favorite’s visibility thru’ SQL


Warning: Method shared in this post is NOT supported or advised by Microsoft team. This article explains a SQL method and therefore the intended audience is a GP and SQL Consultant / Developer / Administrator.

Couple of Smartlist Favorites created by an end user, but created it with a wrong visibility: Visible by User ID. What this user should have selected is: Visible by System. Since these favorites are suppose to be accessed by all Users across all Companies.

This end user is currently out and even as SA I could not access the Smartlist Favorites. Easiest and direct approach is to reset this user’s password, modify the smartlist favorite and notify him of the new password. Once this user is back, he/she would change the password.

But, is there any other simplest method for someone like me? A GP & SQL Administrator? Of course, I do.

I can modify a Smartlist Favorite using a simple SQL UPDATE statement, targeting the Smartlist Favorite tables ASIEXP81 and ASIEXP86. Display Name for these tables are Smartlist Favorite Master and Smartlist Favorite Columns Master respectively. Both tables are in DYNAMICS database.

Below are SQL statements that I used to change the visibility:

UPDATE DYNAMICS..ASIEXP81 SET ASI_Favorite_Save_Level = 1, USERID = ”, CMPANYID = 0 WHERE ASI_Favorite_Name = [Favorite_Name_Given_By_That_End_User]

UPDATE DYNAMICS..ASIEXP86 SET ASI_Favorite_Save_Level = 1, USERID = ”, CMPANYID = 0 WHERE ASI_Favorite_Name = [Favorite_Name_Given_By_That_End_User]

In above statements, field ASI_Favorite_Save_Level is the Visibility Type that we set up when we create a Smartlist. Value 1 denotes the first option in that Drop Down, which is SYSTEM. Since I have to set visibility to all users across all companies, all I have to do is to set USERID as an Empty String and Company ID as ZERO.

This will change a particular Smartlist Favorite’s visibility as required.

Simple, isn’t it?

VAIDY

Smartlist Builder View Returning Nothing – David Musgrave


David explains why Smartlist Builder View may not return records and on which scenario.

Check out his post here: SmartList Builder based on SQL View not returning Data.

VAIDY

View Smartlists with SQL Tables


Have you ever wondered why your Smartlist, created using Smartlist Builder and a SQL Table / View (which is not part of any of GP or 3rd Party Products)?
This may be the issue:
The above screenshot shows Security Task form, where you have to select the option “View SmartLists with SQL Tables” for the users who wants access to this Smartlist.
This particular point is very much covered in Smartlist Manual, but I bet most of us would have overlooked this.
VAIDY