Mark Polino’s Weekly MS Connect Recommendation – SmartList Left Pane Resizing

Microsoft Dynamics GPMark Polino on This weeks is a vote on allowing the left hand (treeview) pane of the SmartList to be resized.

Voting for this would be a better, long term fix to the problem of how GP itself resizes the pane and an alternative to customisations such as this one.

Management Reporter 2012 for Microsoft Dynamics ERP Rollup 1 Released

Microsoft Dynamics GPI’m slightly late in posting this one but I figure it might still be a useful post to make.

On 30th April 2012 Microsoft released Rollup 1 for Management Reporter 2012 for Microsoft Dynamics ERP which includes an updated Migration Wizard [PDF] which was missing from Management Reporter 2012 until now.

Rollup 1 can be downloaded here (PartnerSource or CustomerSource login required).

Mark Polino Steps Forward To Promote MS Connect

Microsoft Dynamics GPIt’s very likely that you’ve never heard of Microsoft Connect; Connect is used by the Dynamics teams to decide what to put in future releases and users have the opportunity to add suggestions and vote on existing items.

Mark has a post on DynamicAccounting.net where he proposes doing a weekly post to promote an existing suggestion for improvement of Microsoft Dynamics GP on Connect for people to vote for, or against, inclusion in a future version of Microsoft Dynamics GP. His posts on this subject will be a weekly feature where he highlights a different suggestion each week for the community to review and decide if it would be a worthwhile addition.

This weeks post relates to a change to allow Unit Accounts to be zeroed during the year end process in the GL. Please take the time to review this suggestion and vote for, or against, and help to improve and guide the future development Microsoft Dynamics GP.

Microsoft Connect has been around for a while but it woefully unused, I’m as guilty as anyone atnot using it much, but it is a way for both partners and customers to have a hand in guiding the development of Microsoft Dynamics GP.

Please join in and follow Mark’s posts on this subject, every Tuesday, on DynamicAccounting.net.

How To Copy Shortcuts Using PSTL

Microsoft Dynamics GPAfter installing the Professional Services Tools Library earlier this week, I’m doing a series of posts on the different functions available, for free, within.

This post covers the Copy Shortcuts options. This function allows shortcuts to be copied from on user to another.

Continue reading “How To Copy Shortcuts Using PSTL”

How To Disable A Database Using PSTL

Microsoft Dynamics GPNow that the Professional Service Tools Library (PSTL) has been installed it’s time to take a look at some of the functionality available.

The first one I’ll look at is how to disable a database so users cannot log in. Without using PSTL, to deactivate a database requires you to use the User Access window (Microsoft Dynamics GP menu » Tools » Setup » Administration » User Access) and select each user in turn and uncheck the company to be disabled. If you have more than a handful of users, this can take a long time to do but with PSTL all users can be disabled very quickly.

Continue reading “How To Disable A Database Using PSTL”

How To Install Professional Services Tools Library

Microsoft Dynamics GPAs I mentioned in the last post, Microsoft Dynamics GP Support Blog announced that the Professional Services Tools Library had been made free of charge and can be downloaded from here (PartnerSoruce login required; Customers will need to contact their partner). The free PSTL is only available for supported versions of Microsoft Dynamics GP so if you are not using 10 or 2010 you will need to upgrade.

I thought it might be useful to do a short series of posts highlighting some of the PSTL tools and what you can do with them, so to start with I thought a post on how to install the module.

Continue reading “How To Install Professional Services Tools Library”

PSTL Registration Error

Microsoft Dynamics GPEarlier this month the Microsoft Dynamics GP Support Blog announced that the Professional Services Tools Library had been made free of charge and can be downloaded from here (PartnerSoruce login required; Customers will need to contact their partner).

It’s a while since I did much with PSTL so I decided to download it and take a look. I got it installed correctly but when I tried to open it I got this error;

Microsoft Dynamics GP - Unhandled script exception: [Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'PI.dbo.smChangeAccountIndex2'.

Continue reading “PSTL Registration Error”

Editing Standard SmartLists with SmartList Builder

Microsoft Dynamics GPThe Google-fu is weak with this one (this one being me). I read a post ages ago on the subject of SmartList wildcards which looked like it would be really useful, but then, after I’d forgotton the details, couldn’t find it again no matter what searches I tried.

On the Developing for Dynamics GP blog David Musgrave gives a reminder for those using SmartList Builder that there is in fact a way to modify standard SmartLists by downloading them from here (Customer Source login required) without having to manually recreate them.

When you download them, remember to think kind thoughts of the Microsoft Dynamics GP Support Team who created these SmartLists.

How To Install A Domain Controller In Windows 8 Server Consumer Preview

Windows ServerAt the start of this year I did a post on how to install a domain controller in Windows Server 2008 R2 (and I think the method would work back to 2003 as well). However, with the release, albeit of the Consumer Preview, of Windows 8 Server (Windows Server 2013 on release?) that post is out of date.

I say it is out of date because when I tried to run it I got the following message;

Active Directory Domain Services Installer - The Active Directory Domain Services Installation Wizard is relocated in Service Manager. For more information, see http://go.microsoft.com/fwlink/?LinkId=220921

So for those of you who, like myself, are preparing a test environment using Windows 8 Server Consumer Preview, SQL Server 2012, Management Reporter 2012 for Microsoft Dynamics GP 2013 (when it arrives) here is a walk through of creating a domain controller on Windows 8 Server Consumer Preview. Please note this is not a guide that should be used on a production environment; it is solely intended for creating a demo or test environment; I am a Microsoft Dynamics GP specialist, not a Windows Active Directory one.

Continue reading “How To Install A Domain Controller In Windows 8 Server Consumer Preview”

SQL Server Management Studio Not Allowing Table Changes That Require A Table To Be Dropped

Microsoft SQL ServerI was doing some work with a custom table yesterday and at one point needed to make a change to the table layout via SQL Server Management Studio. However, when I tried, I got the below error message;

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can

Continue reading “SQL Server Management Studio Not Allowing Table Changes That Require A Table To Be Dropped”