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.

*NOTE:* SharePoint 2010 is currently not supported on Windows Server 2012 until the release of SharePoint 2010 Service Pack 2 due out this summer.

Below is the direct download link:

BusinessPortal60_RTM_x64.zip

---

Regards,

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

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.

Below the script code:

Historical Stock Sttus Summary

1. SELECT UNPOSTED.JRNENTRY, UNPOSTED.AMOUNT, POSTED.JRNENTRY, POSTED.AMOUNT FROM
2.     (SELECT JRNENTRY, SUM(CRDTAMNT) AS AMOUNT
3.     FROM GL20000 GROUP BY JRNENTRY) AS POSTED
4. INNER JOIN
5.     (SELECT GL10000.JRNENTRY, SUM(CRDTAMNT) AS AMOUNT
6.     FROM GL10000 LEFT OUTER JOIN GL10001 ON GL10000.JRNENTRY = GL10001.JRNENTRY
7.     GROUP BY GL10000.JRNENTRY) AS UNPOSTED
8. ON POSTED.JRNENTRY = UNPOSTED.JRNENTRY
9. WHERE UNPOSTED.AMOUNT IS NULL

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 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 2013 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. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Mask a Field in Dynamics GP

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. Click on Tools>> Customize>> Modify Current Window which will open the modifier and allow you to modify the screen, click on the Item Number field and go to the “Properties” panel on the right:

3. Double click on “Field” option to get the following form:

4. Click on Open to go deeper with the Item Number format Options in Data Type Definition and then click on the button next to Format:

5. The format is currently set to be one of the out of the box formats that limits the length of the string to 30 characters, we will need to create a new format:

6. Customize the format as needed, for our example we will formatting the field as below:

7. Start clicking OKs to start all dialog windows, and save then get back to Dynamics GP and go to Cards>> Inventory>> Item:

8. Notice the change over all forms that has the item number field there!

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

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. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Excel Paste Tips

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

Purchase Order Commitment–Required Date from PO Required Date or Item Required Date?

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 header has a required date field and the line items each has its own required date field, so which one will be used to commit the purchase order against the budget?

Logically each line item will be validated separately against the budget and therefore the date should be the line item date, after checking this it turned to be right and the system is looking into the line item “Required Date”.

---

Regards,

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