What if you could effortlessly track your shipping performance by this time next month?
Your customers want to know they can rely on you.
Holding your team accountable to perform is a great first step.
Within Business Central there is a straight forward method doing just that. Here, we will explain the basic structure. Feel free to reach out if you have questions regarding the setup.
Spotting your late shipments
A late shipment is simple. When you ship the product after your customer expected it, then it is late.
Simple right? Let's see how that is done.
Within Business Central, there are two documents that are that are used:
- Sales Documents
- Sales Shipment Documents
On these documents the important fields are:
- Requested Delivery Date
- Promised Delivery Date
- Shipment Date
The first two exist on the Sales Order. Here your team will be able to input the date that the customer is requesting to receive the items or the date that you promised for the items to be received.
When your team enters one or both of these fields in the Sales Order it will be included on the shipment of that order once it is posted.
A simply workflow. Add your promises, then pay attention to the date you actually ship. Best place to review that? More on that below.
Let's create some reports and see how reliable we are.
How to view Business Central shipments data in Power BI
For reporting, we recommend Power BI to all of our clients.
We've built the reports below and they are part of our On Time Delivery package (Scroll to the end to the review the package). To see how to DIY the reports, keep reading.
Within the report designer we will pull the data by clicking the Get Data button in the top Home ribbon. From there, search for Business Central.
Once you've selected and connected to your Business Central you will need to select the environment from which to grab the data.
From here the you need the table that has the Posted Sales Shipments. Within the Business Central data model, this is located in the workflowSalesDocuments.