Finance departments often face friction and risk when managing digital transformation projects in ERP systems. This episode discusses practical, low-friction approaches using free tools that align shop floor reality with financial systems, improve planning accuracy, and enhance operational control without costly disruptions.
Using Free Apps For Continuous Improvement In Business Central
Transcript
Ryan: You know, there is a very specific kind of groan that you hear in a finance department when someone says the words digital transformation.
Emma: Oh, I know that sound. I know it well. It’s the sound of a checkbook flying open and a calendar just filling up with meetings for, what, the next 18 months?
Ryan: It’s practically a physiological reaction. And if you’re a finance leader running, say, Microsoft Dynamics 365 Business Central. Digital transformation usually implies three things.
Emma: Let me guess. Expensive, disruptive, and a good chance it won’t even work.
Ryan: Cynical, but historically, pretty accurate.
Emma: Right, which is exactly why today we’re going to completely flip the script on that. We’ve pulled together a whole stack of resources. You know, technical docs, user reviews, and we’re exploring a concept we’re calling. Quiet Wins.
Ryan: I like that.
Emma: Yeah, we’re not talking about overhauling your entire system architecture. We are talking about stewardship.
Ryan: Stewardship is the perfect word for it. It’s the adult, in the room approach to your erp.
Emma: Okay? It’s not about some big mission accomplished banner. It’s just about making the business run smoother, think faster and cleaner, without all the organizational drama.
Ryan: And here’s the hook for this deep dive. We are going to analyze nine very specific apps for Business Central, and they cover, I mean, everything from the warehouse floor right up to the controller’s desk. And the common thread, the common denominator, is that they’re all free.
Emma: Ah. And that’s usually where a CFO gets immediately suspicious, because free usually implies cheap or useless. Or some kind of Trojan horse.
Ryan: Exactly. We’re going to sell your data or, oh, it only works for three days and then you have to pay.
Emma: Right, Right. But in the Microsoft ecosystem, and specifically with these tools, we’re looking at free is actually. It’s a strategic lever. It changes the entire risk profile.
Ryan: Okay, let’s unpack that a bit before we jump into the apps themselves. Why should a CFO who literally controls the budget care so much about free tools? It’s not just about saving a few bucks on licensing, is it?
Emma: No, not at all. The licensing cost is. It’s negligible compared to the implementation cost of a big project. The real value of free here is the. The absence of friction.
Ryan: Friction?
Emma: Yeah. Think about the normal corporate procurement process. If you want a piece of software that costs, say, $5,000 a year, you need a P.O. you need ROI justification, maybe a steering committee meeting.
Ryan: You need political capital. You have around and convince people that’s it.
Emma: But if it’s free, you just, you install it in the sandbox, you test it. If it works, you push it to production. It completely bypasses the bureaucracy.
Ryan: So it lets a leader say, I see a problem and I’m going to fix it this afternoon instead of I’m going to try to fix it next quarter.
Emma: You’ve got it. It’s a way to create a culture of continuous improvement. The best run companies I’ve seen, they aren’t doing these massive episodic overhauls every five years. They’re constantly tweaking, constantly tightening things up.
Ryan: And these quiet wins let you do that. All right, let’s get into the gears then. We’ve got nine tools to cover and we’ve grouped them by where they hit the P and L. So we’re going to start with the money is actually made or, you know, lost. Production and planning, the heartbeat of the whole operation and often the source of the biggest headaches. So the first tool in our stack is the graphical scheduler. Now, the problem it describes, it seems almost archaic. It talks about production schedules living on whiteboards.
Emma: You would be shocked, or maybe wouldn’t, at how many multi million dollar companies run their entire production floor on a whiteboard that probably hasn’t been updated since Tuesday.
Ryan: The old hallway chat management style.
Emma: It’s a total nightmare for a finance leader because you have Business Central, which thinks production’s happening one way, right? And then you have the shop floor manager who knows that machine A is down, so he moved the job to machine B, but he only wrote that down on a sticky note.
Ryan: So the data in your ERP is essentially fiction at that point.
Emma: It’s complete fiction. Precisely. And that’s what leads to reactive decision making. You promise a customer a delivery date based on the system, but the reality on the floor is totally different.
Ryan: The variance reporting must be a mess.
Emma: Oh, it is. Because the system plan and the actual execution never ever aligned.
Ryan: So the graphical scheduler, is this just making the data look pretty or does it actually change the workflow?
Emma: It visualizes the production orders on a timeline thing like a gaunt chart right inside Business Central. But the quiet win isn’t the visual part, it’s the interactivity, meaning you can literally drag and drop a production order from one machine to another or from Tuesday to Wednesday.
Ryan: And when you drag that bar, it’s actually updating the underlying data.
Emma: In Business Central, that is the absolute key. It forces the reality of the shop floor to sync up with the financial system. You’re not just drawing a picture, you’re rescheduling your capacity in real time.
Ryan: So if I’m the cfo, I’m not adopting this because I like charts. I’m adopting this because it kills the excuse of, oh, I didn’t tell the system.
Emma: It kills the shadow schedule. There’s only one schedule. Everyone sees it. And if it changes, the system knows immediately you start using your existing capacity better.
Ryan: That makes a ton of sense. Alright, let’s move to the next one, which? This one touches a very specific nerve for me. The Enhanced Planning Worksheet. This is all about the spreadsheet from hell.
Emma: Ah yes, the spreadsheet that’s so complex only one person in the entire company knows how to update it.
Ryan: And if they go on vacation, the whole company stops buying raw materials.
Emma: That’s the one. The standard procedure in probably what, 60% of companies is that planners don’t trust the the ERP’s logic.
Ryan: The MRP, it’s a black box to them.
Emma: So they dump all the data to Excel, run their own vlookups and pivots to decide what to buy, and then they manually key the orders back into Business Central.
Ryan: And as the cfo, you have zero visibility into why those buying decisions were made. Yeah, you just see the cash going out the door.
Emma: And you can’t audit a spreadsheet that was overwritten three weeks ago. You lose the logic. Why did we buy 10,000 units? Was it a demand spike? A bulk discount? Who knows?
Ryan: So what does the Enhanced Planning Worksheet do?
Emma: It effectively rebuilds that Excel like interface, but inside Business Central. It gives the planners the view. They’re comfortable with columns they can sort and filter, but it’s all looking at live real data.
Ryan: So you’re meeting them where they are. You’re not forcing them to become programmers, you’re just giving them a better spreadsheet that happens to live in the erp.
Emma: And for the finance team, that’s the quiet win of visibility. You can see the logic, you can see the demand signal that triggered the po. It brings discipline to the spending without you having to be the bad guy.
Ryan: Speaking of discipline and planning, that leads us right to the third app in this group, the Enhanced Forecasting Worksheet. This seems to tackle that classic war between sales and operations.
Emma: War is definitely the right word. Sales wants to forecast low so they.
Ryan: Can crush their bonuses, and operations wants to forecast highs so they never ever run out of stock.
Emma: And finance is stuck Right in the middle, just trying to figure out how much cash to keep in reserve. And this whole battle usually happens with three different spreadsheets in a monthly meeting that everybody absolutely hates and nobody’s numbers ever match.
Ryan: Yeah, sales is in dollars, Ops is.
Emma: In units, and finance is trying to reconcile it all. This tool lets you generate and edit forecasts directly in Business Central using historical data as the baseline.
Ryan: So instead of arguing about whose spreadsheet.
Emma: Is the right one, you stop litigating the past. You stop arguing about data validity. Is this the V2 final real version? No, the version in the system is the version.
Ryan: I love that phrase, litigating the past. That’s the definition of an unproductive meeting.
Emma: It just clears the noise. It builds confidence in your forward looking numbers, which for a CFO is the holy grail.
Ryan: Okay, let’s shift gears. We’re moving from the planning desk out to the loading dock operational control. This is where a lot of margin leakage happens, right?
Emma: It is. It’s where physical reality smacks into financial theory. If you’re not tight here, you bleed money on every single order.
Ryan: The first app here is Order Ship Express and the scenario it describes is the swivel chair problem.
Emma: Right. The shipping clerk has Business Central on one monitor the UPS or FedEx portal on the other. They copy paste the address from B.C. to the carrier site, print the label copy paste the tracking number back.
Ryan: And somewhere in that copy paste process, 123 Main St becomes 132 Main St.
Emma: Or they just forget to paste the tracking number. Or, and this is the big one for finance, they choose a shipping method that costs $50 on an order where your margin was only 40.
Ryan: Ouch. And you don’t even find out until the carrier invoice comes in three weeks later.
Emma: Exactly. Order Ship Express brings that whole process inside the erp. You rate shop, generate the label and post the shipment all from one single screen in Business Central.
Ryan: So the quiet win here is basically margin protection.
Emma: It’s margin visibility. At the point of transaction, you know the cost immediately. Plus you get rid of the data entry errors, that tightens the bolts on the whole outbound process.
Ryan: That seems like a complete no brainer for anyone shipping physical goods. But then there’s the warehouse itself. The material we have highlights. WMS Express now WMS Warehouse Management System. Those three letters usually scare people.
Emma: They should. A full blown WMS implementation is often a six month six figure consulting project. It is high risk, so companies avoid it.
Ryan: They just stay on paper with guys running around with clipboards.
Emma: Which means your inventory is only accurate once a year during the physical count. The rest of the time you’re guessing. You think you have 10 widgets. You sell 10, the picker goes to the shelf, and there are only eight.
Ryan: Now you have a crisis.
Emma: A big one. WMS Express is different. It’s like the diet version. It’s just the essentials. It uses barcode scanning for the absolute basics. Receiving, picking, put away. It doesn’t force you to reconfigure your entire warehouse.
Ryan: So it’s the bridge between paper and complex wms.
Emma: It is. It lets you move to real time inventory. When a picker scans an item, it’s deducted from inventory, right? Then, not when the paperwork makes it back to the office at 5pm and.
Ryan: That real time piece is crucial for cash flow. Right? If you know what you have, you don’t have to over buy safety stock.
Emma: Precisely. It’s a controlled step forward. You get 80% of the benefit of a WMS with maybe 10% of the headache for a CFO. That’s an incredible ROI on a free tool.
Ryan: Okay, let’s move it to the back office. The unsexy stuff. Admin efficiency and governance. This is where the death by a thousand cuts happens with labor hours.
Emma: This is where you burn out your best people with mindless, repetitive work.
Ryan: App number six is the import export power tool. Now, Business Central already talks to Excel. We know that. So why do you need a power tool?
Emma: Because the standard edit in Excel feature, it has guardrails. It’s for simple tasks. But let’s say you need to update credit limits for 500 customers based on a new risk model.
Ryan: You’re usually asking a controller or a senior accountant to do that. These are high salary people.
Emma: And if they have to do it manually, record by record, you’re just setting money on fire. The power tool allows for validation, for speed and for repeatable configurations.
Ryan: So it’s leverage. You want your controller analyzing the P and L, not data. Entering customer cards all day.
Emma: Cleaner data, less effort. That is the definition of a quiet win.
Ryan: Speaking of clean records, let’s talk about the digital equivalent of a messy desk. Dockstender.
Emma: Ah, the where’s the invoice game.
Ryan: I’ve played that game. The auditors are in the conference room. They ask for a sample of 10 purchase invoices, and suddenly the whole finance team is turning the office upside down.
Emma: It’s panic mode. Yeah, and it just. It looks unprofessional. It signals to the auditor that your controls are weak.
Ryan: To Dockstender Is it really just drag and drop?
Emma: That’s it. You have the purchase invoice record open in Business Central. You drag the PDF from your email, drop it on the record, it’s done.
Ryan: It sounds almost too simple to be.
Emma: A strategic tool, but think about the downstream effect. Six months from now, you’re reviewing that account. You don’t have to go hunting. You click the record and you see the source document right there.
Ryan: It creates a self service audit trail.
Emma: And it solves the bus factor. If Bob wins the lottery and leaves tomorrow, the knowledge of where those invoices are doesn’t leave with him. It’s in the system.
Ryan: Okay, we have two more and they’re a bit niche, but important. The Safety Logbook. This feels like it sits a little outside of finance.
Emma: Usually it does until there’s a lawsuit or a fine. Then it becomes a finance problem very, very quickly.
Ryan: The issue here is the binder on the shelf.
Emma: Exactly. Safety incidents training logs. They live in a physical binder or some random spreadsheet. When an OSHA inspector shows up, there’s this mad scramble to prove compliance.
Ryan: And if you can’t, your premiums go up or you get fined.
Emma: The Safety Logbook just brings that data structure inside Business Central. It’s about your compliance posture. A CFO’s job is to protect the assets of the company. And this is a very cheap insurance policy.
Ryan: Okay, finally, app number nine. The Barcode Generator power tool. This one sounds like it belongs to the IT department.
Emma: It usually does, which is exactly why it’s on this list.
Ryan: The problem it describes is you want a barcode on a document like a packing slip. But to get it, you usually have to hire a developer to customize the report.
Emma: You’re paying a consultant 200 bucks an hour just to add a font to a report. It’s a total waste of budget. This tool lets you embed barcodes on existing documents without any code.
Ryan: And why is that a quiet win for the cfo?
Emma: Because barcodes are the prerequisite for automation. You can’t use that WMS scanner we talked about if your documents don’t have barcodes to begin with. This tool removes the technical hurdle, it lowers your IT spend, and it speeds up operations.
Ryan: So if we look back at this whole stack. Scheduling, forecasting, shipping, warehousing, admin, safety. None of these are sexy in the Silicon Valley Center.
Emma: No, they’re boring. And that is exactly why they are so powerful.
Ryan: They just reinforce good behavior.
Emma: They grease the wheels. They take the friction out of the daily grind and let’s loop all the way back to the start. They are free.
Ryan: Which means for you, the listener, the barrier to entry is effectively zero.
Emma: That is the no brainer logic. If you install the graphical scheduler and the production manager absolutely hates it, you uninstall it, you lost nothing but an afternoon. But if it works, you’ve solved a major communication bottleneck.
Ryan: For $0, it really reframes the role of the finance leader. We talked about stewardship at the top. This is stewardship in action.
Emma: IT positions exploring these tools not as experimentation, which sounds risky, but as optimization. You’re just taking care of the system. You’re looking for the rust and cleaning it off.
Ryan: And you’re doing it without having to wait for permission. You don’t need a capex request signed by the board to install a free app that fixes a shipping error.
Emma: And that’s the real leadership takeaway here. Sometimes the most impactful wins are the ones you just quietly execute. You don’t ask, you just solve.
Ryan: It’s empowering. Instead of waiting for the perfect ERP system that you might get in 2028, you make the current system 5% better.
Emma: Today and then another 5% next month. That compounds that is how high performing finance teams operate. They don’t wait for a savior. They just fix the friction that’s right in front of them.
Ryan: So to you listening, whether you’re the cfo, the controller, or just the person in the office who is tired of the chaos, the question is pretty simple. What’s the friction point? You’ve just stopped noticing because, well, that’s just how we do things here.
Emma: Is it the spreadsheet war? The hallway scheduling? That frantic search for invoices Every month?
Ryan: There is very likely a quiet whim sitting right there, just waiting to be downloaded.
Emma: Go look for it, claim it, and.
Ryan: Enjoy the silence of a system that just works. Thanks for diving in with us.
Emma: Take care.