Recently, Crestwood was asked three questions that pertain to Power BI in the cloud (the Microsoft SaaS offering) and how it compares to the on-premise (or cloud-hosted) Power BI Report Server solution. Both solutions enable Power BI reports and visualization construction by leveraging the power of Microsoft’s Power BI services, but there are notable differences … 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
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
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
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 .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
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
Which dictionary do I use if I have multiple versions of Microsoft Dynamics GP? If you are a Dexterity developer with many alternate Dynamics GP forms in your development dictionary, e.g., your development dictionary is Dynamics GP2013 RTM and the Dynamics GP client application dictionary is GP2013 SP1, which dictionary do you use? If the … Read more
Did you know you could hide a row on a SSRS report if all the fields on that row are blank? I found a lot of documentation on how to hide a text box, or even a row based a condition or calculation, such as blank, zero or null values. However, I didn’t see much … Read more
The below C# pseudocode will set a “Date and Time” attribute to a provided value using the Microsoft Dynamics CRM SDK framework. This part is very straightforward and can, in fact, be simplified by performing the type casting in one line rather than parsing via multiple lines. string sSourceValue = “12/01/2016”; string sDestField = <DateTime_Attribute>; … Read more
Recently, I came across an issue at a long time Microsoft Dynamics GP client. When they tried to go to the Receivings / Transaction Entry window via Transactions > Purchasing menu, nothing would happen. It would not open, even though the option was present in the menu. Additionally, there was no error message and it didn’t … Read more
Did you know that you can use SQL Stored Procedures (SP’s) as a data source in a Scribe Insight integration? You might have done something similar when you use SP’s as the data source for custom reports. Using SQL Server as a data source in Scribe lends all the power and functionality of SQL Server … Read more
Microsoft includes a license with Dynamics GP for their “Swiss Army Knife” set of tools called the Personal Services Tools Library (PSTL). One of these tools is Company Copy. It is used to copy the setups from one company to a new one. This is very useful for new Dynamics GP companies, implementations, or for … Read more