Crestwood Blog

Avatar photo
Mike

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

Read More…

Avatar photo
Lauren

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

Read More…

Avatar photo
Brandon

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

Read More…

Hand on mouse
Avatar photo
Joe

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

Read More…

Avatar photo
Brandon

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

Read More…

Avatar photo
Brandon

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

Read More…

Avatar photo
Lauren

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

Read More…

Avatar photo
Lauren

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

Read More…

Avatar photo
Brandon

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
Lauren

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

Read More…

Payment
Avatar photo
Colleen

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

Read More…

Avatar photo
John

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

Read More…

ERP
Avatar photo
Brian

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

Read More…

Avatar photo
Joe

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

Read More…

Avatar photo
Mike

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

Read More…

RSS23
Follow by Email0
Facebook16
X (Twitter)34
LinkedIn47
Share