Compare PO vs Incoming Stock (Exact Code Match)
Upload PO & Incoming. Exact code match only (no tolerance, no fuzzy). See categorized differences, and export a corrected PO that exactly follows the Incoming.
① PO List
No file
Aggregates by exact codes only.
② Incoming Stock
No file
Multiple lines per product are combined automatically (by exact code).
Exact code match • no tolerance
Ready.
Found in PO, Incoming has less qty (Yellow)
Price not match (White)
Found in PO, Incoming has more qty (Green)
PO found, Incoming missing (Red)
Not in PO, found in Incoming (Orange)
③ Detailed Results (Grouped by Category)
| Category | Product Code | PO Qty | IN Qty | Δ Qty | PO Avg Unit | IN Avg Unit | Δ Avg Unit | PO Total Value | IN Total Value | Δ Total Value |
|---|---|---|---|---|---|---|---|---|---|---|
| Upload both files and click “Process & Compare”. | ||||||||||
| Σ Totals | ||||||||||
Weighted Avg = Σ(Qty×UnitPrice)/Σ(Qty) · Totals = Σ(Qty×UnitPrice). Rows are ordered by category as listed above.