AR1
Dynamics GP

How to Set Up an Accounts Receivable Roll Forward Report in Dynamics GP

Do your bank or auditors need an AR roll forward report? Many times I work with businesses who do asset-based borrowing and this report is required. The AR Roll Forward report details all the transactional accounts receivable activity in a period, with the beginning and ending balances tying back to

by Jamie
Read More
Dynamics GP

Running Dexterity Applications in Debug Mode (Dynamics GP)

Recently, I was asked by a client to list out the steps to run a Dexterity-based customization in Test or Debug mode. The client had indicated that he “has never been able to run” his customizations in Test mode and asked for my help. Since I have not had issues

by Brandon
Read More
M1
Dynamics GP

Is Management Reporter Dynamics 365 Prompting You for a Username & Password?

We recently got a call from a customer with a Management Reporter (MR) Dynamics 365 issue that I had not run into yet. It happened after the client had installed updates and rebooted their server. They weren’t sure what happened but MR started prompting everyone for a username and password

by Brandon
Read More
Scribe1
Dynamics GP

Dynamics GP Scribe Online Connector Setup

Many people use Scribe to connect their Microsoft Dynamics GP system to other business systems. With Scribe’s Dynamics GP Connector, you can build simple or complex integrations with Dynamics GP, whether that be through the standard business objects, or going directly to the tables and stored procedures. We have built

by Brandon
Read More
IM1
Dynamics GP

Integration Manager: Errors When Trying to View Integration Logs

I was helping a client and was trying to determine the problems with Integration Manager (IM). However, when I went to check the log files, I got an error message and couldn’t get to the log files to see the problems. Here is the IM Log Error: Within Integration Manager,

by Brandon
Read More
PO1
Dynamics GP

Dynamics GP: New Item Cost Not Showing on Purchase Order  

I recently helped a customer solve an issue with their Purchase Order (PO) in Microsoft Dynamics GP.  They had changed the cost on an inventory item, but the new item cost was not showing up on the PO.  Why is this?  Here’s what happened First, my customer had changed the

by Mike Gordon
Read More
CC1
Dynamics GP

Save 10-25% Processing Credit Cards in Dynamics GP with iTransact

I recently had a couple of my clients complain about their merchant services for processing credit cards in Microsoft Dynamics GP, so I decided to look at alternative solutions. Since Crestwood is part of the BDO Alliance, I asked who they might recommend. iTransact merchant services was at the top

by Kayla
Read More
Security Resource1
Dynamics GP

Security Resource GP View in GP 2016 and GP 2018

Recently, one of our clients upgraded to Microsoft Dynamics GP 2018 and ran into an issue with a view no longer working.  They used a view in a SmartList to show security roles, security resource details, and tasks assigned to each user in a Dynamics GP company.  However, after the

by Dan Milani
Read More
PagliaCleaning1
Dynamics GP

Use SSRS to Save Time Getting Dynamics GP Reports for Your Audits

Most people export a .csv file of their Trial Balance Detail report right from Microsoft Dynamics GP for their audit team.  However, you usually end up spending more time than you would like cleaning it up, re-formatting, and manipulating it first.  Sound familiar? Here’s an easy solution: Export using SSRS Instead

by Mike Gordon
Read More
Table1
Dynamics GP

Options When Integrating Data to Microsoft Dynamics GP

Our clients often ask about the best data integration options with Dynamics GP.  While every client’s business requirements are different, there are still several best practices that our team considers when working with our clients.   First, we always make sure that we understand the business requirements for the integration. This

by Colleen
Read More
GS 1
Dynamics GP

Using SmartList to Display Attachments in Dynamics GP

Which vouchers have attachments? In Dynamics GP, the Document Attach feature allows you to connect documents such as requisitions, credit reports, and images to master records and transactions. An easy way to quickly see whether a payable voucher has an attachment is to create a SmartList.  Read on to find

by Dan Milani
Read More
Webinar Graphic 2018 V2
Dynamics GP

Webinar: Using Workflows in Dynamics GP

Wednesday, July 18, 2018 11:00 AM - Noon (CST) Register Here!   Join us for a free, hour-long webinar and learn how to automate your business processes to save time and improve efficiency with Workflows in Microsoft Dynamics GP. Pam from Crestwood will show you how to set up and

by Kayla
Read More
ProfAdv1
Dynamics GP

Using Professional Advantage for Collections Management in Dynamics GP

