Microsoft Dynamics GP

Dynamics GP Errors Couldn’t Close Table and Other Connection Issues

Posted by Kraig Kumlin, Sr. Support Analyst on June 7, 2017

Have you ever worked in Dynamics GP and encountered the “FP: Couldn’t Close Table!” or “Open Operations on File” errors when trying to close out of Dynamics GP? Why might this happen? The reason why these errors occur is usually that something is &ldquo…

Read More

Learn the Basics of Dynamics GP SmartLists

Posted by Misty Galbreth, Support Analyst on June 6, 2017

The SmartList feature in Microsoft Dynamics GP is everyone’s favorite feature.  It makes compiling useful data easy for everyone.  To help you get started, download our PDF guide  for step-by-step directions on these basic must-knows: Where are SmartLists Rename a column Increase the Number of…

Read More

How to Fix a Closed Year with an Incorrect Posting Type in Microsoft Dynamics GP

Posted by Misty Galbreth, Support Analyst on June 6, 2017

It happens to everyone.  You close your fiscal year in Microsoft Dynamics GP and then, when going through your year-end reporting, you discover that one or more General Ledger accounts were closed with an incorrect Posting Type*.  That means your Retained Earnings either are over or under stated.…

Read More

Five Questions on Scribe Online Training with Crestwood’s Newest Certified Pro, Brandon Richards

Posted by Donna Krizik on May 25, 2017

At Crestwood we are amazed and impressed by the pace of innovation that our publishers are driving.  Today, the Cloud is much more than just a buzzword for our client’s critical business applications. Rather it is now a key technical standard for an ever increasing number of…

Read More

Error Creating New SQL User - The Server Principal Already Exists

Posted by Tiffany Bennett, Senior Consultant on May 24, 2017

You are trying to create a new SQL user, and you receive the following message, “the server principal ‘xxxx’ already exists’ as below: Ok, maybe that user already exists.  You search SQL Management Studio, but cannot find the user associated with any databases or under…

Read More

Dynamics GP Network or Profile Errors, but Not - Mystery Solved!

Posted by Brandon Richards, Implementation Manager on May 24, 2017

    This is a good one for all you Microsoft Dynamics GP administrators!  We have gotten some calls about network or anti-virus type errors in Dynamics GP, but the normal fixes just don’t work.    The Errors: Here are the Dynamics GP errors we encountered:…

Read More

Dynamics GP: Processing a Credit When Using a Credit Card to Pay Vendors

Posted by Sean Casey, MCTS on May 24, 2017

Here’s how to process a credit when using a credit card to pay vendors in Microsoft Dynamics GP. Let’s say you have entered an invoice in a vendor’s account and entered the amount in the credit card field. This will move the document to…

Read More

Growth activities that can be life (and tax) changing

Posted by Jen Bieker on May 12, 2017

Growth isn’t a one-size-fits-all approach. In fact, companies expend a great deal of energy and resources deciding which pursuits will move the needle the furthest toward achieving specific goals, and where to prioritize their time and investment. Oftentimes sales and use tax gets left out of this equation,…

Read More

Breaking Changes in Major Web Browsers / Web Hosts

Posted by Jeff Williams, Dev Team Mgr on May 8, 2017

If you suddenly started having issues with websites (corporate/intranet/other) and/or have integration systems that have stopped working, read on as these issues might be the cause.   Let us know if you need assistance, email us at and one of our experts can…

Read More

Locking in SQL Server

Posted by David Gigear, Senior Consultant on May 4, 2017

Locking is a part of every SQL Server database.  It’s critical functionality and without it, we could not have multiple people working in the same database, at the same time.  It ensures data integrity, but can also cause some errors.   Example: I was assisting a…

Read More