To avoid any appearence of favouritism, I have listed them in Dynamics GP version and author surname order (when multiple authors, the first listed author’s name is used).
As I said in the last post, which covered the playing of a macro, in this post I am going to show how the macro can be played quicker than using the standard Play option.
Credit for this one goes to MVP Leslie Vail, who blogged about it back in 2014. There is a Dex.ini setting which needs to be set to make this function available:
This needs to be configured on any client machine which will be used to run macros. If you are a user of the GP Power Tools you can use the Dex.ini Configuration to roll out this switch to all clients:
The Dex.ini Configuration () window can be used to automate changes to the Dex.ini settings for all workstations. This is a very useful tool, especially when there are either a lot of desktop clients installed or a lot of Citrix/terminal servers:
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.
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
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.
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.
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;
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.