I use Professional Advantage Collection Management for Dynamics GP every day and have found a couple of features that are very useful and time-savers.  Here are two helpful tips you need to try.   Last Payment Made View First, I am always looking at the view showing me the last

by Andrea
Read More
GPGixedAssets1
Dynamics GP

You Should be Using Fixed Assets in Dynamics GP

Are you using the Dynamics GP Fixed Asset module?  You should be.  You own it as part of the Starter Pack (if you are on GP 2013 or later).  The Dynamics GP Fixed Asset module can do everything you need for your depreciable and non-depreciable assets. Here are 9 reasons

by Mike Gordon
Read More
RevenueDeferrals1
Dynamics GP

Revenue Deferrals Module in Dynamics GP

If you are still using Excel Workbooks to defer revenue, you need to take a look at RED, Microsoft Dynamics GP most over-looked module. The Revenue/Expense Deferrals module (RED) simplifies deferring revenues or distributing expenses by allowing you to make entries for future periods within these areas: General Ledger Receivables

by Colleen
Read More
Depreciation1
Dynamics GP

New Depreciation on Fixed Assets in Dynamics GP

We recently had a client contact our support team with a great question on depreciation of fixed assets in Microsoft Dynamics GP.   Customer Scenario & Question on Depreciation Our Company has been acquired by an equity firm and they have revalued all our fixed assets as of December 2017. 

by Dan Milani
Read More
New Company1
Dynamics GP

How to Add a New Company in Dynamics GP with the Same Master Data

Quite often we have clients ask us to create a new company in Dynamics GP that has the same master data as an existing company. Many businesses will do this because: The company was purchased and the new owners will start a new company with the same master data but

by Dan Milani
Read More
Benefits of GP pic1
Dynamics GP

Free Benefits for Dynamics GP Users

Are you using CustomerSource, GPUG Dynamics GP User Group, or our Crestwood Resources to enhance your Dynamics GP experience? If you use Microsoft Dynamics GP, these are places you’ll want to bookmark! Microsoft CustomerSource provides access to documentation, the Dynamics GP support community, software downloads, and up to date information

by Kayla
Read More
GP2018 PeriodEnd Pic1
Dynamics GP

Microsoft Dynamics GP – Why You Need Monthly Closing & Recommended Procedures

Do you dread year-end in Dynamics GP?  If so, do these tasks monthly and you can make year-end a breeze.  By following these guidelines, you will keep things in Dynamics GP clean and ready, so when you get to year-end, the process will be much easier. Follow the checklists in

by Kayla
Read More
PowerBi for GP 1
Dynamics GP

Now Available:  Dynamics GP 2018 & Power BI Content Pack

We’ve been waiting for what seems to be a very long time for a Power BI Dynamics GP Content Pack.  The wait is OVER! This Power BI Content Pack includes pre-built reports for your Dynamics GP data on: Financials Sales Purchasing Inventory This content pack helps you with the relationships

by Kayla
Read More
Remote App Desktop e1525977463852
Cloud Hosting

RemoteApp – Remote Desktop Without the Desktop!

One of the concerns we hear from clients when moving to the cloud is they don’t want to make things different or harder on their users.  The cloud tool that we recommend is RemoteApp.  You might be used to Remote Desktop, which basically virtualized the desktop that you were accessing.

by Ben
Read More
ProblemsPic1
Dynamics GP

Problems Updating Dynamics GP – Update Process Couldn’t Verify Information

This morning a client got this message on all their Dynamics GP 2018 clients.  This is a new one to us, we haven’t seen this error in the past. (Note - this error could apply to almost any version of GP that supports Automatic Updates).  “An available update may be

by Brandon
Read More
Webinar Graphic 2018 V2
Dynamics GP

Webinar: Basics of Dynamics GP SmartLists

Thursday, April 26, 2018 11:00 AM - Noon (CST)   Register Here! Join Crestwood and learn how to get started with the basics of SmartLists in Dynamics GP. This free, hour-long webinar will cover the basics of setting up and using Smartlists. We will cover topics such as: Where are

by Kayla
Read More
Finance Friction
Dynamics GP

Dynamics GP Modifier Unable to Access Dictionary Resources

The Error: While trying to access Dynamics GP2016 modified forms in the FORMS.DIC file, we were repeatedly denied access to the forms dictionary with the error message, “The modifier is currently unavailable because another user is editing resources in the forms dictionary.” We knew for a fact that no one

by Brandon
Read More
A Shield CompanyBack to top