Skip to content

On demand · Video

Business Central production scheduling in minutes, not hours

For manufacturers and production planners on Business Central who schedule by hand today and want to see work center load clearly, or stop dragging and dropping orders all day.

Recorded November 13, 2026 · 15 minutes · Presented by Mark Hamblin, Senior Solution Advisor

Graphical Scheduler in Business Central showing production order operations and work center load, from the production scheduling video with Mark Hamblin

Summary

Mark Hamblin, Senior Solution Advisor at Insight Works, shows two ways to schedule production in Business Central. Graphical Scheduler gives planners a visual board with work center load, non-working hours and drag-and-drop rescheduling. This is a completely free app from Insight Works for Business Central. MxAPS then builds a 30-day schedule for just under 60 production orders in about 20 seconds, choosing the best machine, respecting labor at a shift change, and sequencing by material to cut setup time. The session also covers what-if runs on late orders and running the schedule from the job queue.

Key topics

  • Date presets and work center load in Graphical Scheduler
  • Drag and drop rescheduling with Business Central scheduling logic
  • Custom views, colors and data sources from any table
  • Generating a 30-day schedule with MxAPS
  • Alternate machines, labor limits and material sequencing
  • What-if runs and scheduling from the job queue
Read the transcript

Introduction

Today we’re going to go through a little bit on how to simplify production scheduling in the next 15 minutes. And to get into it, in case you don’t know who we are, Insight Works works primarily in manufacturing, distribution and even retail. Anywhere you need to touch physical goods, we can probably help you out. And one of the key things about Insight Works is, we have a lot of free applications you can use that can help you with production scheduling, material handling, all of those sorts of things.

So I’m not going to go through these in a lot of detail, but please check out our website and you’ll get an idea of all the free applications that we have that can definitely help you on the manufacturing and warehousing side as well.

Two tools for production scheduling

Now, what we’re actually here to talk about today though, is production scheduling. And we have two solutions, two primary solutions for that production scheduling. The first is the Graphical Scheduler. The Graphical Scheduler is the must have. So if you’re running Business Central and you’re doing production at minimum, you want the Graphical Scheduler that’s completely free, very easy to install, very easy to configure.

When you install it, by default, it allows you to drag and drop your production orders. You can use it for any data within Business Central. So you can have, projects in there, you can have pick documents, almost anything you like. You can add to that Graphical Scheduler and you can also embed it in your own solutions or extend it. We’ve got a lot of sample code publicly available to allow you to extend that Graphical Scheduler.

You don’t need to license it from us, you don’t even need to tell us what you’re doing. It is free. You can use it for whatever you like.

What automated production scheduling does

Now, the other one below it, MxAPS, APS stands for Advanced Planning and Scheduling, but I like to call it Automated Production Scheduling. Because with something like the Graphical Scheduler, the idea is you’re dragging and dropping your schedule. You have a scheduling whiteboard that you’re going through and you’re moving things around manually. With MxAPS, it gets rid of that need to do that manual drag and drop, and it allows you to generate a schedule you can actually execute on the shop floor because it looks at all the things that happen on that shop floor, all your constraints.

So material constraints, if you want them, labor. So do I have enough people to perform the work? Floor space tooling, do I have the right molds or dies to perform this work? So it looks at all of those different variables and comes up with a schedule you can actually execute on the shop floor that’s very fast. A typical schedule is around a minute or less. You have high volume of orders. It might take a few minutes, but it is a very fast tool for generating a schedule that would take you hours to do manually.

And the idea behind that is we’re taking all that, built in knowledge from the people that are doing the drag and drop, that have been there for years and years and years and know how things work, know what has to happen, and we’re systemizing that. We’re moving all of that knowledge into the system so they can actually hit a button and generate the same quality schedule that you would do manually. In fact, a significantly better quality schedule than you’re likely to get manually.

Demo: presets and work center load

So those are the two tools we have available for scheduling. Let’s see what they look like. So I’m going to jump into Business Central here and we’re going to start with the Graphical Scheduler. And again, you can go in, you can install this, it’s completely free. And when you first install it, the view will look a little different than what you see here. I’ve modified this view slightly and I’ll show you how that works.

