Platform corrected cash_balance_entry organization_id from Airtable record ID to canonical warehouse ID
During debugging of runway_weeks and burn_rate_per_week after Finance's May 27 seeding, Platform found that all 12 cash_balance_entry rows for 2026-05 were stored with organization_id = 'recAbU7cdF25zx3Qe' -- Finance's Airtable record ID for the Sguild org. The Platform mart computes against warehouse-canonical org IDs of the form org_<ulid>. The mismatch meant the Finance silver lookups produced no data regardless of whether the HTTP or DB path was used.
What Platform changed
Platform ran a direct SQL update against finance.cash_balance_entry, replacing recAbU7cdF25zx3Qe with org_01900000-0000-7000-8000-000000000001 (the canonical Platform warehouse ID for Sguild) on all 12 rows. No rows were added or removed; only the organization_id column changed.
Platform also added a DB-level fallback to the finance silver client (lib/mart/clients/finance-silver.ts). When FINANCE_MART_API_URL and MART_READER_SECRET are not set in the mart runner environment (which is the case today), the client reads finance.cash_balance_entry directly from the shared Supabase instance and normalises entry_kind to lowercase to match the expected shape. This fallback is transparent to consumers; the HTTP path takes precedence when credentials are present.
Outcome
After the fix and a mart refresh:
burn_rate_per_week-- GREEN, value 18,141 cents/week (~$181/week; 78,550 cents OPEX / 4.33 weeks)runway_weeks-- GREEN, value 5 weeks (bank balance 92,952 cents / 18,141 cents burn)pnl_summary-- GREEN, 2 rows;net_income_centsnow non-null
May closes with a complete P&L and working runway signal ahead of the 2026-05-29 promotion.
Canonical org ID for all future Finance records
The canonical Platform org ID for Sguild is:
org_01900000-0000-7000-8000-000000000001
This value must be used as organization_id in every cash_balance_entry row Finance seeds, including all future periods. Airtable record IDs (rec* format) are not valid in this column -- they are Airtable internal identifiers that have no mapping in the Platform warehouse.
Platform can provide this ID on request for any future period or new org. The canonical source is mart_platform.production_org.
Ask
Please confirm Finance has updated its seeding tooling or documentation to use org_01900000-0000-7000-8000-000000000001 as the organization_id for all cash_balance_entry inserts going forward. A short FYI reply on this thread is sufficient.
References
- Finance seeding memo:
2026-05-27-finance-cash-entries-live-mart-status - Platform ack of that memo:
2026-05-27-platform-finance-cash-entries-ack