Mohammad R. Daoud

| |

Business Portal 6.0 for Dynamics GP 2013

Posted 1 month ago

by Daoudm

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...
Duplicated GL Transactions between Work and Open tables

Posted 1 month ago

by Daoudm

One of my customers got a case that Journals were not deleting from GL10000 upon posting, this caused the transactions to duplicate between open and work tables and been annoying end users. To fix this miss, I wrote a script that looks into GL10000 and...
Dynamics GP 2013 Upgrade–Customized GL Inquiry Report

Posted 1 month ago

by Daoudm

Guys, If you are planning to upgrade to GP 2013, please consider to analyze your customizations carefully as there might be some changes between the application versions, I been in a situation were we upgraded from GP 2010 R2 to GP 2010 and the customer...
Mask a Field in Dynamics GP

Posted 1 month ago

by Daoudm

I got an interesting question from one of the community followers and I saw that it should be published for community, the question was a request to have a special mask for the item number field, the user wanted to have the item number automatically has...
The Top 100 Most Influential People in Microsoft Dynamics List for 2013

Posted 1 month ago

by Daoudm

Well it is funny! First of all leave whatever you are doing and go to the following link then vote for me, we are running late and I didn’t publish about this before! http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics...
Excel Paste Tips

Posted 1 month ago

by Daoudm

Awesome idea created by Mark Polino, I am getting many mails daily concerning same questions and the answer every day is the same, Mark Polino used to get questions as well and he posted the following articles about some tips over the Excel Paste: http...
Purchase Order Commitment–Required Date from PO Required Date or Item Required Date?

Posted 1 month ago

by Daoudm

I got an interesting question from of my customers who are willing to activate the purchase order commitments, the question was the documentation stated the following: The Required Date must fall in a valid and open fiscal period . The purchase order...
Historical Stock Status Script

Posted 1 month ago

by Daoudm

We been suffering from Historical Stock Status report issues when it comes to customers with big inventory transactions, I am providing a script that recalculate the historical stock status for your items based on the IV10200 and IV10201 tables, it will...
Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013

Posted 1 month ago

by Daoudm

Today I will be charging my timesheet on Mark Polino account for publishing his book! He has released an awesome book that details how to make your management graceful in reading their figures using Dashboards, he has utilized the excel features to generate...
Dynamics GP 2013 MVP

Posted 2 months ago

by Daoudm

In April 1st I got a mail from Microsoft telling me that I got a new MVP for 2013! That was a great news to hear but wanted to postpone publishing the announcement before getting the below!
Installing SQL Failover Clustering Without SAN Storage – Windows 2008 R2

Posted 3 months ago

by Daoudm

It always been hard to test out the failover clustering as it requires SAN Storage device to be connected and requires many servers for testing. This morning I have seen an interesting article in the community the Microsoft has released “Microsoft iScsi...
LinkedIn

Posted 3 months ago

by Daoudm

As many of you might notice that Linked In is celebrating their 200,000,000 users and started sending thanks for people who help spreading their name! They have ranked their users per the the viewing of their profile, so you either be one of the top 1...
How to Track unused Journal Numbers

Posted 4 months ago

by Daoudm

I got an interesting question from one of the GP users requesting a list of unused Journal Number, therefore I decided to scratch my head and write this query, below will help: SELECT DISTINCT NUMBER FROM MASTER..spt_values WHERE NUMBER BETWEEN (SELECT...
Dynamics GP Excel Paste V 4.0

Posted 4 months ago

by Daoudm

We have finally released and uploaded a new version for the Excel Paste, this one has the following coverage: 1. The major move was the ability to integrate into multiple products, like combining the GL Transaction Entry with the Analytical Accounting...
Dynamics GP 2013 Demo Image

Posted 4 months ago

by Daoudm

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 -...
Developing Microsoft Dynamics GP Business Applications

Posted 5 months ago

by Daoudm

Do you want to learn everything related to Dynamics GP development? Dexterity, VBA, .NET, Extender and everything for just a 30$?!? I found these all in one book I reviewed written by Leslie Vail , it is Developing Microsoft Dynamics GP Business Applications...
Dynamics GP - Change a form field to “Required” field

Posted 5 months ago

by Daoudm

I got many requests from my customers on how to make this happens and I used to create a package and send it to the users for import. However with the new Licensing structure, everybody owns the modifier as a part of the starter pack! Therefore anyone...
Dynamics GP 2013 Business Portal

Posted 5 months ago

by Daoudm

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 Excel Paste has been ranked in DynamicsWorld Microsoft Dynamics Top 50 Add-Ons 2013

Posted 6 months ago

by Daoudm

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...
Printing Barcodes for Fixed Assets

Posted 6 months ago

by Daoudm

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...
Analytical Account Posting Setup - Breaking the Hidden Secrets!!

Posted 6 months ago

by Daoudm

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...
Auto Assign Newly Added Analytical Accounting Code to All Users

Posted 6 months ago

by Daoudm

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...
Resizing SmartList TreeView and ListView panes using the Support Debugging Tool

Posted 6 months ago

by Daoudm

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...
Dynamics GP 2013 Release Date

Posted 6 months ago

by Daoudm

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...
Error Saving Cashbook Management Transaction

Posted 6 months ago

by Daoudm

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 Dynamics GP

About Mohammad R. Daoud