Are Workarounds the Lurking Hidden Costs in Your ERP?

by | June 7, 2018 | Dynamics 365 for Finance and Operations, Project Management

Hidden Costs in ERP

“We’re going to use the system out of the box to the greatest extent possible.” Awesome. Do this.

“We’re going to minimize coding and customization.” Also great. Do this.

“We’re going to take customization [x] out of scope and use a workaround to conserve budget.” Take caution. Yellow light at the crossing.

Are Workarounds the lurking hidden costs in your ERP? Now I’m certainly not saying you shouldn’t ever take some customizations out of scope. It’s often prudent to do so. But all too often I’ve had clients fall into the trap of not understanding the workaround and finding that it ended up costing more than the original customization itself. Want a nice little example? One cautionary tale I’ve seen play out time and time again is commissions – it’s a classic. If your business doesn’t use commissions, keep reading. You’ll still get the allegory, I promise.

Early on in a project, perhaps even during the sales process, we talk with clients about their options for commissions. You can either use Dynamics 365 for Finance and Operations out of the box for commissions, you can purchase an ISV solution to add on to the functionality or you can customize the functionality to make it work exactly how you want. Let’s say we’re talking about a manufacturer who has relatively simple commissions requirements. They pay a flat percentage of invoiced dollars when an invoice is fully paid. And that’s where the requirement gap is. D365 for Finance and Operations can’t do “pay when paid” commissions out of the box.

ISVs & Customization

So then we talk about ISVs and we talk about customization. For fun, let’s just say the ISV is $20K and the customization is $10K. And the client says “I don’t want to spend the money for this when I can just do it in a spreadsheet”. The client has done the easy math that says if it takes the assistant controller an hour a month to do the spreadsheet, that’s only 12 hours a year which would take about 3 years to surpass the cost of the customization and even more for the ISV. But there’s one key missing piece.

The Workaround

The workaround. The slippery slope. Call it what you will, it’s where the costs hide. The workaround in our commissions example is getting the data out of the system. D365 has some really great ways to get data out of the system. But you still need to understand how to configure the system and perform the extractions. What’s key about this example is that you need data from multiple sources in D365. You need sales order invoices to tell you what was invoiced. You need customer payments to understand what was paid, settlement information to understand how much of each invoice has been paid and when, product category so you can apply the right commission percentages, etc, etc.

The workaround has now turned into at least four data extractions that need to be configured and a spreadsheet that ties all the data together. Then it gets slipperier when we start asking questions like “what if someone invoices something in a past period because the controller reopened the fiscal period?” or “what if I need to make a retroactive change to someone’s commissions?” Not only do the client’s internal labor costs start to rise to handle commissions outside the system but the truly hidden cost emerges – the cost of consulting hours to help the client deal with all these questions and reconfigure the system to address them. The ROI of the customization has just shifted.

Is it a good idea?

Surely the moral of the story has emerged here. Does it seem like a good idea to take known customizations out of scope if they don’t measure up to the “secret sauce of the business” rule? Sure. Is it always a cost-effective move? Not necessarily. Is this something specific to Dynamics 365 or other specific software solutions? Nope – chalk it up to life in ERP. Happy scoping!

Related Posts


Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events


31mar01aprTraining Class: Financial Reporting W/Account Schedules for Dynamics 365 Business Central

07apr2:00 pm2:30 pmEnsuring Quality for Batch Manufacturers

08apr11:00 am12:00 pmConfab with Stoneridge - Livestream - Jumping into the Deep End of the Data Lake

14apr10:00 am10:30 amBoost Seller Productivity and Close More Business with Dynamics 365 Sales

21apr10:00 am10:30 amSetting Your Sales Team Up for Success: A Modern Look at Revenue Operations

21apr12:00 pm1:00 pmGetting Started with Barcode Scanners and WMS Apps for Business Central

21apr2:00 pm3:00 pmMoving to the Cloud: Today's Solution for Leading Field Service Companies

22apr11:00 am12:00 pmConfab with Stoneridge - Livestream - Moving from Manual to Automated with Strategic Automation Strategies

28apr10:00 am10:30 amThe Modern Manufacturer: Best Practices for Inventory Turnover

28apr12:00 pm1:00 pmPower Up Microsoft Dynamics by Automating Budgeting, Dashboarding and Reporting


05may10:00 am10:30 amAchieve More with Zetadocs for Business Central

05may2:00 pm2:30 pmSimplifying Item Pricing, Availability, and Tracing for Batch Manufacturers

06may11:00 am12:00 pmD365 Field Service – New Features to Empower Your Remote Workforce

12may10:00 am10:30 amThe Modern Manufacturer: Manufacturing Software in the Real World

12may12:00 pm12:30 pmFinancial Implications of Moving from Dynamics GP to Dynamics 365: Licensing and Infrastructure

17may(may 17)8:00 am28(may 28)11:00 amDynamics 365 Finance & Supply Chain Development Training - Online Workshop

26may10:00 am10:30 amThe Modern Manufacturer - Enterprise Asset Management

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!