NetSuite PO Fulfillment Template Generator

📋 Instructions

Upload your Shipments CSV file (contains PO numbers, ASN status, and shipping locations)
Upload your Pending WF file (Excel XML or CSV format with Document Numbers and External IDs)
Click "Process Files" to match POs without ASN numbers to their corresponding SO numbers
The tool will automatically separate orders by location (Encore vs UNIS)
Download separate fulfillment templates ready for NetSuite upload

CSV file with PO numbers and shipment details

Drop your CSV file here or click to browse

Supports: shipments-last-30-days.csv

✅

Excel XML or CSV file with SO Document Numbers

Drop your Excel/CSV file here or click to browse

Supports: PendingWF*.xls, *.csv

✅

Processing your files...

⚠️

Total POs Found

POs Without ASN

Matched SOs

Unmatched POs

Template for shipments from Encore facility

Template for shipments from UNIS facility

All pending Amazon/AVC orders not included in Encore or UNIS templates (sorted by date, oldest first)