🔍 Matching Checkers

Track missing documents from matching results with priority alerts

PRODUCTION MODE

🔍 Adam Matching Checker

Scan 9 matching output sheets for "No Match" rows and classify by priority based on document age:

📋 AS/Rechnung CICA, SOCAR, LANDI, TAMOIL
🔗 AS/LS Matching Mismatch Lieferscheine
🧾 Rechnung/Einkauf CICA, SOCAR, LANDI, TAMOIL

🛢️ Minerol Matching Checker

Scan 2 Minerol matching output sheets for "No Match" rows. Sends alerts to Michael only.

📋 LS/Rechnung MINEROL
🧾 Rechnung/Einkauf MINEROL

📅 Sunday Mode (adds P4 · 1-day-back Rechnung)

Runs the exact report Michael gets every Sunday, including the extra P4 tier for Rechnungen missing just 1 day. Use Run Staging to preview it (sent only to the dev address) before it ever reaches production.

🗂️ All-Open Mode (P4 from day 0 — manual only)

Flags every Minerol LS with no Rechnung as P4 regardless of age — including today's (0-day). Older rows still escalate to P3/P2/P1. Manual only — this mode is never scheduled. Use Run Staging to preview it (dev address only) before production.

⛽ Tamoil Matching Checker (Weekly)

Scan the TAMOIL AS/Rechnung sheet for pickups still missing an invoice. Sends a weekly digest to Michael only.

📋 AS/Rechnung TAMOIL

Reports every unmatched Tamoil pickup dated on/before last Sunday (older stragglers included); this week's fresh rows are held back. Scheduled Tuesdays 6:30 PM. Use Run Staging to preview it (sent to the dev address only) before production.

📊 Adam Last Run Summary

14.07.2026, 15:41 5 P3

🛢️ Minerol Last Run Summary

14.07.2026, 15:45 67 P1 18 P2 10 P3

⛽ Tamoil Last Run Summary

07.07.2026, 18:30 3 P2