PO Validation App

Internal Tool ID: ai-po-validator

Overview

The AI PO Validator is a business intelligence tool used to ensure that Customer Purchase Orders exactly match the terms of our Sales Quotes. It helps prevent ordering errors, price discrepancies, and tax miscalculations before they reach the warehouse or accounting.

How it Works

1. Drop Your Files: Drop the Customer PO (PDF) and the MDL Sales Quote (XLS) into the dashboard.
2. AI Extraction:
   • The PDF text is extracted using pdf.js.
   • The Excel quote is converted to a high-resolution image to preserve formatting.
3. Cross-Reference: Gemini 2.0 Flash analyzes both documents to verify:
   • SKUs: Do the item codes match?
   • Quantities: Is the customer ordering exactly what was quoted?
   • Pricing: Are any unit prices different?
   • Taxes: Has the customer applied the correct GST/HST for their province?
   • Shipping: Is freight included in their PO?

Running Locally

cd ai-po-validator
npm install
npm run dev

Port: http://localhost:3102

Key Differences from Quote Generator

While the Quote Generator handles Inbound Supplier Quotes, this tool validates Outbound Customer Orders. It is the "Last Gate" before an Order is accepted and fulfilled.