How To Rebuild GL00105 Using PSTL

Microsoft Dynamics GPA while ago I posted a script that could be used to fix a corrupt Account Index Master (GL00105). However, the Toolkit within the Professional Services Tools Library (PSTL) can be used to do the same thing without resorting to a custom script.

Continue reading “How To Rebuild GL00105 Using PSTL”

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).

Apology for Lack of Updates

azurecurveJust a quick update to apologise for the lack of updates.

I’m currently stressing out about a house purchase I’m trying to get through as soon as possible (with concerns I may actually lose the house if it doesn’t exchange soon). For the regular readers out there (I assume there are some) I moved back to the NE in September last year to start a new job as consultant with Perfect Image, specialising in Microsoft Dynamics GP and sidelining in Dynamics CRM, and this is the final step for me to complete the move.

Once the purchase completes and I can stop stressing I’ll get back to posting; I have a backlog of posts not just related to the recently started series of posts on PSTL but also other areas of the system and related products.

Of course, once it does complete I’ll be project managing a renovation which will probably also cause me to stress out but I doubt as much as the purchase is (Bloody Hell I hope not anyway).

Hopefully back soon with some useful posts.

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.