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

Historical Stock Status Script

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 allow you to estimate your inventories using a historical date:

Historical Stock Sttus Summary

1. DECLARE @ASOFDATE DATETIME
2. SET @ASOFDATE = '2016-12-31'
3.  
4. SELECT
5. ITEMNMBR AS [Item Number],
6. TRXLOCTN AS [Location],
7. SUM(Quantity) AS Quantity,
8. SUM([Extended Cost]) AS [Total Cost]
9.  
10. FROM
11.  
12. (SELECT ITEMNMBR,
13.  
14. (dbo.IV10200.QTYRECVD -
15. ISNULL((SELECT SUM(QTYSOLD) FROM IV10201
16.         WHERE SRCRCTSEQNM = IV10200.RCTSEQNM
17.         AND ITEMNMBR = IV10200.ITEMNMBR
18.         AND DOCDATE <= @ASOFDATE), 0))
19. AS [Quantity],
20.         UNITCOST *
21.             (dbo.IV10200.QTYRECVD -
22.             ISNULL((SELECT SUM(QTYSOLD) FROM IV10201
23.             WHERE SRCRCTSEQNM = IV10200.RCTSEQNM
24.             AND ITEMNMBR = IV10200.ITEMNMBR
25.             AND DOCDATE <= @ASOFDATE), 0))
26. AS [Extended Cost],             
27. TRXLOCTN
28. FROM dbo.IV10200 WHERE DATERECD <@ASOFDATE) AS SOURCE
29. GROUP BY ITEMNMBR, TRXLOCTN

Hope that his helps!

---

Regards,

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

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013

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 a report that looks like the below:

Well done Mark! Go guys and purchase your copy of the book by clicking here, your ROI will be an increase in salary after providing the management with these dashboards!

---

Regards,

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

Vacancies

Dynamics Innovations is currently looking to hire talented resources with the following qualifications for its core business and for its customers and partners in Jordan and Saudi Arabia.

If you feel that you are qualified for one of the below positions and has enough knowledge in the fields requested below, you are kindly asked to send your CV to Careers@di.jo with the required expertise in the email subject, not filling the position required in the subject will lead to ignore your resume as it will not reach the concerned department.

1. Senior .NET Developer

Minimum 4 years of professional experience covering:

• VS 2008/2010, SQL Server 2008/2012, Windows Server 2008/2012
• ASP.NET & C# Web Applications
• Multi-tier Architecture, OOP and UML
• SQL Stored Procedures, ADO and ADO.net
• Experience in reporting service 2005/2008
• XML Web Services
• Experience in Microsoft SharePoint and BizTalk Server is a plus.
• HTML, JavaScript and DHTML Programming

2. Microsoft Dynamics GP Support

Between 1 and 4 Years of professional experience covering:

• Dynamics GP Technical Knowledge (Installation, Configuration, Troubleshooting)
• SQL Server is a must.
• Crystal Reports knowledge is recommended.
• .Net Development experience is a plus.

3. Senior SharePoint 2010 Developer

Minimum 4 years of professional experience covering:

• Experience with SharePoint Portal Server: 2007, specifically 2010
• 4+ years of developing SharePoint web parts and/or components
• 3+ experience developing workflow (SharePoint workflow foundation) .
• 3+ years’ experience in Performance Point dashboard designer
• 3+ years of experience in developing Interactive dashboards, answers reports and analytical
• Experience developing scorecards
• Experience with data warehousing concepts
• Experience with OLAP
• Expert level of knowledge (4+ years’ experience) with various languages/tools such as C#, ASP.NET, HTML, CSS, XML, VBScript, Classic ASP, and JavaScript
• 3+ years of application design and implementation
• 4+ years’ experience with web application / data base integration
• 3+ years of application design and implementation
• 3+ years’ experience with SQL Server database, stored procedures, triggers, DTS, schema design and query optimization is a plus
• Strong object-oriented programming and design skills (Java, C++, Objective-C) are desired
• Experience using and building web UI frameworks.
• Experience in applying design using SharePoint designer 3+ years administrating and configuration of SharePoint

---

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 MVP

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!