Bug #5429
openprocurement(inventory)&payment
70%
Description
Designing and structuring MongoDB schemas to support dynamic inventory items, specifications, and assignment rules.
Implementing API endpoints to manage inventory lifecycle, including creation, update, assignment to services/projects, and stock adjustment logic.
Adding validation rules, enums, and flexible fields to support various inventory categories such as solar panels, inverters, batteries, and mounting hardware.
Ensuring automatic stock deduction and restoration based on project workflow (assignment, completion, or cancellation).
Creating schemas and linking payments with quotations, invoices, and projects to maintain accurate financial tracking.
Implementing logic for partial payments, balances, due amount calculation, and payment status updates.
Setting up secure API routes for recording transactions, generating receipts, and managing payment workflows.
Integrating the module in a way that supports future expansion, such as online payment gateways
Subtasks
Related issues
Updated by Kalyan Ravula 9 days ago
- % Done changed from 0 to 40
I worked on enhancing the billing and payment automation workflow by implementing Bill of Materials (BOM) extraction from planset, designing database schemas for financial and inventory structures, and integrating both online and offline payment systems.
Updated by Kalyan Ravula 7 days ago
- % Done changed from 40 to 70
I redesigned our invoice and payment architecture to support milestone-based payments (10-80-10). The system now generates an invoice automatically upon quotation approval and supports multiple payment transactions tied to each milestone, including flexible installment handling for the 80% phase. I also implemented backend logic to link each transaction to the appropriate milestone and update payment statuses dynamically. Additionally, I designed schemas for proposal inventory based on the PlantSet BOM so users can review, assign, or auto-assign inventory when the project reaches procurement. I integrated Stripe Checkout for card payments, added support for cash transactions, and developed a webhook to automatically update invoice and milestone statuses after a successful payment. implemented under-stock notification feature in the inventory management module to alert users when stock levels drop below the required threshold
Updated by Kalyan Ravula 7 days ago
- Estimated time changed from 20:00 h to 24:00 h
developed apis for lowstock inventory (that triggres when quantity hits threshold value),for updating inspection data and also provided apis for payment module