web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Suggested answer

How does D365 Calculate Vendor On time performance

(0) ShareShare
ReportReport
Posted on by 10

I am new to the D365 community and I am trying to understand how it calculates vendor on time delivery.   We are presenting KPI's on vendor performance and have conflicting views on how this works and the PO dates fields to manage.

Thanks in advance,

Don

I have the same question (0)
  • Suggested answer
    Andreas Raithel Profile Picture
    4,963 Moderator on at
    RE: How does D365 Calculate Vendor On time performance

    Hy Drich,

    there are several ways to measure Vendor performance.

    OOB are these reports available:

    - supply performance, which shows average lead time and delay days per Vendor

    - Vendor delivery performance on receipt, shoas also percentage of late and on time

    For more detailed Vendor performance analytics I would prefer to work with the purchase cube which can be used with PowerBI. Here are multiple measures defined for specific use cases for order confirmation and product receipt performance.

    These are the available measures for Purchase order and receipts:

    [PURCHASELINETOTALDAYSFROMFIRSTCONFIRMATIONTORECEIVED]
    [PURCHASELINETOTALDAYSFROMFIRSTREQUESTEDDELIVERYDATETORECEIVED]
    [PURCHASELINETOTALNUMBEROFPRODUCTRECEIPTS
    [PURCHASELINETOTALNUMBEROFCONFIRMATIONSBYPURCHASELINE]
    [PURCHASELINETOTALDAYSFROMFIRSTCONFIRMATIONTOFIRSTRECEIPT]
    [PURCHASELINETOTALDAYSFROMFIRSTRECEIPTTORECEIVED]
    [PURCHASELINETOTALDAYSFROMFIRSTCONFIRMATIONTODELIVERYDATEISCONFIRMED]
    [PRECISIONOFRECEIPTBASEDONREQUESTEDDELIVERYDATEONFIRSTCONFIRMATION]

     

    This is the reader friendly version of the measures:

    [PURCHASELINE TOTAL DAYS FROM FIRST CONFIRMATION TO RECEIVED]

    [PURCHASELINE TOTAL DAYS FROM FIRST REQUESTED DELIVERY DATE TO RECEIVED]

    [PURCHASELINE TOTA LNUMBER OF PRODUCTRECEIPTS]

    [PURCHASELINE TOTAL NUMBER OF CONFIRMATIONS BY PURCHASELINE]

    [PURCHASELINE TOTAL DAYS FROM FIRST CONFIRMATION TO FIRST RECEIPT]

    [PURCHASELINE TOTAL DAYS FROM FIRST RECEIPT TO RECEIVED]

    [PURCHASELINE TOTAL DAYS FROM FIRST CONFIRMATION TO DELIVERY DATE IS CONFIRMED]

    [PRECISION OF RECEIPT BASED ON REQUESTED DELIVERY DATE ON FIRST CONFIRMATION]

    For analytics this measures can be combined with al lot of dimensions from Vendor, items, procurement category, ....

  • drich Profile Picture
    10 on at
    RE: How does D365 Calculate Vendor On time performance

    Thank you for your response.  Is there simple layman’s explanation, such as:   Receipt Date minus Original Confirmation Date or it’s calculated as Receipt Date minus Confirmation Date.   Are there other factors with PO dates and actual receipt date that add to the results?

    Thanks,

    Don

  • Suggested answer
    Andreas Raithel Profile Picture
    4,963 Moderator on at
    RE: How does D365 Calculate Vendor On time performance

    Hy,

    I would take

    [PURCHASELINE TOTAL DAYS FROM FIRST CONFIRMATION TO FIRST RECEIPT]

    for your calculation.

    Of course all date fields (receipt date, confirmation date, ...) are available as raw data so you can create your own calculation.

  • Suggested answer
    Andreas Raithel Profile Picture
    4,963 Moderator on at
    RE: How does D365 Calculate Vendor On time performance

    Hy again,

    there is one more further precalculated value available:

    [PRECISION OF RECEIPT BASED ON REQUESTED DELIVERY DATE ON FIRST CONFIRMATION]

    which is calculated to early, on time or late.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 883

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 279 Super User 2025 Season 2

#3
Sagar Suman Profile Picture

Sagar Suman 228 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans