Author Archive:

rss feed

Installing SQL Failover Clustering Without SAN Storage – Windows 2008 R2

| 02/26/2013 | 0 Comments
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

Continue Reading

LinkedIn

| 02/21/2013 | 0 Comments

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

Continue Reading

How to Track unused Journal Numbers

| 02/17/2013 | 0 Comments
How to Track unused Journal Numbers

I got an interesting question from one of the GP users requesting a list of unused Journal Number, therefore I decided to scratch my head and write this query, below will help: SELECT DISTINCT NUMBER FROM MASTER..spt_values WHERE NUMBER BETWEEN (SELECT MIN(JRNENTRY) AS FROMNUMBER FROM (SELECT DISTINCT JRNENTRY FROM GL20000) AS JOURNALS) AND (SELECT MAX(JRNENTRY) AS TONUMBER FROM (SELECT DISTINCT JRNENTRY FROM GL20000) AS JOURNALS) AND number NOT IN (SELECT DISTINCT JRNENTRY FROM GL20000) Happy tracking…! Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading

Dynamics GP Excel Paste V 4.0

| 01/28/2013 | 0 Comments
Dynamics GP Excel Paste V 4.0

We have finally released and uploaded a new version for the Excel Paste, this one has the following coverage: 1. The major move was the ability to integrate into multiple products, like combining the GL Transaction Entry with the Analytical Accounting

Continue Reading

Dynamics GP 2013 Demo Image

| 01/19/2013 | 0 Comments
Dynamics GP 2013 Demo Image

Yes it has been released, Microsoft team is doing everything fast in relation to GP 2013! take a look into the following article: http://blogs.msdn.com/b/gp/archive/2013/01/15/where-s-the-demo-image-here-today.aspx Regards, — Mohammad R.

Continue Reading

Developing Microsoft Dynamics GP Business Applications

| 01/16/2013 | 0 Comments
Developing Microsoft Dynamics GP Business Applications

Do you want to learn everything related to Dynamics GP development? Dexterity, VBA, .NET, Extender and everything for just a 30$?!? I found these all in one book I reviewed written by Leslie Vail , it is Developing Microsoft Dynamics GP Business Applications Worth to take a look! Regards, — Mohammad R

Continue Reading

Dynamics GP – Change a form field to “Required” field

| 01/12/2013 | 0 Comments

I got many requests from my customers on how to make this happens and I used to create a package and send it to the users for import. However with the new Licensing structure, everybody owns the modifier as a part of the starter pack! Therefore anyone can do the following steps to activate this: Open the Form. Go to Tools> > Customize > > Modify Current Window Select the field and switch “Required” to true as shown below: Hope that this helps! Regards, — Mohammad R.

Continue Reading