Dynamics GP Payroll Tax Updates
Avatar photo
Mike

Dynamics GP 2020 U.S. Payroll Tax Update Release

The 2020 Round 1 tax update has been released.  There are new federal tax tables published based on 15-T, including new head of household status, and withholding tax tables.  Additionally, FICA social security limit for 2020 is increased to $137,700. State updates include: California Illinois Iowa Kentucky Maine Michigan Minnesota Missouri North Caroline North Dakota … Read more

Read More…

Crestwood Cloud
Avatar photo
Ben

Are You Sure that You’re Really in the Cloud? A Gray Market Cloud Horror Story

You are a savvy business owner; your business processes and ERP are backed up in the cloud. You’ve seen the statistics, heard the horror stories, and you’ve made the necessary steps to feel secure. But what does “in the cloud” really mean? How secure is your data really? Gray Market Cloud Spells Doom for One … Read more

Read More…

Error
Avatar photo
Juliet

How to Resolve a Dynamics GP Microsoft Word Template Error

After modifying the SOP Blank Invoice format in Microsoft Dynamics GP, I received this error message: “We’re sorry. We can’t open SOP Blank Invoice Form because we found a problem with its contents.” Clicking “Details” provides additional errors: Microsoft Office cannot open this file because some parts are missing or invalid. Location: Part: /word/footer2.xml, Line: … Read more

Read More…

Regular Expressions in Acumatica
Avatar photo
Juliet

View Historical Transactions with Negative Amounts Based on Document Types (in SmartList Designer for Dynamics GP)

SmartList Designer Tips Next in our series of SmartList Designer blogs, we’ll look at optimizing a basic purchasing SmartList. (If you need a refresher on SmartList Designer, or missed the first blog, you can find it here.) Let’s say that a purchasing manager wants to view all the historical transactions for a vendor. However, the … Read more

Read More…

Smartlist builder in Dynamics GP
Avatar photo
Juliet

How to Create a SmartList in Dynamics GP that Displays the Correct Email Address

SmartList Designer Tips for Dynamics GP As most Microsoft Dynamics GP users know, with every version of the system comes with the advanced reporting tool called SmartList. Out of the box, SmartList has several pre-made reports to choose from, all of which pull directly from your Dynamics GP tables, and are column-based (meaning Excel-friendly). In … Read more

Read More…

Valuation Methods
Avatar photo
Mike

Inventory Valuation Methods in Dynamics GP

Valuation methods are what determines how the costs of inventory items are calculated. There are several different methods you can use in Microsoft Dynamics GP. I recently had a client question how the various Inventory Valuation Methods in Dynamics GP differ. In this client’s case, the valuation they were using did not make sense for … Read more

Read More…

Dynamics GP Business Challenges
Avatar photo
Mike

4 Dynamics GP Challenges and How to Address Them

Microsoft Dynamics GP has been a mainstay in the ERP community. Designed for small and mid-sized businesses who want a reliable and well-vetted solution, GP has evolved and grown to be one of the most trusted ERP vendors for this market. However, no matter how consistent this solution is, no matter how powerful, there are … Read more

Read More…

Learn Power BI Dashboards
Kayla
Kayla

Learn Power BI the Easy Way

Are you interested in Power BI?  Maybe you’re wondering what it can do for your business and Dynamics GP data? We recommend starting with this Microsoft self-paced, hands-on learning tutorial, “Explore what Power BI can do for you.”  You will learn: Understand Power BI service basic concepts and terminology. Find your content in dashboards, reports, … Read more

Read More…

Maximum Users for Dynamics GP
Avatar photo
Brandon

“Maximum Number of Users” Error in Dynamics GP 

We ran into an issue recently where client would receive the following error when logging into Microsoft Dynamics GP even though licenses are available:  “The maximum number of users are logged into the system.”  Clicking OK closes Dynamics GP.  What is also strange is that the “Users Allowed” and “Current Users” fields both show 0.   When logging in with SA, there are … Read more

Read More…

Dynamics GP Charts
Avatar photo
Mike

Changing your Chart of Accounts in Dynamic Great Plains

All accounting professionals know the importance of a well-designed Chart of Accounts (COA). Whether you’re new to Microsoft Dynamics GP or a seasoned veteran, you’ve pulled the COA report for yourself and the other business leaders within your company. Have you ever wanted to customize it, though? Our team gets this request a lot. Commonly-Requested … Read more

Read More…

Virtual Invoices for Dynamics GP
Avatar photo
Ben

Dynamics GP and Forms Printer – it slices & it dices!

Every organization has unique business processes, and tailoring solutions to meet, automate, and scale those processes can be very rewarding wins for your organization.  We had a rather unusual client requirement come through that we were able to accommodate in Microsoft Dynamics GP with the addition of Accountable Software’s Forms Printer application. The Problem A … Read more

Read More…

New Features in Dynamics GP 2018 R2
Avatar photo
Juliet

Displaying the Vendor Document Number in the Purchasing All-in-One View

New Feature in Microsoft Dynamics GP 2018 R2 By popular user demand: The Vendor Document Number is now available on the “Purchasing All-in-One View” window. No more jumping from screen to screen and cross-referencing document numbers! This helps the user track the payments and credit documents together with the invoice they have been applied to. … Read more

Read More…

SmartList Builder- Purchase Order
Avatar photo
Mike

Dynamics GP SmartList Builder: Purchase Order Shipment Receipt and Matching Line Number

I recently helped a Microsoft Dynamics GP client create a SmartList to pull in purchase order numbers for shipments and match receiving lines.  Additionally they wanted to see the number of the receiving line. To accomplish this I created a SmartList Builder Report from the SmartList “Receiving Transactions.” Here’s how: The trick is we had … Read more

Read More…

Microsoft Dynamics Changes
Avatar photo
Mike

New Tech Support Portal: Big Change Coming for Microsoft Dynamics Users

Life would be so boring without change, don’t you think? We know that Microsoft agrees with that! One big change is coming that we wanted to make you aware of: the new, modern portal for submitting support requests for all Dynamics products (like Dynamics GP, Dynamics SL, and Dynamics 365 Business Central). Microsoft is working … Read more

Read More…