Tag: great plains
Wow – time flies and as they say, it seems to go faster the older you get. It seems only a few years ago that I was a graduating senior at NDSU. It was late in the last week of finals and I was working with my team to finish my senior project for one of my engineering classes before graduating (with a BS in Electrical Engineering with Computer option)
I am back from my leave this week and have been working through my backlog of emails and other tasks.
Got the good news yesterday that I was re-awarded as a Microsoft MVP for 2014, 4th year in a row. Congratulations! We are pleased to present you with the 2014 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share their high quality, real world expertise with others. We appreciate your outstanding contributions in Dynamics GP technical communities during the past year.
It seems our community is under spam attack! It is getting spammed by few LOVE Specialists! I would kindly ask for users who has outstanding questions to “repost” their questions once Microsoft folks resolves this attack! I feel like CAPTCHA will be added soon to the community to avoid such spammers and also to annoy users! Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 firstname.lastname@example.org http://www.di.jo
In earlier Dynamics GP versions, we used to use a module called MDA to manage our accounts dimensions and reduce the size of the chart of accounts, the module is very stable and works perfectly but with limited functionalities, when the Analytical Accounting was introduced, this module was retired and was no longer enhanced by Microsoft. Personally, I been fighting with Analytical Accounting issues for many years now, I can count free hours spent to correct journals at the database level that unjustifiably corrupted and was not linked to the correct figures, which makes it a little bit annoying.
This morning I been thinking about the new security structure for Dynamics GP web-client user who does not have SQL Users, and how these users will interact with SQL Server, I had to go through this as I have a client who’s running a very strict policy in granting SQL permissions for domain users. Getting through this, I have created few users with multiple scenarios as below: The first user linked to domain account called that “TEST1”, but didn’t check “Web Client user only (no SQL Server Account)” The second user linked to domain account called that “TEST2”, and checked the “Web Client user only (no SQL Server Account)” option. I have noticed that the first case created an “SQL User Account” called “TEST1” and didn’t granted the domain user any access to the database, and the second didn’t create any users which been a mystery to me understanding which user will be used to access the SQL Server! To test this I have modified the GL00100 table and added a new column called “UserName” –this is for testing only, you cannot do this on GP tables!- and set the default value for this column to be “SUSER_SNAME()” function which returns the user who’s currently logged in and started my testing by creating new accounts! Logged in by TEST1 to the web client and created a new account, the result was somehow wired, the user who was recorded was “DYNSA” Logged in by TEST2 to the web client and created a new account, the result was the same, the user who was recorded was “DYNSA” as well
A couple of weeks back I needed to consolidate two DYNAMICS databases and move companies from the first DYNAMICS to the second, this for sure requires Company IDs to be changed as it might be taken by another companies on the main DYNAMICS, to fix this once for all I have wrote the following script: DECLARE @Statement VARCHAR (8000) DECLARE @TABLENAME VARCHAR (500) DECLARE CURR Cursor FOR SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = ‘ CMPANYID ‘ AND COLUMN_DEFAULT IS NOT NULL OPEN CURR FETCH NEXT FROM CURR INTO @TABLENAME WHILE @@FETCH_STATUS = 0 BEGIN SET @Statement = ‘ SELECT * INTO ‘ + @TABLENAME + ‘ _BAK FROM ‘ + @TABLENAME EXEC (@Statement) SET @Statement = ‘ UPDATE ‘ + @TABLENAME + ‘ SET CMPANYID = NEW COMPANY ID WHERE CMPANYID = OLD COMPANY ID ‘ EXEC (@Statement) FETCH NEXT FROM CURR INTO @TABLENAME END CLOSE CURR DEALLOCATE CURR Hope that this helps. Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 email@example.com http://www.di.jo