Are Workarounds the Lurking Hidden Costs in Your ERP?

By Jessica Swartz | June 7, 2018

Are workarounds the lurking hidden costs in your erp?

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 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

Recommended Reading:

Managing Your Business Through Uncertain Times Using Dynamics 365 Finance and Operations

  Dynamics 365 Finance and Operations (F&O) can help you make informed decisions on how to move your business forward. […]

Read the Article
5.13.22 Power Platform

Using Power BI Object Level Security

  The following article will demonstrate how to use Power BI Object Level Security to disable column data based on […]

Read the Article
5.12.22 Dynamics CRM

How to Use the Stoneridge Support Portal

Stoneridge Software’s support portal is an intuitive and useful function that makes it easy for you to access resources to […]

Read the Article
5.6.22 Dynamics GP

Dynamics GP Transaction Removal: Purchase Orders

  Are you having performance issues with Purchase Orders?  Do you find that there are old Purchase Orders on your […]

Read the Article
5.5.22 Dynamics GP

The Real Story about the Long-Term Future of Dynamics GP Support

I’ve seen a number of people put forward comment that Dynamics GP is going away and you have to get […]

Read the Article

New Features in Dynamics 365 Business Central 2022 Wave 1 Release – Financial Enhancements

The Dynamics 365 Businses Central 2022 Wave 1 Release has a lot of new and exciting features to help your […]

Read the Article
4.29.22 Dynamics GP

Dynamics GP Transaction Removals: Bank Reconciliation

  This is part 2 of a 3 part series on Dynamics GP Transaction Removals. These quick tips will hopefully […]

Read the Article
4.28.22 Dynamics GP

Uncommonly Used Features – Integrate Purchasing and Payables to Fixed Assets in Dynamics GP

Being able to integrate Purchasing and Payables to Fixed Assets in Dynamics GP will help you create visibility for your […]

Read the Article

New Features in the Dynamics 365 Business Central 2022 Wave 1 Release – Ease-of-Use Features

  There are many new features in the Dynamics 365 Business Central 2022 Wave 1 Release to get excited about! […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!