Those in the fabrication industry have unique needs—both in the form of project management, materials planning, and contracts, often needing more than a traditional manufacturing-focused ERP can provide. In an industry like yours, change is frequent—whether those are design changes, contract changes, or anything of the like, you need to remain agile enough to adapt … Read more
When you look at ERP solutions, it pays to ask questions. You want to ensure that you make the right decision and find a solution that works for your business not only today, but in the future. For many businesses, the best place to start looking is the financial management module, the core of your … Read more
Recently working with a customer we were trying to give a user access to a TEST company in Microsoft Dynamics GP. When trying to switch to the test company, the user was getting the following error: “The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must … Read more
Are you trying to improve performance of Microsoft Dynamics GP without investing thousands more in hardware and infrastructure? Has your SQL database size started to grow out of control? Perhaps Inventory Reconcile, Check Links, or other maintenance tasks are taking a long time to run due to the growing data volume? Sounds like you need … Read more
Recently, I was asked by a client to list out the steps to run a Dexterity-based customization in Test or Debug mode. The client had indicated that he “has never been able to run” his customizations in Test mode and asked for my help. Since I have not had issues running the client’s GP2016 R2 … Read more
We recently got a call from a customer with a Management Reporter (MR) Dynamics 365 issue that I had not run into yet. It happened after the client had installed updates and rebooted their server. They weren’t sure what happened but MR started prompting everyone for a username and password when trying to run reports. … Read more
Many people use Scribe to connect their Microsoft Dynamics GP system to other business systems. With Scribe’s Dynamics GP Connector, you can build simple or complex integrations with Dynamics GP, whether that be through the standard business objects, or going directly to the tables and stored procedures. We have built many of these types of … Read more
I was helping a client and was trying to determine the problems with Integration Manager (IM). However, when I went to check the log files, I got an error message and couldn’t get to the log files to see the problems. Here is the IM Log Error: Within Integration Manager, I went to view the … Read more
This morning a client got this message on all their Dynamics GP 2018 clients. This is a new one to us, we haven’t seen this error in the past. (Note – this error could apply to almost any version of GP that supports Automatic Updates). “An available update may be required for your computer, but … Read more
The Error: While trying to access Dynamics GP2016 modified forms in the FORMS.DIC file, we were repeatedly denied access to the forms dictionary with the error message, “The modifier is currently unavailable because another user is editing resources in the forms dictionary.” We knew for a fact that no one else was editing the dictionary … Read more
Microsoft Dynamics GP Upgrade Methodology There’s a reason why our clients trust Crestwood Associates to upgrade their Dynamics GP systems to the latest version. It’s a complicated process and we’ve done hundreds of them. Upgrades can take anywhere from 30 to over 100 hours depending on the complexity of your system. So what are we … Read more
Have you noticed the Doc Attach button in some companies responds slow? We had a client with this problem. When they clicked the “Attach” button, there was a long delay for the dialog box to appear to allow selection of the documents to attach. We hadn’t heard of this happening and even an online search … Read more
Error and fix when your Management Reporter console crashes. This one is great! My client was having issues with the Management Reporter (MR) Configuration Console crashing as soon as you tried to open it, and the MR Process Service kept stopping after you would start it. I was also getting errors in the Windows Application … Read more
I’ve been waiting a long time for this. If you’ve had to split strings in SQL in the past, keep reading! Microsoft SQL Server 2016 now has a native solution available, meaning, you can supply a delimited string and join against it like a collection of rows. There have been many work-arounds for this over … Read more
CAUTION – If you’re using MR with the Legacy connection to Microsoft Dynamics GP, when importing a NEW company to MR, be careful. You want to make sure you check the boxes for “Skip Import” for all the existing companies that are setup if you are using multiple Building Block Groups (also known as Specification … Read more
Here are some easy SQL commands you can use for better grouping options. Quite often, I run into situations where I need to combine multiple values or descriptions into a column when it comes to reporting. Examples: There are a few SQL functions you can use to do this: CONCAT – allows you to concatenate … Read more
The Crestwood Development staff had a recent team sharing session. One of the things they went over were some great tips and tricks for SQL that we thought you might enjoy too. Index-Friendly Operators If you have indexes in your databases, using index-friendly operators can speed up searching. Indexes identify what data we really care … Read more
Problem: I ran into a unique issue today. A client had reset their SA password, and after doing so, they could no longer login to Dynamics GP or SQL with the SA password. The SQL SA account kept getting locked out. We determined this was being caused by the Management Reporter (MR) services. When trying to … Read more
Many of us have run across a situation where a SQL restore just takes FOREVER! Since I had some time on my hands, I decided to search and found this great blog post by Matt Slocum. Seriously, I waited well over an hour for a 58GB database to restore to SQL 2008 (and the restore never completed, … Read more
The .Net framework gives developers the powerful option of compiling assemblies targeted for the now-standard x64 platforms or legacy x32 platforms. This is not an issue for most modern software since the typical machine is based on 64-bit architecture and most assemblies are compatible with 64-bit systems. However, the challenge arises when compiling 64-bit assemblies … Read more
If you’re trying to deploy SQL Server Reporting Services Reports (SSRS) and it keeps failing, saying you don’t have permission, it might be because you have SQL Express. Dynamics GP Error Message: You do not have security access to the location where you want the reports to be deployed Report deployment with SSRS is NOT … Read more
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: FP: Couldn’t close table! An open operation on table ‘taxHistory_TRX’ failed because … Read more
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 customer who found their Dynamics GP system was locked up … Read more
Included in Microsoft Dynamics GP is the Professional Services Toolkit Library (PSTL). This adds a lot of powerful functionality to help you solve common business problems. One of the tools is the Inventory Site Combiner. It allows you to combine site/location codes without losing any data. Let’s say you created an inventory location and you … Read more