Supply Chain Visibility and Tracking Process

Start of the Workflow/Process.

Retrieve all open Purchase Orders from the Purchase Order data model to begin the tracking cycle.

Update the 'Current Status' field in the Shipment entry to 'In Transit' once tracking info is received.

Create a new entry in the 'Incident Log' data model if a delay is detected during tracking.

Calculate the difference between the Original Promised Date and the Current Estimated Arrival Date.

Sum the total monetary value of all shipments currently in the 'At Sea' or 'In Transit' status.

Create a task for the Logistics Manager to review and verify the updated shipment documents.

Create a task for the Warehouse Team to prepare for incoming goods based on the updated ETA.

Send an automated email to the Vendor contact if the calculated ETA variance exceeds the allowed threshold.

Send an SMS to the logistics driver when the shipment is within 50km of the destination warehouse.

Fetch historical delivery performance metrics for the specific carrier assigned to the shipment.

Update the 'Expected Stock' field in the Inventory data model based on the confirmed arrival date.

Create a summary report showing all shipments, their current locations, and any active delays for stakeholders.

Delete or archive shipment entries from the 'Active Tracking' view once they have been marked as 'Delivered' for more than 30 days.

Execute a formula combining weather data, port congestion levels, and carrier reliability to produce a risk score.

Create a task for the Quality Control team if the 'Received Quantity' does not match the 'Ordered Quantity'.

End of the Workflow/Process.