Author Archive

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

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

April 23, 2013 ·  · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 197

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:

image


Regards,


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

Visit site:
Excel Paste Tips

April 23, 2013 ·  · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 196

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

See the original article here:
Purchase Order Commitment–Required Date from PO Required Date or Item Required Date?

April 22, 2013 ·  · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 228

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

Read the article:
Historical Stock Status Script

April 22, 2013 ·  · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 725

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!

IMAG0304

IMAG0305

IMAG0307

IMAG0306

See more here:
Dynamics GP 2013 MVP

April 16, 2013 ·  · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 169

Installing SQL Failover Clustering Without SAN Storage – Windows 2008 R2

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 Software Target” free of charge, by using the utility you can create a storage and share it across multiple servers, “fooling” the windows to think that a SAN Storage is available.

Following the above, I been able to install failover clustering for testing over one single machine without any other equipments! I used Hyper-V to create 3 Windows 2008 R2 Servers and 1 Virtual Hard Disk Drive and worked out a fully functioning test environment, below what you need if you like to test this one your machine:

1. Over a test server, install Windows 2008 R2 and activate the Hyper-V.

2.  Create 3 virtual machines, one for SQL Server Node1, and the second for the second failover node, and the third one to act as storage server.

3. Create 1 virtual hard disk to represent your SAN Storage.

When you gather these, click on the following tech-net article that details all what you need:

http://blogs.technet.com/b/mghazai/archive/2009/12/12/hyper-v-guest-clustering-step-by-step-guide.aspx

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

Read more here:
Installing SQL Failover Clustering Without SAN Storage – Windows 2008 R2

February 26, 2013 ·  · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 268

LinkedIn

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% most viewer profiles, 5% or 10%.

I made the 5% List!

Linked In

Regards,


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

Read More:
LinkedIn

February 21, 2013 ·  · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 182