The Crestwood Associates Company Blog

Read about our latest insights and the latest Microsoft innovations

Fund Transfers in Acumatica

Posted by Mike Aichinger on May 8, 2017

In the Acumatica Funds Transfers window, you can transfer funds from one cash account to another and include related service charges.  Additionally, you can view the details of the recorded funds transfers. Funds can be transferred between accounts denominated to different foreign currencies. The system performs currency conversion by…

Read More

Breaking Changes in Major Web Browsers / Web Hosts

Posted by Jeff Williams, Dev Team Mgr on May 8, 2017

If you suddenly started having issues with websites (corporate/intranet/other) and/or have integration systems that have stopped working, read on as these issues might be the cause.   Let us know if you need assistance, email us at and one of our experts can…

Read More

Locking in SQL Server

Posted by David Gigear, Senior Consultant on May 4, 2017

Locking is a part of every SQL Server database.  It’s critical functionality and without it, we could not have multiple people working in the same database, at the same time.  It ensures data integrity, but can also cause some errors.   Example: I was assisting a…

Read More

Dynamics GP: Using SQL to Change Inventory Currency Decimal Places

Posted by Mike Gordon, CPA, MCP on May 4, 2017

A customer recently had an issue with the number of decimal places for the price of an item on an open Sales Order.  The item was incorrectly setup with 2 decimal places when it needed to be four.  Note your Item Number and your Order Number.  Is there…

Read More

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

Posted by Michael Broadmeadow, Senior Support Analyst on April 26, 2017

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…

Read More

Dynamics SL: Time-Saving Report Templates

Posted by Michael Broadmeadow, Senior Support Analyst on April 26, 2017

Creating a New Report Template from an Existing Template and How-to Delete a Report Template In Microsoft Dynamics SL, report templates are valuable time-saving features.  We use report templates as a starting tool when creating similar type of reports.  That way, we can reuse our parameters to run…

Read More

Microsoft Dynamics GP SmartList Window Not Showing or Blank

Posted by Mike Gordon, CPA, MCP on April 26, 2017

Recently, a client of mine had an issue where the Dynamics GP SmartList Window would not open or when it did, it was blank.  I found that this is a known issue, as the window settings in the DYNAMICS SY01402 table can become corrupt and cause the window to…

Read More

Dynamics GP – How to Pay a Partial Payment

Posted by Sean Casey, MCTS on April 25, 2017

Using Select Checks and Edit Check Batch I recently helped a client print partial checks in Microsoft Dynamics GP.  They needed to pay an invoice in multiple payments.  I’ve also run into this when someone needs to create a payment for a deposit, but had not…

Read More

Announcing - Positive Pay in Greentree

Posted by Colleen Schils, Client Account Manager on April 20, 2017

Do you pay your vendors with checks from Greentree? Do you want to avoid check fraud? Greentree version 4.7 provides the functionality to generate a Positive Pay file to send to your bank.  Implementing a positive pay system is an extremely effective way to prevent check fraud. Get up and…

Read More

Time Saving Keyboard Shortcuts

Posted by Jen Bieker on March 27, 2017

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…

Read More