company project · ongoing
Jewelry Fulfillment ERP (StackLogix)
PostgreSQL-backed jewelry fulfillment ERP (StackLogix) — my contribution focused on the procurement operations dashboard and Finance Manager purchase invoice UI within the broader fulfillment platform.
Procurement — Operations dashboard
Finance — Purchase invoices
Problem
Jewelry fulfillment teams needed visibility into purchase order status, job card pipelines, and vendor invoice payment tracking — with clear dashboards instead of scattered operational data.
Solution
Built procurement dashboard UI with PO status charts, vendor breakdowns, job card pipeline metrics, and KPI cards; and Finance Manager purchase invoice screens with filtering, payment status tracking, and invoice actions.
Architecture
React + Vite + Redux frontend consuming StackLogix REST APIs. Procurement dashboard uses Recharts for PO trends, vendor bars, and job card pipeline gauges. Finance module provides purchase invoice table with payment status (Paid/Partial/Unpaid), vendor filters, and upload/print actions. Backend: Express + PostgreSQL (Sequelize) within the fulfillment-stacklogix platform.
Business Impact
Gave operations and finance teams at-a-glance visibility into procurement health and vendor invoice payment status across high-volume jewelry fulfillment workflows.
Technical Decisions
- Recharts for PO trend lines, vendor bar charts, and job card pipeline visualization
- Separate Finance Manager module UI with dedicated invoice filtering and status taxonomy
- Dashboard KPI cards for quick operational health checks before chart drill-down
Feature Breakdown
Responsibilities
- Built procurement operations dashboard — PO status overview, vendor breakdown, monthly PO trends, and job card pipeline metrics
- Implemented KPI cards for active POs, sales orders, open job cards, and finished-goods inventory
- Developed Finance Manager purchase invoice UI with reference/vendor filters and payment status views
- Built purchase invoice data table with Paid, Partial, and Unpaid status indicators and invoice actions
Challenges
- Presenting dense PO and job card metrics without overwhelming the dashboard layout
- Designing finance invoice tables that handle thousands of records with clear payment status at a glance
Performance Considerations
- Paginated invoice tables for 10,000+ purchase invoice records
- Chart data aggregation at API layer for dashboard load performance
Lessons Learned
- Procurement dashboards benefit from pairing summary KPIs with drill-down charts (vendor, trend, pipeline)
- Payment status color-coding (Paid/Partial/Unpaid) is essential for finance invoice review at scale