Microsoft Dynamics GP 2018 SmartList Favorites with unique password protection.

Hello Community!

Is it just me or are you sick and tired of people deleting or modifying your SmartList? Well no more worries! In GP 2018 we added this fantastic feature where you can have a unique password per SmartList to prevent any modifications.

Keep reading to find out more information on this feature.

When in the Add or Remove Favorites window you will now notice there is a password section.
To open the Add or Remove Favorites window: on the Microsoft Dynamics GP menu, point to SmartList, select SmartList, and click Favorites

Once you have entered a Password to a SmartList, when making any modifications to it, Microsoft Dynamics GP will prompt you to enter the SmartList Favorite password.

Once you have entered a Password to a SmartList, if you need to remove the SmartList, Microsoft Dynamics GP will prompt you to enter the SmartList Favorite password.

We made a modification to the ASIEXP81 table to add column SmartListFavPassword.

The following screenshot will display this column.

Note: While the column SmartListFavPassword was added to the ASIEXP81 table, the contents of this column are encrypted and cannot be viewed from a SQL query.

With this noted, if the SmartList Favorite password is lost there is not a way within the Microsoft Dynamics GP application to reset the password. You will need to either create a new SmartList Favorite in its place or update the SmartListFavPassword column in the ASIEXP81 table via SQL using an UPDATE SQL statement.

I hope the information offered has been proven to give you an understanding of this new feature.
Until next time,
Nicole Fiskum | Support Engineer | Microsoft Dynamics