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 email@example.com http://www.di.jo
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 firstname.lastname@example.org http://www.di.jo
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
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.