Author Archive

Exchange Rates Feed

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

Continue Reading:
Exchange Rates Feed

January 29, 2014 ·  · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 132

Maps Reporting using SSRS

One of the challenges that I been trying to achieve is having my reports graphically designed to show data on “Maps” and that always been the toughest part customers might request.

Few days back I been researching with my colleagues on how the “Sales By States” KPI works in Dynamics GP that dynamically pulls the sales of each state on the US map and discovered the “Map” feature in SSRS!

We have been able to download the “.shp” file for Jordan map from one of the online free GIS providers and integrated this will SSRS, and then created the following report in SSRS in few minutes, saved this report in SSRS and been able to print this report from GP business analyzer:

image

This article is just to show that this is doable for users to give it a try.

Happy reporting!


Regards,


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

Read this article:
Maps Reporting using SSRS

November 25, 2013 ·  · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 145

Cards Auto Numbering for Vendors, Customers and Items – Free Addon

We at Dynamics Innovations has developed a product for Dynamics GP allows end users to control the generation of the ID for customers, vendors and items, the tool is free and  available for use immediately, just drop me a mail and I will be sending the tool for you, once you get the DLL, please follow steps below to activate the product:

1. Copy sent DLL to GPAddIns Folder.

2. Login first time with “sa” user to generate the needed database objects.

3. Open SQL and adjust the parameters to fit your needs:

a. You need to find a table called “DI_NextNumbers”, open the table.

b. Fill the prefix you need to use, length that includes the prefix, next number you wish to use.

Go to vendor card for testing and find the additional menu, same package works for customers and items if you wish to activate:

clip_image002


Regards,


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

Link:
Cards Auto Numbering for Vendors, Customers and Items – Free Addon

October 24, 2013 ·  · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 188

Analytical Accounting Budgets not Pulled on Management Reporter while filters is enabled.

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:

image

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

View article:
Analytical Accounting Budgets not Pulled on Management Reporter while filters is enabled.

October 23, 2013 ·  · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 237

Microsoft Dynamics GP 2013 Financial Management

This morning I enjoyed reading a book by Ian Grieve discussing Dynamics GP Financials – Related modules, it contains all the information needed to to cover your financial needs using Microsoft Dynamics GP, it starts with Analytical Accounting module, moving to Cashflow Management, Budgeting and finally PO Commitment and Encumbrance Management.

For those who would like to learn more about the mentioned modules, I would recommend purchasing and reading this book from the below link, it worth every buck!

http://bit.ly/16n4oO2


Regards,


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

Visit site:
Microsoft Dynamics GP 2013 Financial Management

October 18, 2013 ·  · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 152

Moving from Dynamics GP to another ERP?

Are you looking to move from GP to another ERP like AX for example? I would extremely encourage you to read the following article by Martin in the eOne blog, the guy is collecting too many useful reasons to think twice before making this change, take a look into his article below:

http://eonesolutions.blogspot.com/2013/06/we-switched-from-gp-to.html


Regards,


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

View post:
Moving from Dynamics GP to another ERP?

September 1, 2013 ·  · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 169

GP 2013 – Smart List Crash when it reach 32,767 Records for Export

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:

image


Regards,


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

Read More:
GP 2013 – Smart List Crash when it reach 32,767 Records for Export

September 1, 2013 ·  · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 218