I’m excited and honored to be presenting “Explore Your GP Reporting Options” session at the upcoming GPUG Amplify conference in Chicago on March 20, 2018. I invite you to join hundreds of other leaders and learn more about Reporting, Functional, and Executive Leadership with Dynamics GP at its focus. Amplify is the annual conference sponsored … Read more
Microsoft Dynamics GP – How to Get a List of Users and Access
Sometimes you need to know what access users have in Microsoft Dynamics GP. Maybe for an audit or just a routine cleanup of your system. Luckily, there are some pre-loaded or ‘canned’ reports in Dynamics GP that you can use. How to Access the User Security Reporting: To access the User Security reports, you first … Read more
5 Exciting New Features in Microsoft Dynamics GP 2018
We have many Crestwood clients planning to upgrade to Dynamics GP 2018 in the first quarter of 2018. You’ll want to consider upgrading too, especially if you are on Dynamics GP 2013 because mainstream support ends in April of 2018. This means no more updates, including year-end and payroll. Here’s an overview of the new … Read more
Dynamics GP: Error during Payroll Year-end Update
We have gotten a couple support calls about an error occurring while running the Dynamics GP utilities after installing the payroll year-end update. Error The following SQL statement produced an error: exec w fDeployClrAssemblies [Microsoft][SQL Server Native Client 10.0][SQL Server]Assembly ‘system.directoryservices, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.’ was not found in the SQL catalog. This error is caused … Read more
Crestwood Named a 2017 VAR Star
Crestwood has been named to the 2017 Bob Scott’s VAR Stars list for the fourth year in a row. The list, which has been published since 2009, touts a variety of high profile firms and recognizes factors such growth, industry leadership and recognition, and innovation. “Each year, 100 VAR Stars are picked from the best … Read more
Microsoft Dynamics GP Document Attach Button is Slow
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
Crashing and Connection Errors with Management Reporter Console, Dynamics GP, and SQL
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
Microsoft Dynamics GP 2018 New Doc Attach Feature
It’s here! Released December 1, 2017, Dynamics GP 2018 has finally arrived. There are many great new features available and here are the ones I’m most excited about. First, all the new Document Attach features. We’ve seen customers use this feature for years now, but in the new version, you can now attach to the … Read more
Mouse Lagging on Remote Connections?
Most of the time I work remotely. It saves me travel time and saves my clients money. I’m usually connecting to client systems with various VPN’s, etc. Once in awhile, when I’m VPN’d in somewhere, my mouse acts weird. It moves very slowly, like it’s underwater. I found a quick fix – here’s what I … Read more
SQL Split String Option
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
Management Reporter (MR) and Dynamics GP Legacy Connection – Caution When Importing a New Company
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
Free Benefits for Dynamics SL Users
Are you using Microsoft CustomerSource to enhance your Microsoft Dynamics SL experience? If not, you’re missing out on some great features! This is the place to go for access to documentation, the Dynamics SL support community, software downloads and up-to-date information about your system. Access to Microsoft CustomerSource is covered by your annual enhancement plan. … Read more
Microsoft Power BI Training Resources
Microsoft Power BI – it’s been the buzz for a while now, but maybe you haven’t found the time to dig through all that information and try it out yet. We get it; there is so much out there that it can be overwhelming. Download our free Power BI Training Resources, packed full of links … Read more
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
Dynamics SL Year-End Checklist
Download our free checklist for closing 2017 in Microsoft Dynamics SL. The checklist is full of essential information and general guidelines that can be combined with your internal company processes. Webinar & Support: If you missed our Dynamics SL Year-end Webinar on December 19th, don’t worry, you can watch the recording here. If you have … Read more
10 TIPS FOR REPORTING FINANCIALS TO THE BOARD
Have you found yourself spending hours preparing detailed reports for a Board meeting only to have them glanced at and tossed aside? Yeah, us too. So we thought we would put together our top tips that will ensure your reports are the highlight of the meeting. Tip #1 Know Your Board Most boards bring a … Read more
Payment Application in Dynamics SL Made Easy with Crestwood’s National Accounts
Do you receive checks from one customer to pay for multiple customers in Microsoft Dynamics SL? Maybe you simply wish the Payment Application Screen in Dynamics SL was more user friendly? Then consider Crestwood’s National Accounts Module for Dynamics SL. We make payment application easy by adding in multiple sort options and an Auto-Apply feature. … Read more
Start Preparing for 2017 Year-end with Dynamics GP
The 2017 calendar year-end is approaching and Microsoft is planning the release of the Dynamics GP year-end update for mid to late November. As we begin thinking about the end of 2017, some topics require planning and decision-making. Download our guide below and review the checklist items to make sure you’re ready to close out … Read more
Microsoft Dynamics GP – Closing the Year Information
Before Closing Your Year, Check Your Account Posting Types Closing a fiscal year in Microsoft Dynamics GP when you have a General Ledger Posting Type marked incorrectly can be a hassle. Either you have a Balance Sheet account marked as Profit & Loss or you have a P&L account marked as a Balance Sheet account. … Read more
What ERP Buyers Want in our Cloud-first World
The ERP landscape has shifted from traditional, on-premise client/server deployments to software-as-a-service, ERP in the cloud. Buyers have realized this shift has major benefits for their business, including: Scalability Reliability Elasticity Cost Savings Gartner www.gartner.com projects huge growth of core ERP systems in the cloud by 2025. IT leaders also say maintaining hardware, software and … Read more
Using High Def 4K Monitors in Remote Dynamics GP Hosted Systems
If you have one of the newer 4K monitors, have you run into issues with super small font size? I recently ran into this with a client who was using a newer Ultra 4K monitor when accessing Microsoft Dynamics GP (newer supported versions) through a remote Desktop Environment. Problem: While running queries in Dynamics GP, … Read more
The #1 Hack to Get More from your Work Day
There are tons of articles on the internet about multi-tasking, and we all do it to varying degrees. However, the research, not to mention common sense, points to the fact that you are better off focusing on one task at a time. Clutter is the Mind Killer Have you ever stood in front of your … Read more
Acumatica – Create a Separate Logo for Your Reports
Sometimes, it’s the little things we get excited about. This is definitely one of them. Acumatica now has a new feature so that you can have two different logos: One for your Acumatica interface The other for your Acumatica reports It might not sound like a big deal, but I’ve had issues with sizing report … Read more
Variance Presentation in Management Reporter
In your Management Reporter (MR) reports, have you experienced an issue where the favorable or unfavorable variance amounts between actuals and budgets in an income statement aren’t presented correctly? A favorable sales variance may be incorrectly presented as a negative amount and the expense may be presented correctly or vice versa. A way to overcome … Read more