Skip to content

On demand · Product video

Show sales orders in Graphical Scheduler

For sales, customer service, and operations teams that want to see upcoming sales orders on a timeline, without touching the production schedule.

Recorded January 22, 2026 · 5 minutes

Graphical Scheduler sales orders video thumbnail

Summary

Graphical Scheduler can show data from any table in Business Central, not only production. This is a completely free app from Insight Works for Business Central. The video creates a sales order view with the Anything data source on the Sales Header table: order date as the start, shipment date as the end, and orders grouped by customer, then by location. It sets the view to read only, puts the customer name in each cell, and adds the bill-to name, due date, order date, and shipment date to the tooltip. Use the Sales Line table instead to see individual lines or orders that ship in parts.

Key topics

  • Add an Anything data source on the Sales Header table
  • Use order date and shipment date for the start and end
  • Group sales orders by customer or location
  • Choose what the cells and tooltips show
Read the transcript

We are going to review how we can use the Graphical Scheduler to show sales orders. What we’re going to do is click on View, create a new view, and we’ll just call this Sales Orders. By default, it’ll show production data. We’re going to click on Add a data source and choose Anything. Anything quite literally means any table inside of Business Central. So we’re going to choose the three dots and type in sales. You could use shipments, you could use invoices, you could use warehouse shipments. Just for this video, I’m going to choose Sales Header.

We’re going to have the document number field be the document number field, and you’re choosing the order date as the starting date, maybe, and for the ending date, typically people choose due date or maybe shipment date. So let’s change it to shipment date. The “when is it” is the start of the block and the end of the block, with the starting date time and ending date time, and the “where is it” is the left-hand side. If you want it to be the location code, you would choose location. You can also choose something else if you want to organize by customer or something like that. Now, if you wanted to organize by item, you would need to choose the sales line instead of the sales header.

If we wanted to make changes, we would just choose allow writes and then define exactly what we want to change. But for now, we’re going to say this is read only, so it’s only going to let us look at the sales orders. Then we’re going to remove this default production line, so now we just have this Anything provider for sales orders. Now we’re going to click on it, and we can see our sales orders.

Just like any other view, you can still configure what goes inside of it with a cell template. If I wanted to see the customer name, we’ll type in name, sell-to customer name, inside of the cell. And maybe in the tooltip I want to have something like customer, and then add in the name there. Maybe I’ll choose bill-to name, and then I could add the due date field, the order date, and maybe the shipment date. Right now for this example, we’re looking at the sales header. If you had individual shipment lines, so if you’re not shipping the whole order at once, you would use the sales line table instead. We’re going to close that off and refresh it, and then we should see our sales order with the customer name, and in our tooltip, all of those details.

So that is how you can show sales orders with shipment data. It’s the same process if you want to look at shipment headers; just use a shipment table instead. If you only wanted to look at orders, not quotes or invoices, you just add in a filter, just like any other data source. And if you wanted to see the individual lines and group by line information instead, you can do that as well. Right now we’re grouping by the sell-to customer number. Let’s group it by location instead. This is the location that’s on the header. Then you’ll see how it’s grouping by location instead: I’ve got this order in the main location, this order in the north location, and this order in the west location. All of that’s configurable. You can use any table that’s in Business Central or any table that’s in any other app or extension, and that will work. Thanks for your time.

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