Tag: management

SQL view for Dynamics GP open year GL trial balance with month end balances

| 07/09/2014 | 0 Comments

Based on a reader’s request, I have created a variation on my SQL view for Dynamics GP open year GL trial balance. This version will show you the month end balances instead of the net change for each month

Continue Reading

Dynamics GP 2013 R2 Released–Download Links

| 05/29/2014 | 0 Comments
Dynamics GP 2013 R2 Released–Download Links

Microsoft Dynamics GP 2013 Product Download Page  – https://mbs.microsoft.com/customersource/northamerica/GP/downloads/service-packs/MDGP2013_Release_Download   The Inside GP blog has been covering the new features for quite a while now, and I highly recommend checking it out – Inside Microsoft Dynamics GP . Siva has more details and lots of resources – Dynamics GP 2013 R2–Released Today!!   More Information Introducing Microsoft Dynamics GP 2013 R2 – The Edge Blog Microsoft Dynamics GP 2013 R2 New Feature Blog Series Schedule!!  

Continue Reading

Management Reporter CU9 does not support windows XP

| 05/28/2014 | 0 Comments
Management Reporter CU9 does not support windows XP

One of my customers recently upgraded his environment to SQL 2012 and GP 2013 from windows 2003 and GP 9.0, upon installing Management Reporter with CU 9.0 that supports SQL 2012 I have realized that it cumulative update no longer supports windows XP, therefore I had to rollback my installation and install CU8 then re-imported my reports.

Continue Reading

The Dynamics GP Blogster in Johannesburg, South Africa

| 05/25/2014 | 0 Comments

My travels will take me to the beautiful and cosmopolitan city of Johannesburg, South Africa to conduct Microsoft Dexterity training for customers in the area. I will be there from Sunday May 25, 2014 through Saturday, May 31, 2014 and I am looking forward to meet a number of you. I will be available in the afternoons after 6:00 PM local time and as time permits.

Continue Reading

reIMAGINE 2014: You are the difference!

| 05/20/2014 | 0 Comments

No, my post title it’s not an official slogan for the conference, but the reIMAGINE 2014 conference in Fargo promises to be just what Microsoft Dynamics GP partners had been expecting for years: and all out sales, technical consulting, and software developer extravaganza that combines the likes of the former Great Plains Software’s Stampede to Fargo and the Microsoft Dynamics GP Technical Airlift. But there’s a caveat: as a partner, YOU get to provide feedback  on the content and topics you want to see and learn about

Continue Reading

"Invalid Object Name ..SY01500" error after restoring GP 2013 company database in a different environment

| 05/19/2014 | 0 Comments

Just recently I was working with a partner to determine the root cause of an issue that stemmed from restoring a company database from a customer’s production environment, to the partner’s development environment. After restoring the database, we could see the following error messages attempting to access the database: Invalid object name SY01500 error  smCleanupFilesBeforeLogin stored procedure error Login failed error Enabling a DEXSQL.LOG gave us more insight into the issue. We could see the following prepared statement being executed prior to the ODBC error message: /*  Date: 05/18/2014  Time: 19:55:37 stmt(148745784):*/ BEGIN DECLARE @stored_proc_name char(34) DECLARE @retstat int DECLARE @param5 tinyint DECLARE @param6 smallint DECLARE @param7 tinyint DECLARE @param8 tinyint DECLARE @param9 tinyint DECLARE @param10 tinyint DECLARE @param11 tinyint DECLARE @param12 int set nocount on SELECT @param5 = 0 SELECT @stored_proc_name = ‘ZBPI.dbo.smCleanupFilesBeforeLogin’ EXEC @retstat = @stored_proc_name 5, ‘sa’, ‘ Company_Name ‘, 0, @param5 OUT, @param6 OUT, @param7 OUT, @param8 OUT, @param9 OUT, @param10 OUT, @param11 OUT, @param12 OUT SELECT @retstat, @param5, @param6, @param7, @param8, @param9, @param10, @param11, @param12 set nocount on END /* /*  Date: 05/18/2014  Time: 19:55:37 SQLSTATE:(S0002) Native Err:(208) stmt(148745784):*/ MicrosoftSQL Server Native Client 10.0SQL ServerInvalid object name ‘DYNGP2013..SY01500′.*/ /* The prepared statement calls the dbo.smCleanupFilesBeforeLoging stored procedure, which has (68) hardcoded references to the former system database in the old environment

Continue Reading

Working with the Dex.ini Settings in Microsoft Dynamics GP 2013

| 05/13/2014 | 0 Comments

Dex.ini settings have always existed to provide developers and end-users with ways to set a number of preferences for their Microsoft Dynamics GP application without the need of additional development or customizations. With the release of Microsoft Dynamics GP 2013 and the web client, the Dex.ini now plays a key role in enabling (or disabling) certain elements rooted in the system’s architecture itself.

Continue Reading