Crestwood Blog

Georgia Stewart
Georgia Stewart

Dynamics GP Errors Couldn’t Close Table and Other Connection Issues

Have you ever worked in Dynamics GP and encountered the “FP: Couldn’t Close Table!” or “Open Operations on File” errors when trying to close out of Dynamics GP? Why might this happen? The reason why these errors occur is usually that something is “interrupting” a process assigned to your machine as it closes (or at … Read more

Read More…

Tiffany Bennett
Tiffany Bennett

Using Professional Services Tools Library (PSTL) To Change Key Fields in Dynamics SL

With the release of Dynamics SL 2011 and greater, Microsoft includes a free tool to change key fields in the SL database.  It’s called PSTL (Professional Services Tools Library).  You can use this tool to modify or merge Vendor IDs, Customer IDs, Inventory Items, Accounts, Subaccounts, and many more.  It changes all tables, including transactions … Read more

Read More…

Misty Galbreth
Misty Galbreth

How to Fix a Closed Year with an Incorrect Posting Type in Microsoft Dynamics GP

It happens to everyone.  You close your fiscal year in Microsoft Dynamics GP and then, when going through your year-end reporting, you discover that one or more General Ledger accounts were closed with an incorrect Posting Type*.  That means your Retained Earnings either are over or under stated. Fortunately, beginning with Microsoft Dynamics GP 2013 … Read more

Read More…

Sean Casey
Sean Casey

Paid Transaction Removal for Dynamics GP Receivables

The paid transaction removal tool is used to transfer paid sales transactions to history. It is also used to consolidate balance forward accounts. It consolidates the balance forward transaction amounts and adds the total to the noncurrent aging period. Paid transaction removal will speed up receivables processes, inquiries and windows should open more quickly. Also, … Read more

Read More…

Georgia Stewart
Georgia Stewart

Display a Currency Symbol on the Toolbar in Dynamics SL

Microsoft Dynamics SL allows you to customize buttons on the toolbar.  One of the most useful addition is to add the currency symbol.  One thing to note, if you’re not using currency manager, the button will be greyed out or inactive. Here’s how: Create a folder called currency in Microsoft Dynamics\SL\Application. Place the icon file … Read more

Read More…

Brandon Richards
Brandon Richards

Dynamics GP Network or Profile Errors, but Not – Mystery Solved!

This is a good one for all you Microsoft Dynamics GP administrators!  We have gotten some calls about network or anti-virus type errors in Dynamics GP, but the normal fixes just don’t work. The Errors: Here are the Dynamics GP errors we encountered: FP: Couldn’t close table! An open operation on table ‘taxHistory_TRX’ failed because … Read more

Read More…

Melissa Blassingame
Melissa Blassingame

Emailing Customer Invoices & Vendor PO’s from Acumatica

I help many customers set up email functionality in Acumatica so they can email invoices to customers and PO’s to vendors.  There are 3 basic parts: Properly configure email functionality in Acumatica Set customer properties to receive emails Set vendor properties to receive emails Click on each step to view/download the PDF instructions.  If you … Read more

Read More…

Jen
Jen

Growth activities that can be life (and tax) changing

Growth isn’t a one-size-fits-all approach. In fact, companies expend a great deal of energy and resources deciding which pursuits will move the needle the furthest toward achieving specific goals, and where to prioritize their time and investment. Oftentimes sales and use tax gets left out of this equation, especially when it doesn’t appear to directly … Read more

Read More…

Christine Jacob
Christine Jacob

What’s new in Acumatica 6.x – Part I

Check out all the new, time-saving features in Acumatica 6.x.  No matter what industry you’re in, there’s something new in Acumatica for everyone. Finance Distribution CRM And in the platform Here’s a highlight of Acumatica new features we know you’ll want to have: Finance: Approval of Accounts Payable Documents – Set single or multiple approvals … Read more

Read More…

Mike Aichinger
Mike Aichinger

Fund Transfers in Acumatica

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 using the base currency and the … Read more

Read More…

David Gigear
David Gigear

Locking in SQL Server

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 customer who found their Dynamics GP system was locked up … Read more

Read More…

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…