59 lines
1.4 KiB
Markdown
59 lines
1.4 KiB
Markdown
# Project: Requisition and Purchase Order System
|
|
|
|
**Created:** 2026-02-24
|
|
**Source:** #work-assistant
|
|
**Status:** Development Phase
|
|
|
|
---
|
|
|
|
## Overview
|
|
Web application for employees to submit requisitions and receive purchase order numbers for company purchases.
|
|
|
|
## Purpose
|
|
- Allow employees to fill out requisitions
|
|
- Generate purchase order numbers
|
|
- Track order status for employees
|
|
- Sync with existing vendor software
|
|
|
|
## Technical Details
|
|
|
|
### Frontend
|
|
- Employee requisition forms
|
|
- PO number generation
|
|
- Order status tracking
|
|
- Uses own database (Assal/SQL)
|
|
|
|
### Integration
|
|
- Connects to external vendor's **MSSQL database**
|
|
- Bidirectional data synchronization
|
|
- Working with vendor on sync architecture
|
|
|
|
### Current Approach
|
|
- Simple table synchronization (potential solution)
|
|
- Coordinating with vendor on database structure
|
|
|
|
## Current Status
|
|
🔄 **Development Phase**
|
|
- Actively working with vendor
|
|
- Figuring out data synchronization strategy
|
|
- Database sync architecture in progress
|
|
|
|
## Tasks
|
|
|
|
- [ ] Finalize vendor database sync approach
|
|
- [ ] Implement table synchronization
|
|
- [ ] Build requisition submission forms
|
|
- [ ] Create PO number generation logic
|
|
- [ ] Add order status tracking
|
|
- [ ] Testing with vendor system
|
|
|
|
## Notes
|
|
|
|
*(Add vendor contact info, database schema details, sync strategy, etc.)*
|
|
|
|
## Related
|
|
|
|
---
|
|
|
|
*Extracted from Projects to be organized*
|