SRS codes
William Schroeder

Passing Multi-Value Parameters in SRS/SSRS 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
William Schroeder

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…

Power BI
William Schroeder

Moving from Crystal Reports and SSRS to Power BI

We have been asked by many clients about moving their existing business intelligence solutions to the modern Microsoft Power BI platform, and most of those inquiries involve some combination of Crystal Reports and SQL Server Reporting Services (SSRS) reports.  One question we are often asked in those discussions is, “how do we migrate our existing … Read more

Read More…

William Schroeder

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…

""
William Schroeder

You NEED Power Platform… and Here’s Why! (Webinar Recording)

Did you miss the Power Platform webinar? Have no fear, we recorded it. Click the button below to watch now! Watch Recording Here   If you have a computer (and I suspect you do!) you may have heard about Power Platform. Then you may have scrolled by, thinking you don’t have a use for it. … Read more

Read More…

Dynamics GP Error - Journal Printing
William Schroeder

Dynamics GP Error: Journal Printing Interrupted

A “Journal Printing Interrupted” error while posting subledger (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, which … Read more

Read More…

Power BI
William Schroeder

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…

Coding
William Schroeder

Dynamics GP Modifier Unable to Access Dictionary Resources

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

Read More…

William Schroeder

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…

William Schroeder

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…

William Schroeder

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…

William Schroeder

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…

William Schroeder

Nothing Happens When I Click on the Dynamics GP Menu

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

Read More…