Author Archive:

rss feed

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

Dynamics GP 2013 Business Portal

| 01/09/2013 | 0 Comments
Dynamics GP 2013 Business Portal

Customers who are running Business Portal cannot upgrade to GP 2013 till march as the Business Portal has not yet released, take a look into the announcement from Inside Microsoft Dynamics GP Blog: http://blogs.msdn.com/b/gp/archive/2013/01/08/microsoft-dynamics-gp-2013-business-portal-update.aspx Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading