Crestwood Blog

Georgia Stewart
Georgia Stewart

Dynamics SL: AP Voucher and Adjustment Batch is Out-of-Balance and Will Not Release

Have you ever run into this in Microsoft Dynamics SL?  You created a Voucher and Adjustment Entry (03.010.00) batch and the batch will not release. So, you look at the event log and find there’s a message indicating the batch is out of balance but it provides no further information.   Ugh, what do you do?  … Read more

Read More…

Jen
Jen

Time Saving Keyboard Shortcuts

Why do people use keyboard shortcuts?  I used to teach beginner computer classes and one thing that always confused people is the multiple ways of doing the same thing.  I always had a hard time answering that question, but over the years, I’ve found myself using more and more keyboard shortcuts because they do really … Read more

Read More…

Georgia Stewart
Georgia Stewart

Microsoft Dynamics GP: Changing Currency Decimal Place for an Inventory Item with Manufacturing

There are times you might need to change the number of decimal places for inventory items in Microsoft Dynamics GP Manufacturing.  For example: Items might have been set up incorrectly You might have started purchasing a product from a different supplier, or international supplier and with the currency exchange rates, you want to track 3 … Read more

Read More…

William Schroeder
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…

Mike Aichinger
Mike Aichinger

Creating a Company Tree

When setting up your Acumatica system, you need to make sure you set up a Company Tree.  Why?  Acumatica uses a hierarchy system for escalating items that need approval; such as: Time cards Requests Requisitions Sales orders Purchase orders This hierarchy system in Acumatica is based on the order of groups specified by the tree … Read more

Read More…

Tiffany Bennett
Tiffany Bennett

AP Payment Selection vs. Edit/Select Documents for Payment in Dynamics SL

Have you always wondered what the difference is between the AP Payment Selection and the Edit/Select Documents for Payment screens are for in Dynamics SL?  They both are used to select documents for payment in the Accounts Payable module, but what’s really the difference? The Payment Selection screen is actually a utility that is used … Read more

Read More…

Tiffany Bennett
Tiffany Bennett

Multiple Companies Report Not Pulling Data in MR

Imagine the following scenario in Management Reporter (MR).  A report runs fine when running it individually, for separate companies, with no tree.  However, when adding a tree that crosses multiple companies from different Dynamics SL application databases, the report gives no data.  How can this be? The cause of this is due to different CURYIDs … Read more

Read More…

Mary Lenehan
Mary Lenehan

MR CU16 & More

Many Dynamics SL users have been confused by Microsoft’s messaging around Management Reporter (MR). Here’s a question I’ve heard a few times lately: “I’m planning my Dynamics SL 2015 upgrade from Dynamics SL 2011, is it worth migrating to MR if it’s going away?” Here’s the low-down: MR is being sunset – meaning no new service packs (or cumulative updates … Read more

Read More…

Jen
Jen

Dynamics SL 2017 Updates and Hotfixes

Microsoft has recently released many updates and hot fixes.  If you haven’t been keeping up on these, you might want to take a look.  There have been many issues resolved with some of these.  You’ll have to log into your Microsoft CustomerSource account.  If you need help with that, just email us at Support@Crestwood.com. Here’s … Read more

Read More…

Joe Jacob
Joe Jacob

SQL Table Copy SP

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 this Procedure (PROC), simply use the following … Read more

Read More…

Joe Jacob
Joe Jacob

Quick Email Searching Tip

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 What with ABOUT: Replace When with RECEIVED: ​Here’s an example: … Read more

Read More…