On demand · Product video
Manage backorders in Order Fulfillment Worksheet
For order processing and warehouse teams that want to know which backordered sales orders they can ship as soon as stock arrives.

Summary
This video uses Order Fulfillment Worksheet to manage backorders in Business Central. It starts with a sales order that has three units of a cable still to ship and negative availability, then opens Order Fulfillment Worksheet for the main location to see which sales orders are fully, partly, or not available. After a purchase order receives five units, the worksheet allocates the new stock to the orders by date, so the first order becomes fully available, a second order also becomes fully available, and a third becomes partly available. Sorting by availability shows the orders that can ship, ready for pick tickets, warehouse shipments, or shipping labels.
Key topics
- See which sales orders are fully, partly, or not available to ship
- Watch received stock allocate to backordered orders by date
- Sort by availability to find the orders you can ship
- Move ready orders on to picking and shipping
Read the transcript
Hi. In this video, we’re going to cover off how to manage backorders in Business Central. As many of you probably know, it’s not easy to manage backorders in Business Central by default. There’s really no tools within Business Central to do that, other than maybe creating a view on your sales lines to see what hasn’t shipped by today, those sorts of things. Today we’re going to look at a much better tool that you can use to actually manage, or more seamlessly process, those backorders.
So first, let’s look at what we’ve got in the system. I’m going to go into our sales order list here and have a look at all the sales orders in the system for my main location, and we’ll just grab this first one. When we open it up, we’ll see that we have some backordered items on this particular sales order. If we look down here at the lines, we’ve got this LS2 cable, and if we scroll over, you can see that we’ve shipped a couple of these in the past and we’ve got three left to ship. Now, that’s clearly a backorder, because these should have shipped quite a while ago.
If we look at the FactBox for that particular line, we can come down here and see that yes, we’ve actually got an availability of negative six. We’ve got gross requirements for six of these here. And we don’t know, if we get some in, are we going to be smart enough to make sure we fulfill this order first versus one of the other orders that’s already expecting this? So we need to know by date who should get that stock, or maybe even priority, like customer priority or something like that.
So how do we do that? Well, let me close this out and go into our Order Fulfillment Worksheet. The easy way to find it is just to search for Order Fulfillment Worksheet, and there we have the Insight Works Order Fulfillment Worksheet. Let me open that up. I’ve got it for our main location here, but you can use it on any location, everything from no bins, like the very basic inventory location, all the way up to your directed put-away and pick locations.
In this particular one, it’s gone through, it’s grabbed all of our sales orders, and it’s told me what I can actually supply. So here’s that first order we looked at, and it’s telling us we need three and we’ve got none available at all. Over here we’ve got a partially available quantity, so we’re missing a few items here. We’ve got another one that’s partly available; you’ll notice this one is also missing that LS2, so we’ve got a quantity of one required here, and so on and so forth, all the way down to sales order eight there, which is about to open up because I just clicked on it. Let’s close that and go back to our Order Fulfillment Worksheet.
All right, so order eight here, we’ve also got this LS2. We need a couple there. So in total we’ve got six required. There’s our six: we’ve got three on this order, one on that order, and a couple on this order. And that’s the order we’re going to fulfill it in, if we look at the date, but we might also do priority or something else.
So what happens now if I get inventory in that allows me to fulfill some of these backordered sales orders? Let’s have a look at that. I’m going to go into my purchase order list here, and we’re going to grab a purchase order and open it up. I believe this one should have the product on it.
So now somebody in receiving is coming in. They’re using our WMS Express, which is our free tool, or the full Warehouse Insight tool, to receive through scanning. Or maybe you’re still paper based, and somebody’s come in here and manually entered, yes, we got five of these LS2s in for my main location. I’m going to receive them. So they come in here, they manually post, and we’ll just do receiving, and we’ll receive those five into stock. It goes ahead and posts that inventory into stock.
Now let’s have a look at what that did for our fulfillment worksheet. So again, search for Order Fulfillment Worksheet and open it up. Now what we can see, if we go to the top here: hey, our order is now fully available to ship. It’s telling us that we need three, we’ve allocated three to this order, and we’ve actually got five available in the system, because we just received five to pick.
Then if we go to sales order four here, that one is now also fully available, because we can allocate one of those LS2s we just received to it. You’ll notice here this quantity available to pick is now two. It’s gone down because we used three of them on that first order, so there’s only two left available for this order, which is great; we only need one. And now if we go to this order number eight here, it says partly available, because we can supply one of those LS2s for this particular order.
So that’s how it does it. It goes through looking at how you’ve ordered your sales orders here and figures out what you can supply and what you can’t. By default, it’s by date, which allows you to very easily manage those backorders as new product comes in. A few times a day, you might come in here and just say, what can I ship today? What backorders have arrived that I can deal with today? And then of course you can just sort by availability here, and these are the orders that I can ship. Then I can go in, print the pick ticket, generate shipping labels if you’ve got Order Ship Express or Dynamic Ship, those types of things, and away you go.
So it’s very quick and easy to come in here and manage your backorders. I didn’t mention a few other things that we’ll cover off in other videos, like being able to assign priorities to individual customers, or maybe you want to do all your UPS orders first or something like that, but that’s entirely possible as well. This is a very quick way of managing backorders. It lists all the orders that are backordered, that have quantities on there that should have been shipped. As inventory comes in, it simply alerts you that you’re able to ship it, and you can generate pick tickets, warehouse shipments, whatever you need in order to get that product out the door.
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
More recordings
Webinar recording · 68 minKnow what you can ship today: Order fulfillment in Business CentralDynamic Ship · Order Fulfillment Worksheet · Order Ship ExpressRecorded July 2026
Webinar recording · 52 minStop guessing, start shipping: Fix fulfillment in Business CentralDynamic Ship · Order Fulfillment Worksheet · Order Ship Express · Warehouse Insight · WMS ExpressRecorded November 2025
VideoOptimizing distribution with Business CentralDynamic Ship · Graphical Scheduler · Order Fulfillment Worksheet · Order Ship Express · WMS ExpressRecorded March 2025