Total Weight: 12,167.85 kg
Held in Crystal Cold Storage
Invoiced Qty: 1,179 units
Includes Sodexo, SMPI & Ramada splits
Daily Cold Storage Movement (June 1–14, 2026)
Re-Inward Stock vs. Pulled Out Dispatch Volume by Date
Top Clients by Dispatched Qty
Pulled-Out vs. Invoiced Allocation
Spreadsheet Variance & Anomaly Watch
Auto-DetectedTop Seafood SKUs by Cold-Storage Weight (kg)
Aggregated across all June 1–15 OTF records
| Item / SKU | Total Qty | Total Weight (kg) | Re-Inward | Pulled Out | Quick Action |
|---|
Consolidated Cold-Storage SKU Rollup
Live Re-Inward vs. Pulled Out totals across all OTF batches
| Seafood SKU | Packaging Types | OTF Appearances | Total Initial Qty | Total Weight (kg) | Re-Inward (In Stock) | Pulled Out | Utilization % | Adjust Stock |
|---|
Invoiced Pull-Out Reconciliation Log
| Date | Client | Invoice # | OTF # | Item | Pulled Out | Invoiced Qty | Variance | Remarks |
|---|
Sync CRYSTAL Cold Storage Workbook (.xlsx / .csv)
Drop your updated CRYSTAL Excel file here. The system automatically scans the summary sheet for all OTF headers, weights, re-inward balances, pull-outs, invoices, and TOTAL dates.
Click to select Excel file or drag & drop here
Supports CRYSTAL June 1–15 / June 16–30 multi-OTF format (.xlsx, .xls, .csv)
Automatically computes Re-Inward = Qty - Pulled Out and Variance = Pulled Out - Invoiced Qty on every edit.