Now on here you can see, well, I’ve got some maintenance work orders in here and I got some production orders in here and things like that. But to actually see some data, I’m going to use one of these presets up at the top here. And these presets you get to define. You can have global presets, your own presets, and you can indicate where you want those presets to show up. So, for example, I’ve got these presets up here, or I can right click and I’ve got a few other presets down here.

And it’s just a nice quick little shortcut. Typically it’s going to be relative dates. So the next two weeks, what’s my schedule like? Or whatever, I’m going to jump back to April 15th because I’ve got some production data in that area. Now what you see here, I actually added this workload or this machine center loading and work center loading bar here. So we can see exactly how loaded our work center is. And you can see here we’ve got, the standard Business Central type schedule.

It’s infinite capacity. It’s layering all of these production orders, all of these operations, one on top of the other and I can click on this and see related operations.

Drag and drop rescheduling

And what you would typically do if you’re scheduling manually is I’d say okay, well I can’t run these five things on this work center at the same time. I need to move these off onto the individual machines they’re going to be working on. So I can’t do that drag and drop. I can reschedule and it’s going to reschedule everything on that production order. It’s not going to reschedule anything around it because it’s using the standard Business Central scheduling logic.

This is the same behavior as if I open up the production order routing and I made a change to the dates on an operation. This works the same way when I drag and drop, it’s changing the dates on that production order routing line and it’s rescheduling according to the Business Central scheduling logic. So that’s what it does. But yes, you’ve got drag and drop here. I can move things around, I can do all that stuff. Lots of controls for zooming.

If you’ve got a document, you’ve got a really high zoom level. I don’t want to zoom in. I can zoom to the document, I can zoom in, for various points from the mouse, all of those sorts of things. Really nice tool for navigation. Everything else next period, previous period on the views themselves. So where I said, my view looks a little different.

Views, colors and data sources

If you install this, out of the box, what you’ll see is you’ll see, these blue colored production orders and that’s about it. You won’t see the workload and you won’t see this, working hours. You can see it’s shaded here to show when it’s the non working hours. All of that I added myself. And the way we do that is with these views. So if I open up this view just real quick, we’ll show you what it looks like. So there’s some general information up at the top there, nothing real important.

But down here I’m listing everything we’re showing on that scheduler. So I’ve got the workload and if I come in here I can configure some of these. So the working hours. If I hit configure it’ll ask me how I want to display the non working hours, Those sorts of things. And I’ve got production orders and maintenance orders and things like that. And below I’ve got the colors. So my maintenance orders I changed to blue and planned and all of those sorts of things.

I’ve changed. Change some colors here so you can come in and change the colors, change what shows up here. If I wanted to add something else on here, maybe I want to add the shipment date or something. I can come in, hit add data source and I can add from a number of preset data sources. So projects and things like that, or assembly orders or whatever, or this first one, any table within Business Central. So whether that’s a table extension, like a custom table in an extension or a standard Business Central table, as long as it has, if you want it on a Gantt chart, like date fields and things like that, I can add any field I like to this view or create a brand new view with anything I like.

And then you can change the views as you see fit.

A load-only capacity view

So here I’ve got this view open, but maybe I don’t want to see all the production order details. I just want to see my loading for the next, few months or something like that. Well, I’ve got a little view for that. I’ve got one that I called loading. I open that up when the difference is here it doesn’t show me any production orders, it just shows me my load. So I can come in here, open this up and I’m zooming out. Not a lot of load in this particular database.

But if I open it up, I can see, all the loading percentages and actual load on all my work centers for whatever time frame I need to look at. So everything there and these of course change color based on the actual amount of load I have. So if I go back to this April 15th, it’s, it’s got some load there and we’ll just zoom out a little bit and you can see here’s my loading, on a daily basis for the, for a few days here.

So those are the views you can use. But again the bottom line on this is it gives me the ability to come in here and drag and drop my production orders, move things around and manually schedule the work.

Generating a 30-day schedule

Which is great. It’s an excellent tool. Completely free. Put it in. It’s the bare minimum you need for Business Central. But we don’t want to sit here and drag and drop all day. That can be painful if I’m a high volume environment. So what we do instead is we use MxAPS and I’m going to run a Production schedule here we’re going to pretend this is tomorrow at 8 a.m. so this April 15th at 8 a.m., that’s tomorrow at 8 a.m. Tell me what I need to do for the next 30 days in the shop.

