Fixed Assets Now Disallows Hyphens In The Asset ID

● Ian Grieve ●  ● 3 Comments  ● 

Microsoft Dynamics GPI heard about this problem a short time ago, but have just had a client upgrade to Dynamics GP 2013 R2 and encounter this problem:

Microsoft Dynamics GP - The asset ID cannot contain a hyphen. Select a different asset ID.Microsoft Dynamics GP – The asset ID cannot contain a hyphen. Select a different asset ID.

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.

● Categories: Dynamics, Fixed Asset Management, GP, Microsoft, Professional Services Tools Library ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Professional Services Tools Library – DBMS Error 4920

● Ian Grieve ●  ● 0 Comments  ● 

Microsoft Dynamics GPI 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:

Microsoft Dynamics GP - The stored procedure failed to enable taVendorInsert returned the following results: DBMS: 4920, Microsoft Dynamics GP: 0Microsoft Dynamics GP – The stored procedure failed to enable taVendorInsert returned the following results: DBMS: 4920, Microsoft Dynamics GP: 0

Continue reading → Professional Services Tools Library – DBMS Error 4920

● Categories: Dynamics, GP, Microsoft, Professional Services Tools Library ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

MDGP 2013 R2 Feature of the Day: Take Company Offline

● Ian Grieve ●  ● 1 Comment  ● 

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:

Take Company Offline for Maintenance

Continue reading → MDGP 2013 R2 Feature of the Day: Take Company Offline

● Categories: Dynamics, GP, Microsoft, Professional Services Tools Library ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

How To Recreate SQL Objects Using PSTL

● Ian Grieve ●  ● 3 Comments  ● 

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.

Continue reading → How To Recreate SQL Objects Using PSTL

● Categories: Dynamics, GP, Microsoft, Professional Services Tools Library ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

Error Starting Microsoft Dynamics GP After Installing PSTL

● Ian Grieve ●  ● 1 Comment  ● 

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;

Microsoft Dynamics GP - A Get/Change Operation on Table 'gpAppEnabled' cannot find the table

I’d sent them the PSTL download along with the instructions on how to install it without realising that there was a missing part to me instructions (which has now been added).

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

● Categories: Dynamics, GP, Microsoft, Professional Services Tools Library ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

How To Rebuild GL00105 Using PSTL

● Ian Grieve ●  ● 2 Comments  ● 

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.

Continue reading → How To Rebuild GL00105 Using PSTL

● Categories: Dynamics, GP, Microsoft, Professional Services Tools Library ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

How To Copy Shortcuts Using PSTL

● Ian Grieve ●  ● 2 Comments  ● 

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.

Continue reading → How To Copy Shortcuts Using PSTL

● Categories: Dynamics, GP, Microsoft, Professional Services Tools Library ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

How To Disable A Database Using PSTL

● Ian Grieve ●  ● 2 Comments  ● 

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 (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

● Categories: Dynamics, GP, Microsoft, Professional Services Tools Library ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

How To Install Professional Services Tools Library

● Ian Grieve ●  ● 5 Comments  ● 

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.

Continue reading → How To Install Professional Services Tools Library

● Categories: Dynamics, GP, Microsoft, Professional Services Tools Library ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

PSTL Registration Error

● Ian Grieve ●  ● 2 Comments  ● 

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;

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

● Categories: Dynamics, GP, Microsoft, Professional Services Tools Library ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●