Error deploying Microsoft Dynamics GP sample company

Microsoft Dynamics GPI was creating a new Microsoft Dynamics GP test environment the day when I encountered a problem at the point of deploying the Fabrikam sample company.

I did a quick search and found a blog I wrote over six years ago where I got this message and tracked it down to a corrupt installation of the GP 9 server components. Well, server components no longer exist as a separate thing, but it was possible something had happened to the install.

However, after uninstalling and reinstalling the problem still occurred:

Error message

Microsoft Dynamics GP Utilities

Install of database SMTWO failed! Microsoft Dynamics GP Utilities will now shut down.

This environment is using a shared SQL Server, so I'm using SMTWO as the database name for Fabrikam rather than the standard TWO, but I have used alternative names many times without issue.

I am aware that you can't use reserved words for database names; this is not a Dynamics GP restriction, but rather a SQL one itself. I also tried SOTWO and got the same error and neither of these appear to be reserved names.

When I tried TWOSM, the install went through and worked without any problem, so there is obviously some sort of problem related to the two names I tried.

Hands On with Microsoft Dynamics GP October 2019 Release: Add sample company

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP. Over the series so far, I have downloaded and installed the prerequisites and client and then deployed the system database. In this post, I am going to add the sample company.

To do this, launch GP Utilities and log in using the sa account:

Welcome to Microsoft Dynamics GP Utilities - login

Continue reading "Hands On with Microsoft Dynamics GP October 2019 Release: Add sample company"

Error Raising In-Transit Transfer in Microsoft Dynamics GP

Microsoft Dynamics GPI was doing some work for a client the other day who was implementing some new functionality in Microsoft Dynamics GP. One of the areas they were working on was Inventory Control. They were testing that everything was working correctly and tried to raise an In Transit Transfer (Inventory Control area page » Transactions » in-Transit transfer Entry); when they entered the Item Number and hit tab the following error appeared:

Error entering an item

Microsoft Dynamics GP
A get/change first operation failed on table 'IV_TRX_WORK_LINE' failed accessing SQL data.

Continue reading "Error Raising In-Transit Transfer in Microsoft Dynamics GP"

Error Creating Fiscal Calendar In Fabrikam Caused by Audit Trail Codes

Microsoft Dynamics GPI've been receiving an error in the Fabrikam Sample Company database when trying to create a new Financial Calendar for a while and finally had the time to track it down.

The error appears when you enter a new year and click the Calculate button:

Error when calculating a new year

Microsoft Dynamics GP
[Microsoft][SQL Server Native Client 11.0][SQL Server[Violation of PRIMARY KEY constraint 'PKSY40100'. Cannot insert duplicate key in object 'dbo.ST40100'. The duplicate key value is (0, 2021, 0, 2 ,General Entry ).

Continue reading "Error Creating Fiscal Calendar In Fabrikam Caused by Audit Trail Codes"

Changing System Database Name After Installing the Microsoft Dynamics GP Client

Microsoft Dynamics GPI was installing a new VM to do some testing on and, after installing the Microsoft Dynamics GP, I ran GP Utilities and realised that I had an mistake in the system database name I had defined; the SQL Server I am using already had a deployment of Microsoft Dynamics GP 2018 R2 on it, so could not use my usual name of D18R2 and had to use an alternative.

I had decided to name the system database D18R2U and Fabrikam sample company as U18R2 as this demo VM was to be in US English. However, I named the system database U18R2.

I've never changed the system database used by a client before, but I remembered seeing a setting in the Dex.ini file:

Dex.ini file with Pathname line highlighted

Continue reading "Changing System Database Name After Installing the Microsoft Dynamics GP Client"

SQL Script to Insert Vendors

Microsoft Dynamics GPWhile writing a Rockton Software's SmartFill product recently, I wanted to do a test on a large dataset. The testing of SmartFill I had done to that point had been on vendors, so I deviced to continue in that vein.

I produced the script below which inserts records into the PM Vendor Master File (PM00200) and PM Address MSTR (PM00300) tables bgy copying an existing vendor, but assigning a unique Vendor ID to each new record. For ease of running, I creaed the script as a stored procedure wic accepts the number of records to create, the vendor to be copied and the new name of the vendor which will be created concatenated with an increasing integer.

-- drop stored proc if it exists
IF OBJECT_ID (N'usp_AZRCRV_CreateTestVendors', N'P') IS NOT NULL
    DROP PROCEDURE usp_AZRCRV_CreateTestVendors

-- create stored proc
	@MaxLoop INT = 5
	,@VendorID VARCHAR(15) = 'BEAUMONT0001'
	,@VendorIDPrefix VARCHAR(8) = 'VEND'
	Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (
	This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 2.0 UK: England & Wales (CC BY-NC-SA 2.0 UK).
	DECLARE @Loop INT = 1

	WHILE (@Loop <= @MaxLoop)
			-- Insert into PM Vendor Master File (PM00200)
			-- VALUES
					@VendorIDPrefix + CAST(@Loop AS VARCHAR(7))
					VENDORID = @VendorID)

			-- Insert into PM Address MSTR (PM00300)
			-- VALUES
					@VendorIDPrefix + CAST(@Loop AS VARCHAR(7))
					VENDORID = @VendorID)
			SET @Loop = @Loop + 1

-- grant execute permission on stored proc to DYNGRP

-- execute stored proc
EXEC usp_AZRCRV_CreateTestVendors 20, 'ADVANCED0001', 'VENDOR'

This script was created for, tested with and only run against the Fabrikam sample database.

Implementing Enhanced Notes: What is Enhanced Notes?

GP Elementz Enhanced NotesThis post is part of a series on Implementing Enhanced Notes from ISC Software Solutions.

Enhanced Notes is one of the GP Elementz available from ISC Software Solutions.

The Enhanced Notes module is a Dexterity customisation which is installed on every Microsoft Dynamics client which replaces the standard notes window in all areas of Dynamics GP.

Instead of a single notes page, Enhanced Notes allows discrete notes to be created:

Continue reading "Implementing Enhanced Notes: What is Enhanced Notes?"

Hands On with Microsoft Dynamics GP 2018 R2: Add Sample Company

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I'll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won't be covering.

The series index will automatically update as posts go-live in this series.

In the last post, I deployed the system database; I'm continuing this post from the Additional Tasks step.

Ensure the drop-down list shows Add sample company data and click Process:

Additional Tasks

Continue reading "Hands On with Microsoft Dynamics GP 2018 R2: Add Sample Company"

Update Year on Budgets in Fabrikam Sample Company

Microsoft Dynamics GPI've written a few scripts to update data in the Fabrikam sample company (I will be posting a series index to link them all together in the near future).

The sample company ships with a few budgets preloaded, but they are not named very well. For example, the budget for 2027 (the year in which Fabrikam is operating) is named BUDGET 4 and the budget for 2025 is named BUDGET 2005.

Continue reading "Update Year on Budgets in Fabrikam Sample Company"

Hands On With MDGP 2018 RTM: Deploy Sample Company

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

With the system database deployed, the next step is to deploy the Fabrikam, Inc. sample company.

To do this, launch GP Utilities and log in using the sa account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading "Hands On With MDGP 2018 RTM: Deploy Sample Company"