This could be 300 days, this could be three days. You can schedule whatever you like. 30 days is pretty reasonable. And I hit go. And so what it’s doing is it’s taking all those production orders you saw previously, they were all stacked up in the work center and it’s determining what the best machine is to get that work completed. So in this environment I’ve got just under 60 production orders.

Reviewing late orders and what-if runs

It takes 20 seconds or so to run the production schedule. In a real environment it might be a few minutes or a minute or so to run that. And at the end I get a scenario here I can investigate. So I’ve got, some detail, high level detail about what’s early, what’s late, what’s on time, those sorts of things. And I can compare that to other schedules. Like on this particular one, sorry, I clicked on that. On this particular one, I’ve got eight late orders.

Well, I can drill down into that, see what the impact of those might be and maybe call the customer or maybe change the priorities on the orders, maybe add an overtime shift, rerun the schedule and see what the net result of those changes are. And I can do that as many times as I like. It doesn’t become effective until I either make it active or I commit the results. And then we’re going to update the production orders to have all the new dates and everything else so you can track them in standard Business Central.

Now to look at this schedule, we can, open it up and look at, all the details, but what you typically want to do is look at it visually.

The schedule in Graphical Scheduler

So when I do that, graph the results, it opens up the Graphical Scheduler, but now it’s using a view for my MxAPS results and I’m just going to hit this April 15th here again. And here are the same production orders because I said, hey, start at 8 a.m. on April 15 and it’s forward scheduled all those production orders and it’s respecting the capacity of the machines and it’s picking the best machine to do that work on.

Automatic machine selection and alternate routings

So it’s automatically selecting the appropriate machine. We do have the ability to do alternate routings. So for example, this text here, by the way, I didn’t mention you can change the information that shows up in these bars and in that pop up text as well. That’s just configuration in the view. But this guy here is a long bracket. And that long bracket can either run on this work center or it can run on this machine.

So some of these brackets, well, most of them will run on this machine here, this ten foot machine, right. The there is a case though where it will run on this machine. This machine takes twice as long to run and 50% longer to set up. The system chose it anyway because it resulted in a better overall schedule given how loaded up this 10 foot machine is down here. So again it automatically selects the appropriate machine, can have alternate routings with rules around how it chooses those alternate routings, those sorts of things.

Labor constraints at a shift change

And one last little thing here just to illustrate the constraints. Here we are where we’ve got capacities, we’ve got a capacity in Business Central on these machine centers to be able to run two production orders simultaneously throughout the day. Except here at 1600, at 4 p.m. our shift changes. Now we only have one employee available at this work center. So instead of being able to run two production orders at a time, we’re now only running one production order at a time.

Sequencing by material to cut setup time

Because we only have the labor availability to support one production order. This particular one also sequences. So if you see that al, that’s aluminum and we also have stainless steel, but here we’re doing alright. And that’s Al and ss, that’s stainless steel. So we’re sequencing by material type. We can sequence by color, temperature, material type. Any attribute you want to put in there, we can sequence the schedule by that.

And the reason is we want to eliminate that setup time. So this purple is setup time. So we can sequence orders in a way that eliminates that change over time within the system.

Running the schedule from the job queue

So that was a very brief overview of what MxAPS does. It does a lot. But the bottom line is either it runs on the job queue and every morning at 7 a.m., you’ve got a new schedule for the day or twice a day or whatever you want to do, or you manually go in there, you click go, and a minute later you’ve got a schedule you can actually publish to the shop floor that they can actually execute to. Because it’s taking into account all the constraints.

We’re modeling your shop floor within the software so that everything’s in the system and you’re not having to worry about somebody knowing what’s going on and dragging and dropping these things around to generate a good schedule.

Where to learn more

Now if you have any other questions on that, you can go to SchedulingForDynamics.com, that’s MxAPS, or SchedulerForDynamics.com. That’s just the Graphical Scheduler. Or just go to the main website and you can see all of our applications for manufacturing and that’ll help you determine, what you actually need for your scheduling requirements.

Questions about this webcast?

Send your question and the Insight Works team will reply by email. Ready to plan a project? Contact your Microsoft Partner.

Ask a question

Webcast Questions