As promised, Microsoft has released Dynamics GP 2015 on time! 120+ enhancements were introduced, see below the first look into the product:
Before you plan your upgrade, keep in mind that SQL 2008 is no longer supported, you must upgrade at least to SQL 2012 or later.
1. Icons has been Changed!
2. Login Page has been changed!
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
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.
A couple of days back I seen a “conspiracy” being prepared between GP MVPs (including me!) against the Analytical Accounting pushing hard to get the MDA module back to track and enhanced to compete the AA module.
Frank has created the Connect request and we all voted to get this done, we need your help getting this ranked to the top of the list and to be considered in the very near release:
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo
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:
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.
Then logged in but selected “SQL Authentication” option from the login page:
The result was as expected, the logged in user was “TEST1”!
Now it been clear, all windows authentication users will be using one account to access the SQL, the login is the one you specified during the installation of the web client, so if you been counting on the user who is currently logged in in your customizations you might need to review your code!
Hope that helps giving you a good understanding to the new security process.
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo
During the upgrade process to Dynamics GP 2013 R2 with one of my customers we got the error in the subject, the issue is with dropping one of the SQL level Assemblies called “System.DirectoryServices” that been used by “Microsoft.Dynamics.GP.WorkflowGP.WorkflowEngine”.
The "System.DirectoryServices" assembly is being used by the Workflow module in Dynamics GP, if you have workflow installed you will not be able to drop this reference as you will be having another assembly depending on this and the other assembly is being used by 7 functions and stored procedures.
This assembly basically is used to connect your active directory and get the needed details that are being used by the system, dropping all these objects is safe as the upgrade process will automatically create them back for you.
To resolve the issue, first find the following functions and stored procedures, right click them one by one and hit drop:
Go to DYNAMICS database and navigate “Programmability>> Assemblies” and find “Microsoft.Dynamics.GP.WorkflowGP.WorkflowEngine”, right click the assembly and hit drop and then drop “System.DirectoryServices”:
Reinitiate Dynamics GP Utilities and and the upgrade will proceed safely, don’t worry about the deleted objects as the upgrade will recreate them all.
Hope that this helps.
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo
I liked the new active directory utilization for GP 2013 R2! take a look how does it look like now:
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo
Recently I had an interesting project with one of my customers, they had the following environment:
Server I:
Server II:
The customer simply wanted to upgrade to Dynamics GP 2013 SP2 and to SQL 2012, and also wanted to consolidate the databases into one single DYNAMIMCS database.
Challenges:
Now we have few challenges detailed below:
Resolutions:
Well we believe that nothing is impossible in the IT field, we have planned for everything and scheduled the upgrade process, below the steps we followed:
Server I:
This operation took the first weekend!
Server II:
This operation took the second weekend! Till now everything is working properly and this is how their GP looks like right now:
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo
I just upgraded to GP2013 R2! I liked the way the changed the “Login” form, this to apply the identity management process!
Next thing I liked is the new look and feel:
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo
Few days back I got mails from many customers reporting that the exchange rates feed stopped working due to an error with the host, the tool was linked to a free exchange rates provider source and therefore it is unsupported.
Yesterday Mark Polino gave me a great idea to pull sources from YAHOO or GOOGLE and ignore the source we are using, and due to the large base of customers currently using this product I have redeveloped the product to count on more reliable source by readying from YAHOO which I believe will not go down for long time!
YAHOO API provides the rates over a methodology that does not work with the product, therefore I had to “find/amend” a web-service that reads from YAHOO and send results back to the application and the web-service is currently hosted at our web host, I know that the host is not reliable as YAHOO but at least we can get rid of issues we used to face and minimize the downtime as it became controllable.
To get the updated package, please drop me a mail and I will send it immediately!
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo
I got a very interesting case few months back, one of my customers implemented the Management Reporter and tried to implement their existing reports, it went well but for the reports that uses the Analytical Accounting Budgets that has filters over specific dimensions, budget amounts were not pulled at all.
At that time I tried very hard to resolve the issue with no luck, and therefore I had to install the FRx and work out the reports there till getting this resolved by Microsoft.
During the last days I have noticed many articles by Microsoft that they has identified the case and fixed this issue with the product updates, therefore this morning I decided to install Management Reporter 2012 with the final update to see if the issue was resolved, I created a dummy report and tested the case with no luck! Same issue is still there while I couldn’t replicate the same issue on a clean database.
After many researches I have seen a question answered in the community and located here, it is the same issue I am currently investigating, and the provided cause of issue is the gap in serials for “Analytical Accounting Transaction Dimension IDs”, simply the data inside AAG00400 table should look like the below:
What if I been having one of the dimensions coded as “15” instead of “7” as the case I had? The proposed solution was to create dummy dimensions to cover the gap between 9 and 15 which is doable and safe solution.
The problem is what if I had one of the dimensions coded as “700”! I am sure that there is no was to create 684 dummy dimensions to cover the gap where I had to reindex the whole database.
The operation I followed is very risky and requires a real expert in the SQL, below steps I used to fix my issue:
1. I searched for the tables that I need to affect, simply these are all the tables that has “aaTrxDimID” column, went to the SQL and wrote the following query:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE Column_Name = 'aaTrxDimID' AND COLUMN_DEFAULT IS NOT NULL
2. I didn’t take a backup of the database but you must take a full backup!
3. I took a backup for the tables that I need to update by running the following query:
| SELECT * INTO BAK_AAG00401 FROM AAG00401 |
| SELECT * INTO BAK_AAG00901 FROM AAG00901 |
| SELECT * INTO BAK_AAG01001 FROM AAG01001 |
| SELECT * INTO BAK_AAG01002 FROM AAG01002 |
| SELECT * INTO BAK_AAG02000 FROM AAG02000 |
| SELECT * INTO BAK_AAG02001 FROM AAG02001 |
| SELECT * INTO BAK_AAG40003BAK FROM AAG40003BAK |
| SELECT * INTO BAK_AAG30003BAK FROM AAG30003BAK |
| SELECT * INTO BAK_AAG04001 FROM AAG04001 |
| SELECT * INTO BAK_AAG20003 FROM AAG20003 |
| SELECT * INTO BAK_AAG10003 FROM AAG10003 |
| SELECT * INTO BAK_AAG00202 FROM AAG00202 |
| SELECT * INTO BAK_AAG30003 FROM AAG30003 |
| SELECT * INTO BAK_AAG00312 FROM AAG00312 |
| SELECT * INTO BAK_AAG00400 FROM AAG00400 |
| SELECT * INTO BAK_AAG00316 FROM AAG00316 |
| SELECT * INTO BAK_AAG00801 FROM AAG00801 |
| SELECT * INTO BAK_AAG40003 FROM AAG40003 |
| SELECT * INTO BAK_AAG00402 FROM AAG00402 |
| SELECT * INTO BAK_AAG00403 FROM AAG00403 |
| SELECT * INTO BAK_AAG00404 FROM AAG00404 |
| SELECT * INTO BAK_AAG00405 FROM AAG00405 |
| SELECT * INTO BAK_AAG00406 FROM AAG00406 |
| SELECT * INTO BAK_AAG00407 FROM AAG00407 |
4. I have identified what are the existing IDs and what it should be and ran the following set of commands for each record:
| UPDATE AAG00401 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG00901 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG01001 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG01002 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG02000 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG02001 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG40003BAK SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG30003BAK SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG04001 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG20003 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG10003 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG00202 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG30003 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG00312 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG00400 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG00316 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG00801 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG40003 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG00402 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG00403 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG00404 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG00405 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG00406 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
| UPDATE AAG00407 SET aaTrxDimID = 3 WHERE aaTrxDimID = 47 |
Viola! The budgets are now generating data and everything looks fine for the time being, I will keep you posted with any other issues that might occur due to this operation.
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo
As many of you might notice, upon exporting huge number of records from Smart List (specifically more than 32,767 records) Smart List generates an error, this is actually a bug in GP 2013 which reflect the maximum number the integer can handle.
The good thing is that this was resolved in the newly released SP 2:
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo
It has been finally released, Business Portal 6.0 for Dynamics GP 2013, it still does not support SharePoint 2013 but it has many enhancements could be found HERE.
Business Portal 6.0 is supported with the following: Click HERE to go to the System Requirements Page.
*NOTE:* SharePoint 2010 is currently not supported on Windows Server 2012 until the release of SharePoint 2010 Service Pack 2 due out this summer.
Below is the direct download link:
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo
Yes it has been released, Microsoft team is doing everything fast in relation to GP 2013! take a look into the following article:
http://blogs.msdn.com/b/gp/archive/2013/01/15/where-s-the-demo-image-here-today.aspx
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo
Customers who are running Business Portal cannot upgrade to GP 2013 till march as the Business Portal has not yet released, take a look into the announcement from Inside Microsoft Dynamics GP Blog:
http://blogs.msdn.com/b/gp/archive/2013/01/08/microsoft-dynamics-gp-2013-business-portal-update.aspx
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo
One of my customers has requested to prints barcodes for his assets, and therefore I have created this simple methodology, take a look into the steps below:
Go to the Asset General Information form (Cards >> Fixed Assets >> General), and note the Additional menu on the form:
The system will prompt you to select the printer:
Barcode will be printed!
To get this please go and download the following ZIP file:
http://di.jo/files/Asset Label Printing.zip
It has two files:
NOTE: we have added a little DI.JO inside the barcode, just e-mail me to send you a package without this, it was added to count the number of users!
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo
I got a request from one of my customers, they had a need to auto assign newly created AA codes to all users and that how the idea started, I saw the scripts created by Sivakumar earlier to auto assign all codes to all users and used his cross join to create the below trigger.
The trigger is simply works on AAG00401 table upon record insert, it assigns the newly created codes to all GP users automatically, just run below script over your company database and enjoy.
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo
-- =============================================
-- Author : Mohammad R. Daoud
-- Create date: 09:56 AM 07/12/2012
-- Description: This trigger as created to auto assign
-- newly created analytical accounting codes to all users.
-- =============================================
CREATE TRIGGER DI_AutoAssignSecurity
ON AAG00401
FOR INSERT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for trigger here
DECLARE @aaTrxDimID INT
DECLARE @aaTrxDimCodeID INT
SELECT TOP 1 @aaTrxDimID = aaTrxDimID, @aaTrxDimCodeID = aaTrxDimCodeID FROM INSERTED
DELETE FROM AAG02000 WHERE aaTrxDimID = @aaTrxDimID AND AAG02000.aaTrxDimCodeID = @aaTrxDimCodeID
INSERT INTO AAG02000 (USERID, aaTrxDimID, aaTrxDimCodeID, aaDistribute, aaAdjust) (SELECT B.USERID, A.aaTrxDimID, A.aaTrxDimCodeID, 1, 1 FROM AAG00401 A CROSS JOIN DYNAMICS..SY01400 B WHERE A.aaTrxDimID = @aaTrxDimID AND A.aaTrxDimCodeID = @aaTrxDimCodeID)
END
GO
David Musgrave has made it again, he has provided a way to resize the treeview of the smart list using a splitter control, take a look into his article below:
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo
It has been announced now that the release date for Microsoft Dynamics GP 2013 is 19-12-2013, take a look into the following post:
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo
Microsoft Dynamics GP 2013 Beta Version has been released, go ahead a download your test version from the link below, while I am so excited to install and test, but I will be pushing myslef to publish my findings next week as I am going to relax this weekend!
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo
Many of us support customers remotely to save time and avoid any unnecessary costs, some customers can afford a remote connection with high technology to make the helpdesk support engineer life easier, however others are not!
To workaround this we used to use http://www.TeamViewer.com before, but after realizing the cost of the product that is around 800$ we have switched to http://www.AMMYY.com, it is a simple remote desktop sharing application that works perfectly without the need to perform any complicated installations and cost is affordable (around 30$!).
We do support our own accounting department who are in the same building but different floor remotely!
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo
Following to the requests we are getting from many users, we have added the below functionalities the the product:
Move rows up and down
You can now add your rows and then use arrows to move your record up and down:
Direct Grid Modifications
You can now perform modifications to the product by modifying the grid directly and then click on “Save Grid Modifications” so if you missed up with Excel Column Index for example you can simple readjust the sequence and save:
Download Templates
Few days back we have released the ability to paste the setup directly to the tool, but found this a little bit hard for end users to copy tasks one by one, therefore we have added a new functionality to download templates from the internet directly to your database:
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo
