Seed Inventory and Sourcing Workflow

Start of the Workflow/Process.

Retrieve existing entries from the Seed Inventory data model to check availability.

Sum the quantity property of all retrieved seed entries to determine total stock levels.

Compare current total volume against the predefined minimum threshold to identify shortages.

Generate a new entry in the Sourcing Request data model for items identified as low stock.

Create a task for the Procurement Lead to review and approve the new sourcing request.

Retrieve available seed types and pricing from the Supplier Data Model.

Update the status of the Sourcing Request entry to 'In Progress' once a supplier is selected.

Send an email to the selected vendor with the order details and quantity requirements.

Create a task for the Warehouse Manager to inspect the quality of incoming seeds upon arrival.

Increase the quantity property in the Seed Inventory data model once the shipment is verified.

Create a new entry in the Shipment History data model for auditing purposes.

Sum the total costs of all active sourcing requests to monitor procurement budget.

Generate a summary report of all completed sourcing tasks and inventory fluctuations.

Send an automated email alert to the Inventory Manager when stock hits critical levels.

Delete entries from the Seed Inventory model for seeds that have expired or are no longer sourced.

End of the Workflow/Process.