Home › Discussions › Questions & Answers › Measuring Supplier On-Time Delivery (OTD) Performance using Procurement Blitz Reports

Measuring Supplier On-Time Delivery (OTD) Performance using Procurement Blitz Reports

Avatar photoCustomer Questions & Answers 7 replies

Our procurement department mandates quarterly reviews of vendor reliability, centered on measuring the accuracy of promised delivery dates. We currently lack a streamlined system for accurately calculating the Supplier On-Time Delivery (OTD) performance rating, comparing the Purchase Order line’s promised date against the actual receipt date on a transactional basis across high-volume receipts. We require a robust custom reporting solution that can automate this metric calculation and present the results in a clear, formatted output to facilitate effective supplier management decisions and streamline our vendor review process.

7 replies

  • Support Enginatics

    Calculating performance metrics like Supplier OTD is highly efficient when leveraging a flexible reporting platform. A custom-developed Blitz Report can easily query both the Purchasing (PO) promise dates and the Inventory/Receiving receipt dates simultaneously, embedding the complex OTD calculation logic directly within the underlying SQL query.

  • Avatar photoCustomer

    If we define the OTD calculation within the Blitz Report SQL, can the output automatically highlight transactions that are deemed ‘late’ (e.g., received more than 5 days after the promise date) using a clear indicator?

  • Support Enginatics

    Yes, developers can utilize SQL’s conditional logic (e.g., `CASE` statements) directly in the report query to derive status indicators based on the date differential (e.g., ‘On-Time,’ ‘Late,’ ‘Early’). This calculated status is then presented as a clear column in the automatically formatted Blitz Report Excel output.

  • Avatar photoCustomer

    We handle thousands of PO receipts weekly. How does Blitz Report ensure that running this detailed Procurement Reporting analysis doesn’t impact our core purchasing team’s transaction speeds?

  • Support Enginatics

    Since the report executes via the efficiently managed Concurrent Manager framework, the heavy analytical load required for calculating Supplier Performance Rating is offloaded to background processing. This guarantees minimal disruption to the front-end Purchasing forms and transactional users, ensuring system responsiveness.

  • Avatar photoCustomer

    Can we schedule this OTD report to run automatically at the end of every fiscal quarter and have the results immediately sent to our purchasing director via email?

  • Support Enginatics

    Absolutely. Like any standard Blitz Report, the OTD analysis can be precisely scheduled using the concurrent submission form and configured to deliver the detailed, formatted Excel output directly via email upon job completion, supporting timely quarterly reviews automatically.

  • You must be logged in to reply to this post.