This issue was discussed at some length on the Community Forum with Frank Hamelly supplying a SQL script to update the assets.
With my client I took a slightly different tack and used the Fixed Assets Modifier tool in the Professional Services Tools Library (PSTL). This tool works on a single asset at a time and, unlike some of the other modifiers, does not allow import of a spreadsheet.
However, PSTL is written in Dexterity and allows the use of Dynamics GP Macros; so after doing an extract of all Asset IDs I was able to use mail merge to generate a macro to update all fixed assets containing a hyphen in the Asset ID.
I have checked Microsoft Dynamics GP 2015 and a hyphen is still disallowed in the Asset ID field.
I ws recently doing some work for a client, one part of which was to configure Microsoft Dynamics GP to duplicate creditors created in one company into another using the PM Master Trigger functionality in the Professional Services Tools Library (PSTL).
When I tried to enable the trigger I received the following error message:
The Inside Microsoft Dynamics GP blog started a series of Microsoft Dynamics GP 2013 R2 Feature of the day posts the other day. As they did with the Microsoft Dynamics GP 2013 Feature of the Day posts they are doing them as short posts containing a PowerPoint slide show. I am translating these from the PowerPoints into posts; you can find my series index here.
The twenty-second Feature of the Day covered is Take Company Offline. This feature provides an easy way to take a company offline in order to perform a maintenance or business task requiring exclusive access. While a company is offline, only the user needing to perform the task and administrators can log into the company.
With this feature, the administrator can also send messages to GP users. Messages can be sent as a task reminder of upcoming events like maintenance happening this weekend or pop-up messages asking the user to exit the system for example.
The Take Company Offline for Maintenance window allows a single, or multiple companies, to be taken offline and a message entered which will be displayed to user’s as they attempt to access an offline company:
As well as rebuilding a corrupt GL00105, the Toolkit within the Professional Services Tools Library (PSTL) can be used to recreate SQL objects such as SQL Indexes or the Dex stored procedures.
I’m taking a slight detour away from posting the series of how to’s on the Professional Services Tools Library to highlight an installation error that I’ve recently seen when installing PSTL.
A client recently installed PSTL and reported receiving the below error message;
When installing PSTL into a company for the first time, you must log into Microsoft Dynamics GP as the sa user as there are some tables which get created (covered in KB Article 861564 which is actually a retired article but does mention the issue and the resolution).
A 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.
After 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.
Now 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 () 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.
As 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.
Earlier 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;