Pharmacy Inventory Management Workflow

Start of the Workflow/Process.

Retrieve all drug entries from the Inventory Data Model where current_stock is below the reorder_level.

Sum the product of (unit_price * current_stock) for all items in the pharmacy inventory.

Update the quantity_on_hand field for a specific medication entry after a sale or delivery.

Create a new entry in the 'Shipment Log' data model when new stock arrives.

Calculate the difference between the target_stock_level and the current_stock_level to determine how much to order.

Create a task for the Pharmacist Technician to physically check the expiration dates of items in the 'Cold Storage' zone.

Create a task for the Procurement Officer to review and approve the generated order list.

Send an automated email to the vendor's contact address with the list of required medications.

Send an email alert to the Pharmacy Manager when critical life-saving drugs reach zero stock.

Send an SMS to the warehouse driver when a high-priority replenishment order is ready for pickup.

Delete entries from the 'Active Inventory' model for items that have been flagged as expired or unsalvageable.

Generate a report summarizing the discrepancy between recorded stock and physical stock counts found during audits.

Aggregate the total cost of all 'Shipment Log' entries created within the current month.

Update the status of a medication entry to 'Expired' and move it to the 'Disposal' list.

Subtract the current system date from the medication's expiry_date to identify items nearing expiration.

End of the Workflow/Process.