Feat : Delivery Date Difference Column in Procurement Tracker Report

Current Behavior: Currently, the Procurement Tracker report provides both the Expected Delivery Date and Actual Delivery Date columns. However, there is no column that directly shows the difference between these two dates.

As a result, users have to manually calculate the number of days between the Expected Delivery Date and Actual Delivery Date to determine whether a product was received on time, how many days early it was received, or how many days late it was received. This makes it less convenient to quickly assess delivery performance from the report.

Proposed Feature: Add a Delivery Date Difference column to the Procurement Tracker report that automatically calculates and displays the difference between the Expected Delivery Date and Actual Delivery Date.

The column should clearly indicate whether the item was delivered early, on time, or late, along with the corresponding number of days.

Expected Behavior: The Procurement Tracker should calculate the difference between the Expected Delivery Date and Actual Delivery Date and display it in a user-friendly manner.

For example:

On Time – 0: Actual Delivery Date is the same as the Expected Delivery Date. Early – -3 (Green): Actual Delivery Date is 3 days before the Expected Delivery Date. Late – 5 (Red): Actual Delivery Date is 5 days after the Expected Delivery Date. The calculation should be system-generated, with negative values displayed in green for early deliveries and positive values displayed in red for late deliveries, so users can quickly identify the delivery status without manually calculating the number of days.

Use Case: Procurement and purchasing teams frequently use the Procurement Tracker to monitor the status and timeliness of incoming products. While the report already provides the Expected and Actual Delivery Dates, users currently need to mentally or manually calculate the difference to understand delivery performance.

For example, if the Expected Delivery Date is 10 September and the Actual Delivery Date is 7 September, the report should display -3 in green, indicating that the product was received 3 days early.

Similarly, if the Actual Delivery Date is 15 September, the report should display 5 in red, indicating that the product was received 5 days late.

If both dates are the same, the report should display 0, indicating that the product was received on time.

Purpose: Provide better clarity and visibility into delivery performance by displaying the delivery date variance directly within the Procurement Tracker.

This will help users quickly identify early, on-time, and delayed deliveries without performing manual calculations, making the Procurement Tracker more informative and efficient for day-to-day procurement monitoring.

Since the report already contains both the Expected Delivery Date and Actual Delivery Date, adding an automatically calculated difference column would be a relatively straightforward enhancement while providing significant usability benefits.

Screenshot for Reference: