Merged data
The merged procurement sheet (PR → PO → GRPO) with the realisasi status used by KPI 2/3 · 13,488 row(s)
How the three files are consolidated— click to expand
Three SAP exports are combined. The SPINE is PR TO PO TO GRPO — the master PR list (one row per PR-item, including PRs not yet converted to a PO). It sets the dashboard's date span and is KPI 4's denominator.
PO.csv enriches it with the PO details that only it carries: the Lokal/Impor flag (the KPI 2 vs KPI 3 split), the ETA, currency and unit price, joined on PO No.
LEAD TIME PR TO GR adds the goods-receipt detail: one row per GR with its date and quantity, plus the ordered PO quantity, last/current price and PR→PO days. This is what makes the quantity-aware completion possible.
KPI 2/3 'received' logic is quantity-aware: a PO-item counts as received only when the running sum of GR quantities reaches the ordered quantity; the completion date (the GR that crosses the ordered qty) is compared to ETA + 7 days (Local) / 14 days (Import).
On import each file is upserted by its natural key, so re-uploading an updated export updates rows in place instead of duplicating them. KPI 5 (Quality), 6 (Substitution) and 7 (New Vendor) have no source in these files yet — they are seeded with best-case defaults so the scorecard is complete; replace those entries as real data arrives.
Realisasi here uses a 7-day tolerance (local). Each KPI's own formula is on its methodology page — click any KPI title on the dashboard.
| PR No | PR Date | Item Group | Item Code | Item | Last PO | Last Price | PO No | PO Date ▼ | ETA | Qty | Price | PR→PO | GRPO No | GRPO Date | PO→GRPO | Deadline | Realisasi |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 260310029 | 2026-03-11 | PERSEDIAAN UMUM | 6060.0501 | PIPA CARBON STEEL BLACKSTEEL Ø 2,5 INCH ASTM SCH.40 SEAMLESS | 260610123 | 1,030,000 | 260610123 | 2026-06-10 | 2026-06-10 | 160 | 1,030,000 | 91 | 260610466 | 2026-06-17 | 7 | 2026-06-17 | On time |
| 260310029 | 2026-03-11 | PERSEDIAAN UMUM | 6060.0501 | PIPA CARBON STEEL BLACKSTEEL Ø 2,5 INCH ASTM SCH.40 SEAMLESS | 260610123 | 1,030,000 | 260610123 | 2026-06-10 | 2026-06-10 | 160 | 1,030,000 | 91 | 260610467 | 2026-06-17 | 7 | 2026-06-17 | On time |
| 260410045 | 2026-04-17 | PERSEDIAAN UMUM | 6030.1829 | U-BOLT 2 INCH | 260610124 | 3,153.15 | 260610124 | 2026-06-10 | 2026-06-10 | 100 | 3,153.15 | 54 | – | – | – | 2026-06-17 | Overdue |
| 260410045 | 2026-04-17 | PERSEDIAAN UMUM | 6030.2353 | U-BOLT 4 INCH | 260610124 | 7,207.21 | 260610124 | 2026-06-10 | 2026-06-10 | 50 | 7,207.21 | 54 | – | – | – | 2026-06-17 | Overdue |
| 260410045 | 2026-04-17 | PERSEDIAAN UMUM | 6030.2267 | U-BOLT 5 INCHI | 260610124 | 7,657.66 | 260610124 | 2026-06-10 | 2026-06-10 | 10 | 7,657.66 | 54 | – | – | – | 2026-06-17 | Overdue |
| 260410045 | 2026-04-17 | PERSEDIAAN UMUM | 6030.2933 | U BOLT 8 INC GALVANIS | 260610124 | 12,612.61 | 260610124 | 2026-06-10 | 2026-06-10 | 10 | 12,612.61 | 54 | – | – | – | 2026-06-17 | Overdue |
| 260410045 | 2026-04-17 | PERSEDIAAN UMUM | 6030.1831 | U-BOLT 1 INCH | 260610124 | 1,801.8 | 260610124 | 2026-06-10 | 2026-06-10 | 100 | 1,801.8 | 54 | – | – | – | 2026-06-17 | Overdue |
| 260410046 | 2026-04-17 | PERSEDIAAN UMUM | 6030.1829 | U-BOLT 2 INCH | 260610124 | 3,153.15 | 260610124 | 2026-06-10 | 2026-06-10 | 10 | 3,153.15 | 54 | – | – | – | 2026-06-17 | Overdue |
| 260300452 | 2026-03-31 | PERSEDIAAN UMUM | 6050.0034 | LPG 50 KG | 260600166 | 1,300,000 | 260600166 | 2026-06-09 | 2026-06-15 | 1 | 1,300,000 | 70 | 260600372 | 2026-06-10 | 1 | 2026-06-22 | On time |
| 260310018 | 2026-03-07 | PERSEDIAAN UMUM | 6050.1633 | ATS HYDRAULIC BOTTLE JACK (DONGKRAK BOTOL) 3TON | 260610113 | 225,226 | 260610113 | 2026-06-09 | 2026-06-18 | 2 | 225,226 | 94 | 260610338 | 2026-06-12 | 3 | 2026-06-25 | On time |
| 260410032 | 2026-04-14 | SPAREPART | 5023.157 | POMPA FEEDING FILTER PRESS TYPE 50SyA DAN MOTOR 22KW TYPE YVF2_180L_4 | 260610102 | 2,800 | 260610102 | 2026-06-09 | 2026-06-09 | 2 | 2,800 | 56 | – | – | – | 2026-06-16 | Overdue |
| 260410045 | 2026-04-17 | PERSEDIAAN UMUM | 6030.2601 | U BOLT GALVANISH 3 INCH | 260610096 | 6,036.03 | 260610057 | 2026-06-06 | 2026-06-06 | 50 | 6,036.04 | 50 | 260610252 | 2026-06-09 | 3 | 2026-06-13 | On time |
| 260410045 | 2026-04-17 | PERSEDIAAN UMUM | 6030.2932 | U BOLT 6 INC GALVANIS | 260610057 | 10,810.81 | 260610057 | 2026-06-06 | 2026-06-06 | 10 | 10,810.81 | 50 | – | – | – | 2026-06-13 | Overdue |
| 260110119 | 2026-02-20 | SPAREPART | 5029.0492 | DUMPER VALVE+FLANGE+BOLT,RING,NUT M14X70MM DUCTING DIAMETER 1100 | 260610093 | 12,683,061 | 260610093 | 2026-06-05 | 2026-06-17 | 2 | 12,683,061 | 105 | – | – | – | 2026-06-24 | Outstanding |
| 260400072 | 2026-04-07 | FIXED ASSETS | AST02741 | AC PANASONIC 2 PK (INDOOR + OUTDOOR) R.PANEL PN1 | 260600084 | 6,830,000 | 260600084 | 2026-06-05 | 2026-06-05 | 3 | 6,830,000 | 59 | 260600489 | 2026-06-12 | 7 | 2026-06-12 | On time |
| 260300075 | 2026-03-07 | SPAREPART | 5032.1476 | WIRE ASSY, ACCELERATOR FLEXIBLE 26620-N3170-71 | 260600109 | 750,000 | 260600109 | 2026-06-04 | 2026-06-22 | 2 | 750,000 | 89 | – | – | – | 2026-06-29 | Outstanding |
| 260300217 | 2026-03-12 | SPAREPART | 5022.0364 | HELICAL GEAR Z63 (MAT=SCM-415 HARDEN) | 260600091 | 827,000 | 260600091 | 2026-06-04 | 2026-07-04 | 4 | 827,000 | 84 | – | – | – | 2026-07-11 | Outstanding |
| 260300217 | 2026-03-12 | SPAREPART | 5029.0371 | HELICAL GEAR Z25 (MAT=SCM-415 HARDEN) | 260600091 | 363,000 | 260600091 | 2026-06-04 | 2026-07-04 | 4 | 363,000 | 84 | – | – | – | 2026-07-11 | Outstanding |
| 260300217 | 2026-03-12 | SPAREPART | 5022.041 | PINION GEAR Z9 (MAT=SCM-415 HARDEN) | 260600091 | 354,000 | 260600091 | 2026-06-04 | 2026-07-04 | 4 | 354,000 | 84 | – | – | – | 2026-07-11 | Outstanding |
| 260300217 | 2026-03-12 | SPAREPART | 5022.0363 | HELICAL GEAR Z73(MAT=SCM-415 HARDEN) | 260600091 | 800,000 | 260600091 | 2026-06-04 | 2026-07-04 | 4 | 800,000 | 84 | – | – | – | 2026-07-11 | Outstanding |