Author Archive:

rss feed

Update SQL Server Collation for a Clustered Installation

| 07/01/2013 | 0 Comments
Update SQL Server Collation for a Clustered Installation

I been in a situation with one of my clients where I been implementing and Active/Active clustering setup over SQL Server 2008 R2 as my customer is still using GP 10.0, after finalizing and testing everything I noticed that the code page I must use is 1256 while I have used 1250!!! Thanks god for having a utilities to update the collation without having to destroy the cluster! I have followed the steps below and it worked like a charm: 1. Backup your objects! As this process will drop logins, linked servers, jobs, and anything related to the instant itself plus will de-attach your database. 2.

Continue Reading

Business Portal 6.0 for Dynamics GP 2013

| 05/10/2013 | 0 Comments
Business Portal 6.0 for Dynamics GP 2013

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. SharePoint Server 2010 or SharePoint Foundation 2010 only.  Windows Server 2008 x64 SP2 or later or Windows Server 2008 R2 SP1 or later.  Internet Explorer 8.0, Internet Explorer 9.0, and Internet Explorer 10.0

Continue Reading

Duplicated GL Transactions between Work and Open tables

| 05/01/2013 | 0 Comments
Duplicated GL Transactions between Work and Open tables

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 GL10001 and compares the totals between both tables for each journal and generate the result, you can use this script to company these and make sure that all journals were successfully posted and none posted partially.

Continue Reading

Dynamics GP 2013 Upgrade–Customized GL Inquiry Report

| 04/23/2013 | 0 Comments
Dynamics GP 2013 Upgrade–Customized GL Inquiry Report

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 has a customized report for GL Transaction Entry Inquiry Report, the report didn’t work properly as the core table of the Report has been changed. This is the only thing I found so far, but I wanted to let you know that you might need to plan redoing the customizations of this report upon upgrading to GP 2013. Regards, — Mohammad R.

Continue Reading

Mask a Field in Dynamics GP

| 04/23/2013 | 0 Comments

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 Dashes “-“ for each 3 letters to look like this > > “AAA-AAA-AAA” so the user will fill only 9 “A”s and the system to automatically add the “-“ in between and below how I covered this: 1. Go to Cards> > Inventory> > Item 2

Continue Reading

The Top 100 Most Influential People in Microsoft Dynamics List for 2013

| 04/23/2013 | 0 Comments
The Top 100 Most Influential People in Microsoft Dynamics List for 2013

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-list-for-2013-page-10/ Talking about votes, I can see many names this year specially David Musgrave who is doing great for the time being, he owns 50% of the votes till now, he is on page 4: http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-4/ For me, I did vote for the following, these are the people I know and sorry if I missed anyone: http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-3/ Charles Allen, Christina Philips http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-4/ Erik P. Ernst, David Musgrave http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-5/ Gianmarco Salzano, Frank Hamelly http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-6/ Ian Stewart http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-7/ John Lowther, Jivtesh Singh, Jon Rivers http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-9/ My favorite list! Mark Polino, Leslie Vail and the GP King Mariano Gomez! Wish you luck guys in the same list. http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-11/ Nick Hoban, Pam Misialek http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-12/ Richard Whaley http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-13/ Steve Endow http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-14/ Tom Taylor, Victoria Yudin Regards, — Mohammad R.

Continue Reading

Excel Paste Tips

| 04/23/2013 | 0 Comments

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://www.msdyngp.com/GP/weekly-dynamic-excel-paste-tips/ Well 50% of the product downloads is from Mark Polino sessions! It was his idea initially and it is his product now! Worth to add that you need to make sure you have downloaded the correct version for your GP, this was added recently as we got many issues reported from users about incompatibility of frameworks and issues sometimes with missing DLLs: Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading