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

View post:
Dynamics GP 2013 R2 Released–Download Links

May 29, 2014 · Jivtesh Singh · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 292

Microsoft Dynamics GP 2013 R2 Feature of the Day Week 3

David Meego - Click for blog homepageThe Inside Microsoft Dynamics GP blog continues with the Microsoft Dynamics GP 2013 R2 Feature of the Day (FOTD) series.

Here are the previous features:

 

Have a look at the posts from Pam Misialek for week 3:

 

To see all the Feature of the Day posts use the link for the Feature of the Day tag

Enjoy

David

Read more here:
Microsoft Dynamics GP 2013 R2 Feature of the Day Week 3

May 28, 2014 · David Musgrave · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 335

Cool Nokia and Windows Phone Adverts

David Meego - Click for blog homepageYes, I am on leave, but by the wonders of post dating articles I can still post a few blogs while I am away.

Now that Nokia’s Devices and Services division has become part of Microsoft, we should see some great innovations in both hardware and software.

I recently came across these videos from Nokia and the Windows Phone team and wanted to share them with you.

 

History in the making (Direct Link)

(Please visit the site to view this video)

With Nokia Devices & Services joining Microsoft, the next chapter of a remarkable story begins: History in the making in Rube Goldberg style

What better way to celebrate the coming together of our histories than with a Rube Goldberg machine, where every part has an equally important role to play in the larger story.

Values, experience, technology, employees and fans…there are many elements involved in the change, and we’re dedicated to bringing each and every piece together perfectly.

 

Lassi Hurskainen Football Trick Shots – Smartphone Switch – Nokia Lumia 630 (Direct Link)

(Please visit the site to view this video)

Finnish goalkeeper and Trick Shot master Lassi Hurskainen shows how to do a smartphone switch with a football.

 

Windows Phone Presents: Mountain Bike Sick Day (Direct Link)

(Please visit the site to view this video)

This amazing display of mountain biking in the Pacific Northwest was captured entirely on the Nokia Lumia Icon.

 

Enjoy

David

Read more here:
Cool Nokia and Windows Phone Adverts

May 26, 2014 · David Musgrave · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 246

Viewing previous month's reports in the web viewer … – MSDN Blogs

Blog Home · Share this · RSS for comments · RSS for posts · Atom. Search Form. Search this blog. Search all blogs. Tag Cloud. building blocks · Consolidations · CU6 · currency translation · Dynamics AX · Dynamics GP …

Continued here:
Viewing previous month's reports in the web viewer … – MSDN Blogs

May 21, 2014 · Jill Carter · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 171

Microsoft Dynamics GP 2013 R2 Feature of the Day Week 2

David Meego - Click for blog homepageThe Inside Microsoft Dynamics GP blog continues with the Microsoft Dynamics GP 2013 R2 Feature of the Day (FOTD) series.

Here are the previous features:

 

Have a look at the posts from Pam Misialek for week 2:

 

To see all the Feature of the Day posts use the link for the Feature of the Day tag

Enjoy

David

See more here:
Microsoft Dynamics GP 2013 R2 Feature of the Day Week 2

May 21, 2014 · David Musgrave · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 254

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

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. A look at the SY00100 table, confirmed the backup had been taken from an environment with a different system database name.

We had to formulate a plan of attack to address the issue, so we decided for a two step approach which involves:

a) Updating the SY00100 table to reflect the current system database, and

b) Execute the Database Maintenance utility to rebuild all stored procedures and functions, triggers, and views for all products installed in the environment – more about Database Maintenance utility here. After all, they certainly would be other objects referencing the former system database.

This approach resolved the issue completely and the partner could now access the company database in their development environment without having to restore the customer’s system database as well.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/


View original post here:
"Invalid Object Name ..SY01500" error after restoring GP 2013 company database in a different environment

May 19, 2014 · Mariano Gomez · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 448

GP2TheMAX Kindle Book now available on Amazon!

Six years ago, when I started blogging on GP2TheMAX, I intended one day to compile my favorite posts into book form and publish it.  Well, that day has come.  Thanks to the miracle of the interweb, electronic publishing, and Amazon, it is done.  I’ve gathered 125+ of what I think are the most helpful blog articles into GP2TheMAX – I Get GP Stuff Done.
 
Click here to get your copy!
The articles in the book are organized by module – General Ledger, Accounts Payable, Inventory, etc., with hyperlinks to each article from the Table of Contents to make it easy to navigate to your topic of interest.  Of course, I removed the articles from this blog that are contained in the book, else no one may have bought the cow when they could get the milk for free!
 
I want to thank a couple of people for helping me make this possible – Mariano Gomez, MVP, for pushing me to start blogging way back when, and Murray Fife, MVP and fellow IBIS colleague, for showing me the Amazon Kindle publishing ropes.
 
And of course, I have to thank each and every GP MVP out there, for without their help and guidance with numerous GP issues I’ve encountered, I would not have been able to stumble upon the solutions on my own.
 
My next endeavor is going to be to really dig into GP 2015 and blog about all the incredible features to come when it is released later this year.  Exciting times coming! 

Continue Reading:
GP2TheMAX Kindle Book now available on Amazon!

May 16, 2014 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 262