# 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*