Skip to main content

Notifications

Announcements

No record found.

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
SmartList-Add-or-Remove-Favorites-showing-Password-to-add.JPG
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.

modified-smartlist.jpg
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.
delete-smartlist.jpg

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

The following screenshot will display this column.
asiexp81.jpg

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

Comments

*This post is locked for comments

  • Community Member Profile Picture Community Member Microsoft Employee
    Posted at

    More detailed information on  Microsoft Dynamics GP 2018 SmartList Favorites with unique password protection

  • Community Member Profile Picture Community Member Microsoft Employee
    Posted at

    More detailed information on  Microsoft Dynamics GP 2018 SmartList Favorites with unique password protection from the GP team.

    The post Microsoft Dynamics GP 2018 SmartList Favorites with unique password protection. appeared first on DynamicAccounting