Month: August 2019

If you have a modified window which is no longer required, it is fairly easy to remove (although these steps will need to be repeated on each client).

To remove the window, open Modified (Microsoft Dynamics GP menu » Tools » Customize » Modifier):

Continue reading “Remove Modified Window From Microsoft Dynamics GP”

When I install demo VMs, I usually want everything setup the same way each time I do it. This includes things like inserting UK VAT Rates as well as some more mundane configuration issues like the order of series on the navigation pane.

That’s what the script in this post does; it switches off some of the series so they don’t show and reorders the remaining ones into the order I want them in.

Before running the script, set the USERID at the top (highlighted).

/*
Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
DECLARE @USERID VARCHAR(30) = 'iang'

UPDATE
	SY07130
SET
	Visible = 0
WHERE
	USERID = @USERID
AND
	CmdSequence BETWEEN 6 AND 9

UPDATE
	SY07130
SET
	CmdSequence = CmdSequence + 30
WHERE
	USERID = @USERID

UPDATE
	SY07130
SET
	CmdSequence = 1
WHERE
	USERID = @USERID
AND
	CmdParentCmdID = 11
	
UPDATE
	SY07130
SET
	CmdSequence = 2
WHERE
	USERID = @USERID
AND

	CmdParentCmdID = 1
UPDATE
	SY07130
SET
	CmdSequence = 3
WHERE
	USERID = @USERID
AND
	CmdParentCmdID = 6
	
UPDATE
	SY07130
SET
	CmdSequence = 4
WHERE
	USERID = @USERID
AND
	CmdParentCmdID = 3
	
UPDATE
	SY07130
SET
	CmdSequence = 5
WHERE
	USERID = @USERID
AND
	CmdParentCmdID = 7
	
UPDATE
	SY07130
SET
	CmdSequence = 6
WHERE
	USERID = @USERID
AND
	CmdParentCmdID = 2
	
UPDATE
	SY07130
SET
	CmdSequence = 7
WHERE
	USERID = @USERID
AND
	CmdParentCmdID = 4
	
UPDATE
	SY07130
SET
	CmdSequence = 8
WHERE
	USERID = @USERID
AND
	CmdParentCmdID = 5
	
UPDATE
	SY07130
SET
	CmdSequence = 9
WHERE
	USERID = @USERID
AND
	CmdParentCmdID = 10
	
UPDATE
	SY07130
SET
	CmdSequence = 10
WHERE
	USERID = @USERID
AND
	CmdParentCmdID = 22002
GO

As always before running a script, ensure you have a good backup of your databases.

Microsoft Dynamics GP encrypts its system and budget passwords in a way which cannot be decrypted. Or at least it did. DynDeveloper.com, in April, posted an article containing a stored procedure which would allow the passwords such as the system or budget passwords to be decrypted.

As well as the stored proc, the article also includes sample code which will return the decrypted system password.

The post with code is here.

Update: It turns out this isn’t new and was first posted about back in 2010 when it was misunderstood what this type of decryption would cover. It is system and budget passwords (which are both optional and often not used), not user passwords.