Training


SQL Table Copy Stored Procedure

Posted by Joe Jacob, Senior Developer on February 26, 2017

Do you ever get tired of typing 'Select * INTO SourceTable02417 FROM SourceTable' to make a quick backup of a SQL Sever table?  I did, so here's a quick and dirty little stored procedure to take care of that manual process. Here's how it works: When you call…

Read More

Finding Emails - Handy Search Tip

Posted by Joe Jacob, Senior Developer on February 26, 2017

Here's a HUGE time-saving tip when searching for an email in Microsoft Outlook and Office 365.   Who, what, and when are the key.  Just follow these simple syntax rules, and you'll be amazed how easy it is to find those emails. Replace Who with FROM: ​Replace…

Read More

Acumatica Version 6.0 AR Parent/Child Enhancements

Posted by Melissa Blassingame on February 13, 2017

If you already have Acumatica, you need to check these out!  If not, send us an email at Marketing@Crestwood.com and see Acumatica for yourself – it’s an amazing system.   In the latest release, Acumatica Version 6.0 there are three enhancements I am excited about. …

Read More

How to Increase the Account Number Length in Dynamics GP

Posted by Georgia Stewart on February 8, 2017

Every year, our support team comes across this question:  How do I change the Account Number Length in Microsoft Dynamics GP? It might be that your chart of accounts no longer fits your company's reporting objectives or suites your needs.  Whatever the reason, here's a handy…

Read More

Setting up a Custom Email Signature in Dynamics CRM 2016

Posted by Brenda Senger on February 2, 2017

We’ve been waiting for this feature.  It’s a customer request.  Microsoft finally added a way to set up your own custom email signature in the newest version of Dynamics CRM.  Yeah! Here’s step-by-step instructions: Navigate to the Options area under settings …

Read More

Setting a Datetime Value in Dynamics CRM 2016 Using C#

Posted by William Schroeder, Director of Development, IT on January 27, 2017

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.…

Read More

Customizing Acumatica

Posted by Jen Bieker on January 24, 2017

One of the top complaints we see from ERP solution users is that they can't add fields or make small tweaks to forms and windows, or that it is overly complicated to do so. And we all know how challenging it can be to wait for an overworked IT…

Read More

Helpful Storage Hints for SharePoint-enabled Storage & CRM

Posted by Ben Borger on January 20, 2017

If you use Microsoft Dynamics CRM, now referred to as Dynamics 365, and SharePoint, you will want to read this.  Did you know there are quick and easy ways to attach email correspondence and other files to your SharePoint library?  Here are some tips for working with the SharePoint-enabled…

Read More

Using SQL Stored Procedures as a Data Source in Scribe

Posted by Mike Giuffre on January 19, 2017

Did you know that you can use SQL Stored Procedures (SP’s) as a data source in a Scribe Insight integration?  You might have done something similar when you use SP’s as the data source for custom reports.  Using SQL Server as a data source…

Read More

How to Find Call History and Duration Information for Skype Calls

Posted by Joe Jacob, Senior Developer on January 18, 2017

If you use Skype for Business, you can always go in and look at your call history.  However, did you know, if you dig a little bit, you can also get the exact time, date and duration of the call?  There might be other methods of retrieving this…

Read More