KTL Blog

Insights and News from KTL Solutions.

Featured

Recent

Solving Issues with Migrating from FRx to Management Reporter

Have you had issues when trying to run the migration wizard from FRx to Management Reporter? When opening your row formats to validate, did you notice that you didn’t have any accounts in the link to financial dimension column?  If this has happened to you, it is most likely due to the use of account sets in FRx.  If you’re in row formats in FRx, you are using account sets which do not migrate into Management Reporter.  If this happens, what are your options to fix your reports?

Read More »

Business Portal 6.0 Released for Microsoft Dynamics GP 2013

Microsoft has released Business Portal 6.0 for Microsoft Dynamics GP 2013.  This release supports on SharePoint Server 2010 or SharePoint Foundation 2010.  Business Portal 6.1 will be released later this year and will support SharePoint 2013.

Business Portal is a web-based app that provides access to Dynamics GP data to users who don’t have access to the Dynamics GP application.

Read More »

My SQL database server needs an oil change. (Part 1)

The recommended mileage on a typical car in America to get an oil change is every 3,000 miles.  So that means a lot things.  Good… clean oil is absolutely crucial so that engine parts continue to cycle properly.

Not to mention the other important parts and services like an air filter, gas treatments, cables, wires, and spark plugs that are part of the normal maintenance on the very machine on four wheels that YOU (Mr. and Mrs. IT folks) place your children in to get to point A and point B.

Read More »

LIVE FROM: Empower the User Conference

9:23 AM

The KTL Solutions Empower the User Conference is about to kick off momentarily with the Keynote presentation by Microsofts own Steve Demming.  I would like to thank our sponsors AvalaraDi CentralIntegrity DataKwiktag,ReQlogicSalesPad Solutions, and Solver as well as are record setting guest attendance for being here today as we conduct our 7th annual User Conference.  Stay tuned here as I bring you a live view of todays sessions and presentations.  

Read More »

The 8th Annual Empower the User Confernece: LIVE

Welcome to this year’s live streaming blog of the eighth annual Empower the User Conference sponsored exclusively by KTL Solutions.  This year we have one of the most exciting lineups of presenters to date.  Amy Kennan of MyAppsAnywhere, Randy Chung of OfficePro, Doug Johnson of Acumatica, and Nills Rasmusen of Solver are just some of the many presenters at this year’s event.  Let’s not forget GP Fully Loaded delivered by the President and CEO of KTL Solutions, Timothy Lally, and a special guest from Microsoft, Mr. Steve Demming. Keep checking back as we bring you updates on presentations, pictures of the event, and some thoughts from our many attendees at this year’s Empower the User Conference.

Read More »

KTL User’s Conference – A First Time Perspective

Having been in the Microsoft Dynamics world for more years than I care to admit, I have attended more than a few Partners Users Conferences in the past.  My general experience is that they were noble attempts to sell products and services under the guise of a “workshop”.  Attendees were usually newbies to the Dynamics world or were veteran clients harangued by the management of the conference promoter into attending and speaking about the merits of the partner.

Read More »

Improving your SQL Server’s performance – Part 3

In Part 1 of this blog series, we outlined the importance of creating a good starting point for performance tuning on your SQL Server  by establishing a baseline for your server’s current performance.  

In Part 2, we covered how to enable Instant File Initialization and adding additional TempDB files to your TempDB database. 

As a conclusion to those articles, we will look at the effects of those changes by running a simple GP2010 Sales Order processing batch posting. To run the test, I create a virtual server with SQL 2012 using the default setting and GP2010 SP2. I made one change to the default to limit SQL server to only use a max of 12GB of RAM since I was running GP2010 and SQL on the same image.  Below are the specs of the server

Read More »

Find Tables in SQL with Particular Fields

There are many tools that can be utilized to troubleshoot data in Dynamics GP.  One of the most powerful tools is scripting with SQL server.   It should be noted that scripting with SQL server can manipulate data and should only be used by users who know how their scripts will affect Dynamics GP.

Read More »