Skip to main content

The Five Microsoft Dynamics GP “Worst Practices”

by Mark Polino
Director of Client Services, Fastpath, Integrated Business Group
April 09 2009
Articles often highlight best practices, that is, the consensus right way to do things. I've decided to take a look at some common worst practices. These are practices that organizations should discontinue with Microsoft Dynamics GP. Here are five of the worst:

1) Ignore Backups

Companies know that they should backup their Dynamics GP data, and may even think that it's being backed, but unless they've done a test restore, all they have is a hope and a prayer. Users need to stop guessing and ensure that the GP database is being backed up (not just replicated via a RAID system or stored on a SAN). Users should check that customized forms and reports, along with integration manager databases and the FRx SYSDATA file, are all being backed up. Some configurations may even have more items to back up.

2) Load up the Chart of Accounts

Some users are like pack rats--they like to store everything in the chart of accounts. They have a segment for customers, a segment for projects, a segment for fixed assets, and often a blank segment for certain one-off transactions. Stop! Slim down the chart of accounts and let Dynamics GP's sub-ledger connections provide the needed reporting, without bloating the chart of accounts.

3) Customize the Interface Instead of Changing the Process

Customizing the application is fine, but customizing the interface instead of changing the company's process is a recipe for scope creep, increased costs and upgrade problems. Customizations should add value, not simply reproduce what a company already does. Too often, the old process is in place because of limitations from a previous system. Companies that start working with the default interface are ...

FREE Membership Required to View Full Content:

Joining gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

About Mark Polino

Mark Polino is a Certified Public Accountant (CPA) and a former Microsoft MVP (2007-2018) for Business Solutions. He is the author or coauthor of 5 books related to Microsoft Dynamics GP.  Mark also maintains the Dynamics GP focused website He speaks and writes regularly about ERP related topics. Mark has been a controller and CFO for a division of a publicly traded company and he has  worked as a consultant implementing ERP solutions. Mark holds additional certifications including Certified Information Technology Professional (CITP), Certified in Financial Forensics (CFF) , Chartered Global Management Accountant (CGMA). Dynamics Credentialed Professional for Dynamics GP 2015 (Core Install and Core Financials), Xero Certified. He holds a bachelor's degree in accounting from the University of Central Florida and an MBA from Rollins College. Mark lives with his family in Florida.

More about Mark Polino
Submitted by ahameed on Wed, 04/15/2009 - 05:08 Permalink

When attached LDF and MDF database. when inquiring the data in GP is not properly display. every screen it shows the error messages. please help me this error message.

In reply to by anonymous_stub (not verified)