Dynamics GP Users: the creation of login failed for unknown reason. Contact your SQL Server Administrator for assistance.

 

One of my community fellows has reported a challenging case this evening, he been trying to add a user to Dynamics GP and unable to succeed with this operation, and the obvious cause for this message was that the user could be already added to your database and not added to your GP nor your SQL level logins but wasn’t the case, the message is showing on any name you selects and while running under the “sa” user.

When you create the user at the SQL level it creates with no issues, you only have a problem while creating the user from Dynamics GP, therefore I tried a fresh copy of Dynamics GP and tried to create users with no luck, been sure that the “sa” is a system administrator on the SQL level and the “sa” is the owner of the DYNAMICS and other companies databases.

Digging deeply into this I ran SQL profiler trace to see what’s going on and realized that everything is working as desired, I tried to create the user using the CREATE LOGIN command and it  creates the user perfectly! But noticed upon creating the user by using the command that the returned message wasn’t “Command Completed Successfully” it was “Mail Queued”, where I looked further into this and realized that the customer was having a DDL Trigger on the server level that tracks the changes on the Logins and sends an email to the Administrators informing them about this change following the best practices! And this was the real cause behind the issue, it seems that GP wasn’t receiving the expected result from adding this user and been generating unknown error, disabling the trigger got this issue to be fixed!

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

Msg 515, Level 16, State 2, Procedure aagCreateGLWorkSLRealTimePostForApply, Line 82 Cannot insert the value NULL into column 'GLPOSTDT', table 'AFDCO.dbo.AAG10000'; column does not allow nulls. INSERT fails.

This morning I an issue reported from one of my customers, they are getting the below message when they try to apply multi-currency transactions:

I went through a long investigation process, after few hours it turned to be orphaned records in GL100001 with JRNENTRY = 0!

Deleting these record fixed the problem! 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

Inventory not changing account to the correct site account for all transactions

A wired case was reported this morning, our customer is having several inventory accounts one for each warehouse, they wanted the system to change the account upon changing the site, which is covered in the default Dynamics GP functionality, the setup for this is explained in the following article:

https://community.dynamics.com/gp/f/32/t/157821

The customer was having the correct setup, but the system wasn’t changing the account, which is normally occurs if the target account doesn’t exist, after checking I realized that accounts were there, but the system is also not flipping the accounts.

After further investigations it turned to be missing accounts in GL00105, accounts were exist in GL00100 but not in GL00105, I ran check links for financials and everything worked as expected!

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

Dynamics GP Notes for Arabic Characters

I been away from community for the last few months, been engaged in several projects and in learning Dynamics AX following the treand!

Back to track, I installed back the “Open Live Writer” as the “Windows Live Writer” is not supporting blogger! And blogging now about issues I seen worth to be posted.

In this article I am covering an old issue that comes with Dynamics GP, whenever you type Arabic to Dynamics GP notes you realize the paid behind this which leaves users using NOTEPAD to type and then paste it back to GP.

I have created an small AddOn that fixes this for users and I am sharing this over the community, you just email me to send you the package, the tool is just allowing you to write your text inside a user-friendly textbox and whenever you are done it copies back your text to the original note:

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