Dynamics GP Excel Paste has been ranked in DynamicsWorld Microsoft Dynamics Top 50 Add-Ons 2013

I got the mail this morning that the Dynamics GP Excel Paste has made it and ranked in the 2013 list of DynamicsWorld Microsoft Dynamics Top 50 Add-Ons.

Quoting from DynamicsWorld:

In previous years each platform has had its own Top 12, however, with an increasing number of ISVs now creating cross platform Add-Ons this year it was necessary to publish the top Add-Ons for Microsoft Dynamics as a single list of the Top 50.

The issue of what makes the best Add-On for an end user is dependent upon what the end user requires, so, as in previous years the list does not rank the Add-Ons in order of choice, instead, the list is published in Alphabetical order.

So GP Excel Paste might be the best! No body knows!!

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Printing Barcodes for Fixed Assets

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:

• “IDAutomationHC39M.ttf”: place this file inside “C:\Windows\Fonts”
• “Asset Label Printing.dll”: Place this file inside your Dynamics GP Folder >> AddIns

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

Analytical Account Posting Setup - Breaking the Hidden Secrets!!

Yesterday one of my customers reported an issue that the analytical accounting report is not being printed after the “General Posting Journal” upon posting a GL Transaction.

First thing came to my mind that this report has been unmarked in “Posting Setup” then in moment I realized that the Posting Setup does not contains anything for AA!!

It has been said in the analytical accounting installation manual that YOU MUST CONFIGURE YOU POSTING SETUP BEFORE ACTIVATING THE PRODUCT:

Setting up posting options for Analytical Accounting
Once you’ve installed Analytical Accounting for your company, you must set up
the appropriate posting options for Analytical Accounting in the Microsoft
Dynamics GP Posting Setup window. Be sure that you’ve completed this task before
you activate Analytical Accounting.

In order to collect analytical information for an account, the account must be linked
to an account class. Analytical Accounting does not support posting in summary.

So how to adjust this? Where can I find the posting setup for AA and how to configure my reports?

An hour of profiler trace returned what does GP actually do to load report, specially after activating the “Allow Transactions Posting” option and getting the error below on the report generation:

“Unable to obtain posting destination record.”

I my trace, I noticed that GP is running the following query to get report printed to the appropriate destination:

exec TWO.dbo.zDP_SY02200SS_1 2,'General Entry','General Posting Journal'

This script returned the following results:

Then I saw the following command which returned the following result:

exec TWO.dbo.zDP_SY02200SS_1 2,'General Entry','3180rpt_8'

At this moment I realized that this “3180rpt_8” report is being called without being exist in posting setup table and that’s why I used to get the above message and being able to get the report printed.

Resolution:

I just added the report row into SY02200 table and rerun the posting! That worked like a charm!

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Auto Assign Newly Added Analytical Accounting Code to All Users

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

Resizing SmartList TreeView and ListView panes using the Support Debugging Tool

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:

http://blogs.msdn.com/b/developingfordynamicsgp/archive/2012/12/05/update-resizing-smartlist-treeview-and-listview-panes-using-the-support-debugging-tool.aspx

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Dynamics GP 2013 Release Date

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:

http://msdynamicsworld.com/story/microsoft-dynamics-gp-2013-has-release-date-december-19?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+msdynamicsworld/news+%28Microsoft+Dynamics+News%29&utm_content=Google+Reader

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Error Saving Cashbook Management Transaction

This morning I been working on a wired case with Cashbook Management Module, the case was many error messages shown up upon saving the payment line:

First error was:

An error occurred executing SQL statements.

Then: GPS Error: 58

Then: SQL Error: 8114 Microsoft SQL Server Native Client 10.0 SQL Server Error converting data type varchar to datetime.

Then: ODBC Error: 37000

I felt like I am guilty! And thought that everything will be missed up after clicking tons of OK’s, then I decided to move on and look for the reasons behind this miss.

Running SQL Profiler Trace identified the query that been causing this error below:

Finally I noticed that the time attached to the query is ‘12:00:00 ص’ instead of ‘12:00:00 AM’

I replaced Arabic character in my time format from Arabic to English and it worked like a charm!!!

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo