Project Objective
To modernize and optimize the Material Issue Request (MIR) process across multiple warehouses and maintenance teams — ensuring accuracy, traceability, and compliance.
Challenges
- Concurrency issues when multiple users updated MIR stages simultaneously.
- Lack of controlled workflow for handling partial receipts, returns, and batch tracking.
- No automated validations between Aircraft Type / Tail Number and Part Number compatibility.
- Manual Alternate/Substitute part management.
- No traceability of manual batch selection or print history.
- Need to import large volumes of data daily from external systems.
Solution
We implemented an advanced Custom MIR Management System fully integrated into Odoo:
Core Enhancements:
- Stage Validation: Prevented incorrect stage transitions using dynamic checks
- Partial MIR Handling: Enabled splitting of MIR lines with automatic linking and referencing
- Aircraft-Part Validation: Implemented automated checks to ensure only compatible parts are issued to specific aircraft types/tails
- Alternate/Substitute Parts: Built two-way linking within Odoo Product Master, allowing stock visibility both ways
- Batch Selection Control: Implemented FIFO alerts and tracking when users override system-picked batches
- Print Tracking: Recorded the number of print actions per MIR to ensure auditability
- Return Management: Improved partial return flow, introduced separate Kanban stages for tracking returns
- Excel Upload: Restricted upload permissions for Excel-based MIR line imports, ensuring role-based access.
New Modules: - Avionics Return Material Authorization (RMA)
- Component ON/OFF Record — both developed as new Odoo modules.
Data Integration:
- Automated daily imports of:
- Pending Purchase Orders
- Repair Orders
- Vendor Master data
- Engine Utilization
- Asset Lists
Note: External data imported via automated file processing integrated with Odoo backend (no FTP term used in client-facing material).
Outcomes
- 30% reduction in incorrect or duplicate MIR returns.
- 80% faster reconciliation of partial deliveries and returns.
- Improved regulatory compliance and full traceability of MIR lifecycle.
- Enhanced user experience with dynamic validations, real-time alerts, and visual workflow tracking.
Odoo Modules Used
- Odoo Inventory
- Odoo Products
- Odoo Purchase
- Custom MIR Management Module
- Custom RMA & Component ON/OFF Modules
Read more about KTree
KTree, a Global IT Company
What and how the processes are structured in KTree?
KTree's processes follow CMMi to ensure consistent, high-quality outcomes. With a focus on quality coding , code reviewing, and performance and load testing in our QA processes, we deliver reliable, scalable, and high-performing applications to meet our clients' needs.
Where is KTree's Web and Mobile application Development done?
KTree's web and mobile application development primarily takes place at our Hyderabad development center. Hyderabad is not only abundant in IT talent but is also known for its rich heritage and exotic food.
How KTree makes outsourcing project a positive experience?
KTree delivers high-quality applications that meet our clients' needs, by prioritizing collaboration, communication, visibility, traceability, and requirements engineering. While we charge a little premium for our services, we believe that it is important to provide the necessary resources and expertise to ensure project success.
What is Success mantra of KTree, as one of the respected web development company?
The success mantra of KTree as a respected web development company is combining Agile methodology with strong documentation, powerful web and mobile frameworks, and a solid KTree team to deliver great web and mobile applications within a specified timeframe.
Any other Differentiation which KTree has, which it can offer?
KTree's tremendous knowledge and expertise, gained from working on hundreds of web and mobile application projects, gives us a significant advantage that allows us to provide a head-start on projects, saving our clients many man-months.
What Development methodology KTree follows and why?
KTree's development team follows the Scrum framework of the Agile methodology, which improves Agility through its simplicity and flexibility. This allows us to adapt to changing project requirements and deliver high-quality products within the specified timeframe.
Leverage the expertise of a Top Application development company for your enterprise web and mobile application needs.
Contact our solid KTree team to get started.
