1) Objective
- Enable medical store users to manage semen stock, sell to vets, and monitor business performance.
- Provide reliable inventory control with stock movement traceability.
- Provide actionable reporting for sales, expiry, and revenue trends.
2) User Roles
- Medical Store User: inward stock, adjustments, sale creation, report view.
- Vet: buyer/customer in sale transactions.
- Admin: system oversight, role assignment, audit monitoring.
3) Core Features
- Inventory: batch-wise inward stock, expiry tracking, low stock view.
- Sales: invoice generation, stock validation, automatic stock deduction.
- Adjustments: correction, damage, and manual adjustment with reasons.
- Reports: daily/monthly sales, item-wise movement, vet-wise purchases, stock aging.
4) Suggested Data Objects
- StoreSemenInventory: store, semen type, batch, expiry, quantity, unit cost.
- SemenStockMovement: inward/sale/adjustment/return with reference details.
- MedicalStoreSale: invoice header, vet, date, net amount, status.
- MedicalStoreSaleItem: semen line items with qty and price.
5) Suggested API Groups
- /api/medical-store/inventory - inward, list, adjust, movement history.
- /api/medical-store/sales - create sale, list sales, sale details, cancel sale.
- /api/medical-store/reports - stock summary, sales summary, expiry report, PDF export.
6) Main Flow
- Store user adds inward batch with qty and expiry.
- System updates inventory and writes stock movement record.
- Store user creates sale invoice to a vet.
- System validates quantity and deducts stock in a transactional flow.
- Store user generates report and exports PDF for business review.
7) KPI Dashboard Targets
- Today sales amount and invoice count.
- Low-stock items and expiring batches.
- Top-selling semen items and top buyer vets.
- Weekly and monthly revenue trends.
8) MVP Implementation Plan
- Phase 1: inventory + sale create/list + basic reports.
- Phase 2: payment tracking, returns/credit note, CSV export.
- Phase 3: forecast analytics and reorder recommendations.