SRS codes
Avatar photo
William

Passing SSRS Multi-Value Parameters in Reports to Sub-reports

Microsoft SQL Server Reporting Services (“SRS” or “SSRS”) have been around for the better part of two decades, first hitting the streets in early 2004.  Over the past 16+ years, many articles and blog posts have been written about passing multi-value parameters between reports using a combination of the JOIN and SPLIT functions.  These work … Read more

Read More…

Microsoft Power Automate
Avatar photo
William

Automate Repetitive Desktop Tasks With Power Automate Desktop

Good news! If you are an existing Windows 10 user, you can now download Microsoft Power Automate Desktop for free! Microsoft made this download available on March 2nd, 2021. Why Power Automate Desktop? Power Automate Desktop (formerly Microsoft Flow) will allow you to automate repetitive tasks such as mouse clicks and keyboard taps in much … Read more

Read More…

Avatar photo
William

How to Connect Business Central to External Systems (API Set Up)

The icing on the cake of a great ERP system lies in its customizability. APIs allow users to connect Microsoft Dynamics 365 Business Central to external services, eliminating the need for constant back-and-forth between systems. With Dynamics 365 Business Central, users are able to connect Web Services using a point-to-point connection between their ERP and … Read more

Read More…

Dynamics GP Error - Journal Printing
Avatar photo
William

Dynamics GP Error: Journal Printing Interrupted

A “Journal Printing Interrupted” error while posting sub ledger (AP, AP, Inventory, et cetera) transaction batches in Microsoft Dynamics GP can be among the most frustrating and cryptic error messages an ERP system can generate.  This error only occurs during the posting process and generally is not manifested when a batch edit report is generated, … Read more

Read More…

Power BI
Avatar photo
William

Power BI Report Server or Power BI SaaS: which is right for me?

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

Read More…

Avatar photo
William

Better Grouping with Easy SQL Functions

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

Read More…

Avatar photo
William

COM Interoperability on x64 Systems

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

Read More…

Avatar photo
William

Locking in SQL Server

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

Read More…

Avatar photo
William

How to Change an Inventory Site in Dynamics GP

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

Read More…

Avatar photo
William

Dexterity Developer Tip of the Day

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

Read More…

Avatar photo
William

Setting a Datetime Value in Dynamics CRM 2016 Using C#

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

Read More…

Avatar photo
William

PSTL Company Copy for Dynamics GP

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

Read More…