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
A Simple Way to View Tables with a URL in Dynamics 365 Business Central
Here is a really interesting tip! A customer of ours was looking to add the Vendor Order Number field to their Posted Invoices list. After researching, we found that it potentially involved connecting a separate table. We thought a customization was in order, but then I learned about an interesting workaround – editing the URL to … Read more
Three of Crestwood Associates’ Add-On Products for Acumatica are Certified for 2021 R1
Acumatica has recognized Crestwood’s Lockbox Processing, 360° Sales View, and Collections Management products for quality and usability with their latest version Schaumburg, Ill. and Orlando, Fla. – May 7th, 2021 Crestwood Associates is proud to announce the first slate of add-on products (Lockbox Processing, 360° Sales View, and Collections Management) have been recognized as Acumatica-Certified … Read more
Three Reasons to Attend Acumatica Summit
Acumatica Summit 2021 is fast approaching! With the end of the pandemic in sight, our team is thrilled to be taking part in the first live event in over a year and a half. Originally scheduled for January and then April, Summit is now set for July 18-23 at the Wynn Hotel on the Las … Read more
The Latest in Acumatica CRM
We don’t need to tell you the importance of a good CRM system. Customer Relationship Management is a fairly new module in Acumatica, and each release comes with a set of new features. We’re going to look at the latest updates below. Business Accounts New Layout of Business Accounts Form The Details tab has been … Read more
Three Favorite New Microsoft Teams Features
Microsoft has been really getting down to business with creating new features to help our daily lives move smoothly. Researching content for my next blog I came across three new features for Teams that you will like. Recap History Status Did You Miss Your Meeting? Here’s a Recap! Microsoft Teams now offers participants a total … Read more
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
How to Reprint a Previously-Posted Bank Reconciliation (Business Central Quick Tip)
“Help! I’ve previously posted and printed a batch in Dynamics 365 Business Central but I need to reprint some of the reports from my bank reconciliation!” No fear! Crestwood is here. Below are the steps to reprint a previously-posted bank reconciliation. First, navigate to the top ribbon and select Cash Management > Bank Accounts. Highlight … Read more
Accelerate Your Journey to AP Automation in Dynamics GP with KwikTag
Below is a guest blog written by our friends over at KwikTag. Join us for a quick 30-minute webinar about this topic on May 6th! One of the biggest misconceptions when it comes to Accounts Payable automation is that a business is “too small” to go digital – either they don’t have enough team members, … Read more
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
2021 Training and Documentation for Dynamics 365 Business Central
As I wrote in my last blog about the evolving user groups, help for Business Central is always out there – you just need to know where to look. Whether the help below is still Greek to you, OR you just want a little extra guidance, check out Crestwood’s premium BC training program. We’re calling … Read more
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
Acumatica’s Missing Piece: Crestwood’s Add-On Product
It is no secret that Acumatica is one of the best ERP systems available for small- to mid-sized businesses. However, even the BEST systems cannot possibly solve every single problem. And that is where the best VARs come in. Crestwood’s years of experience with accounting software has given our team the insight to know exactly … Read more
Goodbye Dynamics User Groups – Hello Dynamic Acceleration Cloud
As an old-school Great Plains accounting veteran (my father was one of the very first partners in the late 70s), I’m a fan of user groups. GPUG, DSLUG, and even the three D365UGs (if I can figure out which one is which). In particular, the discussion threads are especially helpful. I trust feedback provided in … Read more
Black Boxes Update (Bug Fix for Dynamics GP Report Writer)
As we mentioned in a previous blog, users printing from Report Writer (including checks!) were experiencing an error: black boxes instead of images. This problem spanned across a number of Microsoft products. (Photo credit: Justin Sutton, Dynamics GP Support Team) The Solution The fix is here! The latest update (released March 18th, 2021) includes the … Read more
A Change of Scenery with Dark Mode in Microsoft 365
Do you find yourself lost in space looking at the same screen day in and day out? Want to change it up a bit? Give it fresh new look and feel? Microsoft 365 has enabled Dark Mode in its suite of office products. So instead of constantly looking at a big ol’ white screen you … Read more
So Long, CustomerSource: What’s New for Microsoft Help Documentation
As we stroll through the tech graveyard, fondly remembering obsolete systems and tools (we hardly knew you, Skype for Business!), we notice that a fresh plot of land has been tilled, and the tombstone reads “Microsoft CustomerSource.” Here’s what happens when you click on your old CustomerSource bookmarks: Yes, that’s right – CustomerSource is now … Read more
Cybersecurity Simplified: Ransomware
Ransomware is malicious software that blocks access to a computer system or files unless a sum of money is paid. Ransomware twists the power of encryption against you. Encryption should protect your data and files, but ransomware uses it to take files hostage. This means being locked out of your documents, spreadsheets, photos and videos, … Read more
Our Three Favorite New Features in Dynamics GP 2020 Version
#1 – Automate Dynamics GP Check Links Utility With the latest release of Dynamics GP, you can set up a schedule to run Check Links outside of normal business hours. You are now able to run the processes without having to manually select the Check Links process. This process uses the Report Scheduler setup and functionality, so … Read more
Warehousing Levels in Business Central (a Deep Dive into the Various Location Tiers)
In Microsoft Dynamics 365 Business Central, there are various tiers to the Warehouse or Distribution management. This blog post can be used to get a general understanding of the different tiers as Microsoft defines them. Something to keep in mind: “locations” in Business Central (synonymous with “warehouse” in the common vernacular) can be set up … Read more
Important GP Bug Report: Black Boxes and Dynamics GP Report Writer
What Happened? Many users are reporting a problem with Microsoft Dynamics GP after the latest update: when you attempt print using Report Writer reports, black boxes instead of images appear on the reports. The following Windows updates (all from March) were affected: “KB5000808” “KB5000809” “KB5000802” “KB5000803” “KB5000812” “KB5000822” This only affects Report Writer reports (Word … Read more
Microsoft Dynamics GP 2020 New Features
Microsoft has outdone themselves again with all the customer requested and new features in the latest 2020 version of Dynamics GP. Along with all the enhancements, they have screenshots, detailed information, and user comments with each and every feature. Below, are the links to the individual pages. Financial Enhancements Non-Employee Compensation (NEC) for 1099 form … Read more
What’s Coming: Acumatica 2021 R1
Save Time with Superior Usability Acumatica continues to enhance the user interface and flexible workflows. In 2021 R1, there is new mobile image recognition capabilities, better side panels, improved notifications and dashboards. Create CRM contacts from business cards using mobile image recognition AP Document recognition inventory ID search Navigate to external URLs from generic inquiry … Read more
A First Look at Dynamics 365 Business Central 2021 Wave 1
Gone are the days of once-per-decade upgrades for Microsoft Dynamics products – Business Central is committed to twice-yearly updates called “waves.” April 1st, 2021 marks the general release of the latest wave – 2021 wave 1. Microsoft is promising to bring hundreds of new features in this release, spanning across all the Dynamics 365 applications, … Read more