Parts Management Tool

Admin setup (do this once before the event):

1. Import the WIP Write-Off sheet — go to the WIP Write-Off List tab and click Import / Replace. Choose the WIP write-offs Excel file. This is the master list of parts the company wants back, with dollar values.

Each engineer (during the event):

2. Sign in — engineers go to the site, click Create an account, and enter their first name, last name, @agilent.com email, and a password (8+ chars). The account works immediately — no approval needed.
3. Add parts — on the Black Stock tab, click Add Parts. Type each part number in the dark box (the description fills in automatically if it's known). Click the disposition chip if the part isn't New/Unused. Press Enter (or click Add) to commit. Use ↑/↓ arrows to change quantity. The part moves to Recently Added; click its (add description) link to fill in a missing description from the part's label.
4. Submit returns — on the Return Opportunities tab, check the parts to return, pick a box, and click Add Selected Items to Box. Type the FedEx tracking number into the box, then click Finalize. You'll jump to History with the box expanded.
5. Print SPL labels — in History, click Print Labels (or Preview Labels) for any submitted box. One label per part; each box prints on its own page.

Forgot password? Click Forgot password? on the sign-in screen, enter your email, and ask an admin — they'll see your request in Manage Accounts and give you a reset link.

Admin wrap-up (end of day):

1. Export the management report — on the WIP Write-Off List tab, click Export Returned Items. This produces the final CSV (all WIP rows, quantities updated, FSE + tracking filled in) for management/SAP.
2. Print reports (optional) — the Print Reconciliation Report and Print WIP Write-Off List buttons give printable PDFs.
3. Back up — click Export DB to download a full JSON backup of the session.

Next reconciliation day? Admin's New Session button archives the current event's history (still viewable in History, grouped by date), starts a fresh event, and prompts for a new WIP write-off sheet. It preserves engineers, accounts, all past history, and the parts catalog (descriptions accumulate forever across events).