Friday, December 17, 2010

I found a question in the Dynamics Forum about this subject and answered Mariano Gomez, Mariano detailed all the steps required to fix this up, follow Mariano steps in this article if you found an issue about this subject.

Have you ever restored a database from your backup and wanted an easy way to get users automatically created? script below will do this task for you:

DECLARE @USER varchar(500) DECLARE @SID varchar(500)

DECLARE CURR CURSOR FOR SELECT NAME, SID FROM sysusers WHERE issqluser = 1 and (sid is not null and sid <> 0x0) and suser_sname(sid) is null ORDER BY name OPEN CURR FETCH NEXT FROM CURR INTO @USER, @SID WHILE @@FETCH_STATUS = 0 BEGIN EXEC sp_change_users_login 'Auto_Fix', @USER, @SID , @SID FETCH NEXT FROM CURR INTO @USER, @SID END CLOSE CURR DEALLOCATE CURR

Above script will read all database level defined users and locate it corresponding users in SQL, if it found the script will map existing user to SQL user, otherwise it will add a new user with a new password and map both users.

Next step required is to change the user password at the application level “Dynamics GP” so it encrypts the user password again and fulfill business requirements.

If you have updated to GP 10.0 SP 5 or GP 2010 SP1 you might already notice the slow performance during login, this is mainly related to the newly added “Dynamics Online Services” dictionary that adds records in the menu table with removing old ones as detailed in this article for David Musgrave and this article for Vaidy Mohan, the temporary solution for this is deleting the records in the menu table that's related to this dictionary.

To avoid the manual deletion of the records in this table, you will need to create an SQL job that automatically deletes unwanted records from this table, follow steps below to start:

Friday, December 3, 2010

Have you ever wanted to apply your vendors transactions automatically without having to move between all your vendors? I been in a situation with a new client that works on Dynamics GP since 2001 and they never applied their vendors payments to their invoices.

Working on this manually is a real nightmare and the user will keep working on this for ever before being able to finalize, therefore I have wrote script below that generates Macro to set this up, follow steps below to get the macro: