Dex.ini Switch To Prevent Users Changing DSN

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPThere are a lot of switches available which can be added to the Dex.ini file; Leslie Vail did a post back in February 2014 where she listed all of the switches she knows (and a long list it is too).

I need to have a proper through Leslie’s list again soon as there are some very useful switches. Two that caught my eye recently, which are on Leslie’s list, were actually posted by Béat Bucher on the Dynamics Community Forum (I was searching for something else when I found the post):

SQLLastDataSource=Dynamics GP
EnableServerDropDown=FALSE

These switches set the last DSN used and then disable the Server drop down to stop users changing it. This is useful when there are several DNSs created on the client machine (required for other applications), but only one of them is for Dynamics GP.

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

Scripts to Reset System and Budget Passwords

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPIf a user forgets the password set against a Budget it cannot be amended through Microsoft Dynamics GP, but can be removed through SQL Server; the same stands true for the System Password as well.

The first script in this post, removes the password of a budget; this SQL is not mine, but was posted by Leslie Vail in this post on the Dynamics Community forum.

To run this script change the highlighted section to the name of the budget which needs the password reset:

UPDATE
	GL00200
SET
	BUDPWRD = 0x00202020202020202020202020202020
WHERE
	BUDGETID = 'budget id'
GO

A very similar script can be used to reset the System Password. If you are using a Named System Database, change the highlighted DYNAMICS text to the name of your System Database:

USE DYNAMICS
GO
UPDATE
	SY02400
SET
	Password = 0X00202020202020202020202020202020
GO
● Categories: Dynamics, GP, Microsoft ● Tags: , , , , ,  ● Permalink ● Shortlink ●

azurecurve Included in Dynamics101 Top 25 Dynamics GP Blogs

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPThe recently launched Dynamics 101 training site has announced their first annual list of Top 25 Dynamics GP Sites.

The list includes the usual suspects of Victoria Yudin, Leslie Vail, Mark Polino, Mariano Gomez, David Musgrave and more.

Click the image below to see the rest of the list:

Top 25 Dynamics GP Blogs

● Categories: Dynamics, GP, Microsoft, Site ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

Developing Microsoft Dynamics GP Business Applications by Leslie Vail

● Ian Grieve ●  ● 0 Comments   ● 

If you’re a regular visitor to my blog, you’ll be aware that I have been doing a detailed review of Leslie Vail’s book Developing Microsoft Dynamics GP Business Applications;

Developing Microsoft Dynamics GP Business Applications by Leslie Vail

I sometimes feel that in my reviews I may be coming across too critical. If so, I apologise because I actually think the book is really good and I have a lot of respect for Leslie and her contributions to the Dynamics community.

Continue reading → Developing Microsoft Dynamics GP Business Applications by Leslie Vail

● Categories: Dynamics, GP, Microsoft, Packt Publishing ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Top 100 Most Influential People in Microsoft Dynamics 2013: Vote for David Musgrave

● Ian Grieve ●  ● 5 Comments   ● 

There are many people who contribute to the Microsoft Dynamics community during the year. As this blog is focussed on Microsoft Dynamics GP there are a number of outstanding people as contenders for entry on the Top 100 Most Influential People in Microsoft Dynamics 2013 list which is at the voting stage.

I’ve taken a look at the list and read the clarion calls from Mark Polino, Leslie Vail and Jivtesh Singh to vote for David Musgrave (the man behind Developing for Dynamics GP and the incredibly useful Support Debugging Tool). I have done so and would encourage other people to consider casting your vote for him as well; he can be found on page 4.

● Categories: Dynamics, Microsoft ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

Review of Developing Microsoft Dynamics GP Business Applications – Part 6

● Ian Grieve ●  ● 2 Comments   ● 

I have many other outside work items competing for my time at the moment which, combined with being busy at work is leaving me little time for reviewing. To that end I’m snatching an hour while sat at a hotel in the Midlands (South Yorkshire to be exact) to add another part to my review of Leslie Vail’s book Developing Microsoft Dynamics GP Business Applications published in October by Packt Publishing;

Developing Microsoft Dynamics GP Business Applications by Leslie Vail

Continue reading → Review of Developing Microsoft Dynamics GP Business Applications – Part 6

● Categories: Dynamics, GP, Microsoft, Packt Publishing, Review, SmartList Builder, Third Party Add-on ● Tags: , , , , , , , , , ,  ● Permalink ● Shortlink ●

Review of Developing Microsoft Dynamics GP Business Applications – Part 5

● Ian Grieve ●  ● 0 Comments   ● 

I started reviewing Leslie Vail’s book, Developing Microsoft Dynamics GP Business Applications, which was published at the end of December by Packt Publishing, a few weeks ago. To do this review I decided to take a read through and complete all the examples she gives on developing an application as I’ve only had very limited experience with Dexterity;

Developing Microsoft Dynamics GP Business Applications by Leslie Vail

Today, it is time for part 5 of my review where I look at Chapter 6: Deploying a Dexterity Solution where Leslie covers the following key topics:

  • System requirements
  • Versions and builds
  • Table creation routines
  • Completing the application
  • Creating the chunk file
  • Testing in a multi-dictionary environment
  • Distributing the completed application

This chapter has a fair bit of explanatory text covering each of the key topics.

Continue reading → Review of Developing Microsoft Dynamics GP Business Applications – Part 5

● Categories: Dexterity, Dexterity Utilities, Dynamics, GP, Microsoft, Packt Publishing, Review, sanScript ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

Review of Developing Microsoft Dynamics GP Business Applications – Part 4

● Ian Grieve ●  ● 2 Comments   ● 

I started reviewing Leslie Vail’s book, Developing Microsoft Dynamics GP Business Applications,which was published at the end of December by Packt Publishing, a few weeks ago. To do this review I decided to take a read through and complete all the examples she gives on developing an application as I’ve only had very limited experience with Dexterity;

Developing Microsoft Dynamics GP Business Applications by Leslie Vail

Today I’m taking a look at Chapter 5 which covers sanScript and how to add it to windows to enable the required functionality. The key topics to be covered are:

  • Introduction to sanScript
  • Scrolling Windows
  • Triggers

Continue reading → Review of Developing Microsoft Dynamics GP Business Applications – Part 4

● Categories: Dexterity, Dexterity, Dynamics, GP, Microsoft, Packt Publishing, Programming, Review, sanScript ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

Developing Microsoft Dynamics GP Business Applications eBook Giveaway Winners

● Ian Grieve ●  ● 0 Comments   ● 

I recently had three e-copies to giveaway of Leslie Vail’s book, Developing Microsoft Dynamics GP Business Applications.

The ebook giveway was in association with the publisher of the book, Packt Publishing.

Thanks very much all who entered, but unfortunately there could only be three winners who have now been contacted by Packt on the email address supplied with their entries in the giveaway.

The winners are (in no particular order, beyond ladies first);

  • Jennifer H
  • Bruce E
  • Scott S

For those unfortunate not to win, you can purchase Leslie’s book either direct from Packt Publishing or via Amazon:

Amazon UK Amazon US

Thanks again to those who entered.

● Categories: Dynamics, eBook Giveaway, GP, Microsoft, Packt Publishing ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Review of Developing Microsoft Dynamics GP Business Applications – Part 3

● Ian Grieve ●  ● 2 Comments   ● 

After slacking off a lot in terms of reviewing Leslie Vail’s book Developing Microsoft Dynamics GP Business Applications, which was published at the end of December by Packt Publishing, I’m going to try to get a regular tempo of review posts going. Today I’m here with the review for chapter 4;

Developing Microsoft Dynamics GP Business Applications by Leslie Vail

This chapter is all about Building the User Interface which Leslie does by getting the reader to build an interface for customer contacts integration and covers:

  • Creating base resources
  • Creating tables and keys
  • Creating forms and windows
  • Creating scrolling windows
  • Working with window fields
  • Completing your windows

So from this chapter I expect to get a good grounding in creating an entirely new window which should look like this:

Customer Contact Maintenance

Continue reading → Review of Developing Microsoft Dynamics GP Business Applications – Part 3

● Categories: Dexterity, Dexterity, Dynamics, eBook Giveaway, GP, Microsoft, Packt Publishing, Programming ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●