One of the most commonly asked questions from my Microsoft Dynamics GP customers is – how do I see how much I paid a certain vendor by GL account? For example: if you need to see all the legal fees paid to several different law firms, where do you go to get this information quickly … Read more
Category: Dynamics GP
Tax Time: New Filing Requirement for Wisconsin Businesses
The Wisconsin Department of Revenue has a new requirement for wage payers and information filers for 2018. Yes, any employers and payers doing business in Wisconsin are required to file wage statements (W-2s) and information returns (e.g.,1099-MISC) with the Wisconsin Department of Revenue (DOR); however, for 2018, there is a new requirement. New Requirement: If … Read more
Videos: Microsoft Dynamics GP Training
We want to make sure you get the most out of your Microsoft Dynamics GP system. Crestwood Associates holds free, monthly webinars on various Dynamics GP topics. Here are some of our recent recordings. If you’re interested in attending our webinars, you can register here for our upcoming sessions. If you have questions or need some assistance, … Read more
The Dynamics GP Year-End Update – What’s the Same and What to Look Out For
It’s that time of year again: the air has grown crisp, the snow has started to fall, and Microsoft has released the year-end updates for Dynamics GP. No matter which version you’re currently running (Dynamics GP 2015, Dynamics GP 2016, or Dynamics GP 2018), there are three main items to note: some forms that stay … Read more
Do These 2 Things to Make Dynamics GP Year-End Easy
Get a Head Start on Year-End 2018 Start early and make 2018 a little easier. Here’s a checklist to get a head-start and prepare your Dynamics GP system for year-end. System Review: Be sure that your Backups are working correctly, and test the Restore process prior to Year-end. If you have questions or need some … Read more
Microsoft CustomerSource – The One-Stop Support Shop for Dynamics Customers
Microsoft’s CustomerSource is a valuable resource available to all Microsoft Dynamics ERP (Dynamics GP, Dynamics SL, Dynamics 365, etc.) customers who are currently on a support plan. CustomerSource is divided into several sections, such as KnowledgeBase, Online Learning, and Account Management. Each section has its own set of resources and functions. Here’s a quick guide … Read more
Microsoft Dynamics GP Dates Overview Guide
Many times I get asked questions about what all the different dates in Microsoft Dynamics GP do and or mean. All the dates in Dynamics GP can be confusing. So, I created this handy overview to help you out. Basic User Dates Thanks to Jen Kuntz for her post. User Date: Your “User Date” … Read more
Troubleshooting User Logins to Dynamics GP
Recently working with a customer we were trying to give a user access to a TEST company in Microsoft Dynamics GP. When trying to switch to the test company, the user was getting the following error: “The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must … Read more
How To Manually Update Payroll Taxes in Dynamics GP
With the Year-end fast approaching, there are some versions of Dynamics GP that are no longer supported. In 2018, any release prior to and including GP 2013. If you are using the payroll module in any of these releases you will not receive the Payroll Year-end Update hotfix that Microsoft releases in November 2018, and … Read more
Dynamics GP: Multi Entity Issues with Vendors, Customers, or Items not Being Available
I recently came across a client that had issues accessing new Items, Customers, and Vendors. The issue wound up being relatively simple; it was because when these things were setup in Dynamics GP, the Entity Relationship in Multi Entity Management was not setup. What is Multi-Entity Management? If you use multiple companies in Dynamics … Read more
Economic nexus sparks need for speedy sales tax registration
Repost from Avalara Economic nexus is here. Is your business prepared? Before the Supreme Court of the United States issued its ruling in South Dakota v. Wayfair, Inc. (June 21. 2018), states could only tax sales by businesses with a physical presence in the state. Wayfair changed that long-standing rule. The court found the respondents’ … Read more
The Swiss Army Knife for Dynamics GP (PSTL)
The Professional Service Tools Library (PSTL) is a free set of tools you can install and use with your Microsoft Dynamics GP system. Be careful – although these tools are free, they can destroy your system if you run the wrong thing. For example, running the Financial Tools can remove all historical data – and … Read more
Dynamics GP 2018 R2 New Features
The new release of Microsoft Dynamics GP 2018 R2 is full of customer-suggested improvements, new features, and Roadmap items. Thank you to everyone for submitting ideas to make Dynamics GP even better. The new version is out on October 1st – here are some of the features we are excited about: Financial Enhancements Exclude items … Read more
Increase Performance & Speed Up Reporting in Dynamics GP
Are you trying to improve performance of Microsoft Dynamics GP without investing thousands more in hardware and infrastructure? Has your SQL database size started to grow out of control? Perhaps Inventory Reconcile, Check Links, or other maintenance tasks are taking a long time to run due to the growing data volume? Sounds like you need … Read more
6 More Great Reasons to Attend GPUG Summit (and how to get 10% off!)
Have you made your plans to go to Phoenix with me for GPUG Summit October 15-18? Great! Send me an email and we can meet up for a meal or a drink that week. Please let me know if you haven’t registered and I will send you a special code to save you 10%! GPUG … Read more
Top 3 Reasons to Attend GPUG Summit
The annual GPUG Summit is right around the corner. We hope to see you there! Our very own Mary Lenehan will be presenting a session on SmartLists this year – that’s one you don’t want to miss. This annual event is hosted and coordinated by the Microsoft Dynamics GP User Group (GPUG). GPUG, is a … Read more
The One Rule When Splitting Direct Deposit Amounts in Dynamics GP
Recently, a client asked if it is possible to set up payroll direct deposit for an employee where the employee requested that a portion of their net pay be deposited into one account and the remaining balance be deposited into another account. With Microsoft Dynamics GP, you can enter percentages for the direct deposit amounts, … Read more
Add a Field to Your Dynamics GP Refreshable Data Connection with Excel
Now that you’re using a Refreshable Data Connection between your Microsoft Dynamics GP system and Excel, you might find that you’re missing a field or two. It’s not as hard as you’d think to edit the data connection and add in those missing fields. I’ll explain how. If you’re not using this feature yet, you … Read more
Quickly Clearing Unused Receipts in Dynamics GP
We occasionally get requests from our Microsoft Dynamics GP users to clear unused receipts in the deposit window (Transactions>Financial>Bank Deposits). Sometimes a customer starts to use the bank reconciliation for the first time, or maybe someone just lost track of receipts and they never got posted. No matter the reason, here’s how to clear receipts. … Read more
Dynamics GP Letter Writing Assistant
Microsoft Dynamics GP Letter Writing Assistant has been around for a long time but I find a lot of people don’t know about it. Microsoft has provided sample Word documents to be used for letters that you need to send to customers, vendors, and employees. You can send the letters to all, or select from … Read more
Dynamics GP Purchase Order Received But No Invoice
Have you ever encountered a Purchase Order in Microsoft Dynamics GP that was still open but should be closed? I had a customer run into this problem recently. Here’s what I did to fix it. First, I reviewed the Purchase Order process the client used. We entered a PO like this one. Next, we entered … Read more
Better Security in Dynamics GP with Field Level Security
Do you have Field Level Security set up in your Microsoft Dynamics GP system? Did you know you can use it to do things such as: Lock a user date Hide a field Require a password to change a default warehouse And so much more Dynamics GP Field Level Security allows you to control user … Read more
Best Practices for Credit Card Payments to Vendors in Dynamics GP
This question has come up multiple times over the past few months. So, I wanted to share our recommendations for credit card payments to vendors in Microsoft Dynamics GP. Here are two methods to use credit cards when paying a vendor. Method 1: First, enter all credit card transactions when the credit card statement is … Read more
What Security Reports Should I Use for Auditors for Dynamics GP?
We often receive calls from our clients when auditors want to review security. Microsoft Dynamics GP offers several security reports you can run for audits. How to print the Dynamics GP security reports Go to Reports>System>Security. In this window, you’ll see the list of available reports. The most common reports that auditors look for are: … Read more