Author Archive:

rss feed

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

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

| 04/22/2013 | 0 Comments
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

Continue Reading

Historical Stock Status Script

| 04/22/2013 | 0 Comments
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 DECLARE @ASOFDATE DATETIME SET @ASOFDATE = ’2016-12-31′   SELECT ITEMNMBR AS Item Number , TRXLOCTN AS Location , SUM ( Quantity ) AS Quantity , SUM ( Extended Cost ) AS Total Cost   FROM   ( SELECT ITEMNMBR ,   ( dbo . IV10200 .

Continue Reading

Dynamics GP 2013 MVP

| 04/16/2013 | 0 Comments

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!

Continue Reading