Order reception and case management system for a dental laboratory

We are a dental laboratory that custom-manufactures crowns, bridges, removable and partial dentures, and other prosthetic structures for dental clinics. Currently, each case exists on paper: a doctor calls or sends a request, someone manually writes down the patient number, type of work, tooth numbers, shade according to a scale, and material, and this form circulates through the lab until the work is completed. Cases get lost, shades get confused, deadlines are missed, and when a clinic asks where their order is, we have to go to a technician's desk and search manually. We need a case reception and tracking system that will turn this paper flow into an understandable and searchable record accessible to all lab employees. The heart of the system is case reception. When an order arrives, we want to record the clinic and referring dentist, patient number, type of work (single crown, bridge, full or partial denture, implant abutment, etc.), affected teeth, selected shade, material, and any written instructions or attached photos. Each case must receive its own number and status that progresses through the actual production stages of our technicians — work with model and dies, wax modeling or design, casting or milling, ceramic application and glazing, finishing and quality control, then readiness for shipping. We need to assign each stage to a specific technician by name, set a delivery deadline for the entire case, and see at a glance which cases are on schedule, approaching deadline, or already overdue. On top of tracking, we need shipping and invoicing. When a case is ready, we mark it as completed, record how it was shipped back to the clinic, and confirm delivery; this same record should feed into a simple invoice with the price of work for each case and a monthly statement for each clinic. We are a laboratory, not a clinic — we don't treat patients, we manufacture for dentists — so the system should speak the language of dental technical work and case movement, not patient visits. Expected features from the system: — Case reception form: clinic, dentist, patient number, type of work, teeth, shade, material, and instructions with photo attachments; — Customizable production stages with assigned technician and status for each case; — Delivery deadlines with highlighting 'on schedule', 'approaching deadline', and 'overdue', as well as technician workload view; — Shipping accounting and price per case, consolidated into monthly invoices by clinic.