Sign in with Smartsheet
Purchase order numbers go onto the Coil Record as you, so the sheet's history shows who filled them in.
Sign in with SmartsheetSign-in opens in a new tab. Come back here when it's done.
| Coil | Austruss ID | Received | Size / type | Docket kg | Sheet kg | PO on sheet | New PO | Checked | Cost status | Price $/t | Status |
|---|
How it works
- Coils are matched on their number (the Coil Record's Barcode, without the scanner's "]C1"): the docket's Coil/Pack column, or Lot ID on a Coilsteels .csv.
- "PO-5825" on the docket goes in as 5825, the way it's typed into the sheet by hand.
- Each filled coil gets the PO, Checked (Admin) ticked and Cost Status set to Consignment.
- "Will finish" means the PO is already there but the tick or Consignment isn't.
- Coils that already have a different PO, or a Cost Status other than Consignment, are left unticked so nothing gets overwritten by accident — tick them to replace it.
- "Not on the sheet" means the coil hasn't been scanned in yet. Drop the docket again once it has.
- Only those columns (and, if you tick it, Coil Price) are changed. Nothing else on the row is touched.