NCR / RTV Outbound

Jansenn Fermin

Utilities
Serials / WO / PO
NCR
📦 Paste Data
🪧 Plaque Maker
📥 Paste Data from Excel
✅ Pallet Checklist Generator
📊 Paste Pallet Infos (Pallet#1 until Pallet#25)
⬇ Excel-ready Output
📥 Optional: Upload Reference Excel (P/N · Serial · WO)
No reference loaded
🔢 Scan Part Number → Serial Number
Scanned Count
0
Last Scan
—
⬇ Excel‑ready Output
📥 Optional: Paste alternating P/N + S/N
Paste Pallet Data (Matrix or Simple)
—
Total Units
—
Has WO
—
Missing WO
—
Pallets Found
—
Pallets w/ Gaps
01Paste from Excel
Works with wide pallet layout (P/N · Serial · WO · blank) or simple 3‑col P/N · Serial · WO.
02Missing Work Orders
0 missing
Run Audit to list all missing rows.
PalletP/NSerialStatus
P/N · S/N · WO Extractor (PO Request)
01Paste from Excel
Supports wide (pallet matrix) or simple 3‑col data. The summary updates live; click Extract for a full table.
02Extracted P/N · S/N · WO
0 units
Click Extract to build the table.
P/NSerialWork Order
Amcor Finalizer (RRS / JDE split)
01Upload Amcor File
Waiting for file…
DATE RRS serials
DATE JDE serials
Amcor PO / RMA Plaque (Letter size, 2 per page)
Amcor Finalizer (RRS / JDE split)
...
...
Amcor Pallet Finder (from Repair Order PDF)
Waiting for input…
Fujitsu Finalizer (RMA Request)
01Paste pallet matrix
Paste the wide pallet layout for Fujitsu (like fujitsutemporary1.txt: Pallet# columns, then P/N · Serial · Work Order headers).
Output will be a flat list with P/N · Serial · On Hand (On Hand = 1), sorted by Part Number.
Waiting for input…
RMA Request DATE
✉️ Email Drafter
Preview
To: —
CC: —
Subject: —
Start typing your message…
Copied
S5 → Work Order Formatter
01 S5 list
Paste from Excel with headers Sales Order Number S5 and Serial Number. First column must be S5 Sales Order, second column Serial Number.
02 Source export
Paste the full Excel export with a header row containing Work Order No, Current Claim/PO Number, Sales Order Number and RMA Item Number.
No output yet. Click Generate.
Work Order Ship Date Del No Customer PO Origin Item No Desc. Serial No Next status PO number PO Type
📦 Packing List P/N · Serial · Work Order Extractor
Expected item line like: 1.000 <WorkOrder> <P/N> … 1.00
Serial found later as: Serial No: <value>.
No data extracted yet.
#P/NSerialWork Order
🔧 Repair Vendor Lookup
No file loaded
Scan
✖#P/NSerialWork OrderReason for RepairMatchRepair Vendor (XLOOKUP)
🏷 BAD Label Generator