Farm Inventory and Stock Level Management Process

Start of the Workflow/Process.

Retrieve all active entries from the 'Inventory Items' data model to check current quantities.

Sum the 'Unit Price' * 'Quantity' for all items in the inventory to get total inventory valuation.

Filter the 'Inventory Items' data model to find entries where 'Current Quantity' is less than or equal to 'Reorder Point'.

Calculate the difference between 'Target Stock Level' and 'Current Quantity' to determine how much to order.

Assign a task to the Procurement Manager to initiate a purchase for identified low-stock items.

Generate a new entry in the 'Purchase Orders' data model for the requested supplies.

Update the 'Status' field of the inventory item to 'Restocking' once a purchase order is created.

Send an email to the vendor's email address found in the 'Supplier' data model with the order details.

Create a task for the Warehouse Clerk to verify physical goods upon delivery.

Update the 'Current Quantity' in the 'Inventory Items' data model after physical verification.

Aggregate usage data from 'Stock Movement' entries to find the average usage per month.

Create a report comparing 'System Stock Level' vs 'Physical Count' results from the audit task.

Send an SMS to the Farm Owner if a critical item (e.g., essential feed or medicine) hits zero stock.

Delete or archive entries from the 'Inventory Items' data model that are marked as unusable/expired.

Create an entry in the 'Stock Movement Log' whenever an item is added or removed from the inventory.

End of the Workflow/Process.