Skip to main content

Notifications

Business Central forum
Suggested answer

Order to Ship Reporting - Managing On-Time and Delayed Deliveries/Shipments

Posted on by Microsoft Employee

Hello all! 

We are looking at streamlining the way we keep track of shipments within D365 Business Central. Essentially, we are wanting to track which orders are currently delayed, which are on-time, etc. We need to have this done in a way that allows us to track from the purchase order (vendor) to transfer order (we handle) to the sales order (client). Ultimately, we would want to compare the following: 

  1. Purchase Order side - view promised receipt date, expected receipt date, actual shipment date, posted receipt date to determine whether the delivery of goods to us is currently delayed or on-time
    1. If expected receipt date > promised receipt date = delayed
  2. Transfer order - view the shipment date and receipt date and compare against the shipment date on sales order (if receipt date > shipment date = delayed)
  3. Sales Order - view promised delivery date, expected delivery date, actual shipment date, posted shipment date 
    1. If expected delivery date > promised delivery date = delayed

Additional Notes:

  • We would want to ensure that information regarding the involved freight carrier (aka agent), vendor, and client is all on the report to ensure we can track where the delays most often occur. 
  • We will want a "ready to ship" status as well, along with tracking/filtering which orders are ready to ship and when (based on shipment dates I enter).
  • Report on "current" shipments, shipments that need to be arranged within the next two weeks, 30 days, 60 days, and 90 days.

Is there anywhere in the Dynamics that would allow me to report on any of this? Even if it a bit more minimal (no trigger points) but I am able to see all of these dates in one place and see the status of said shipments. We currently have D365 - Business Central; are there better modules for this?

  • Guy-JM Profile Picture
    Guy-JM 95 on at
    RE: Order to Ship Reporting - Managing On-Time and Delayed Deliveries/Shipments

    I guess there is a strategic question around how you actually manage the process.

    if you are using the planning worksheet to create the transfer and purchase orders to meet the sale demand, a reordering policy of order and the use of reservations will tie the supply and demand together.

    if you then need to amend a date that negatively impacts the ability to deliver to your customer on time, the reservation will force you to update all dates and should force dialogue with the customer as you can’t just amend dates in the background.

    You are moving into a world of exception management.

    However, this is a more controlled methodology than you may be used to but is excellent if you are able to work in this way.

    Use promised dates to recognise OTIF compliance when you are building reports.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Order to Ship Reporting - Managing On-Time and Delayed Deliveries/Shipments

    Kasandra,

    First, if you are looking for a single report view, then Jet Reports will be the solution or Power BI. You then can combine the data into a single report view.

    As for each of the 3 views:

    Purchase - On the Purchase Order List, click the ALL and you should see Late Receipt view. Here you will see a list of all PO's Late based on Expected Receipt Date. As for the formula Expected Receipt Date > Promised Receipt Date, views are not comparing fields like the formula so you can show the field only. This formula is better served in a Jet Reports.

    pastedimage1620143076832v1.png pastedimage1620143371447v2.png pastedimage1620143529099v3.png

    Transfer Order - You can only view the Transfer Orders Ship and Receipt Date and not compare to the Sales Order associated. This can only be achieved in Jet or Power BI.

    Sales Order - Same as Purchase click on the Sales Order List, then create a Filter to show Late Shipments, as below. NOTE: Sales Orders use Requested Delivery Date. The Promised Delivery Date is on the Lines. This too will rely on Jet Reports or Power BI to combine information. However, you could also make a Sales Order List view filtered on the field Late Shipping = YES. This reads the Sales Line table of the order. You could ask the Partner to allow for the Sales Line List Page to be available and you can create filters there.

    pastedimage1620144349475v4.png  pastedimage1620144415361v5.png  pastedimage1620144599692v6.png

    pastedimage1620144651658v7.png

    Since you are comparing information from Header and Lines and different documents (i.e. Transfer to Sales Order), using Jet Reports or Power BI would be the optimal solution.

    Hope this helps.

    Thanks,

    Steve

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,129 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans