I Need Coffee - Episode 180 - Weekly BC Review!

Show Notes: Episode 180 - I Need Coffee (Sep 12, 2025)

1. Episode Milestone and Greetings
   - Celebrates 180 episodes, a significant milestone despite irregular periods.
   - Technical hiccups: dying keyboard, Stream Deck issues.
   - Shoutouts: Moardes, Tanya (RSM), Ola RSM, Eric Hogard, Christian Lais, DF, Demani.

2. Community Poll on BC Features
   - X poll: "What relatively new BC feature should functional consultants/developers learn?"
     - Responses: Queries (older), Copilot/Text/AI (newer), CI/CD (older), interfaces (years old), price calculation engine (~2 years), performance profiler (~2 years), data transfer/audit fields (underused, e.g., system modified on/by).
  

3. Personal Anecdotes and Blog Revival
   - Tanya (RSM) resurfaces host’s 2021 blog solving Chrome autofill overlay in BC—enjoys “artisanal” blogging but notes time cost; dislikes AI-generated content.
 

4. Weekly Projects: PTE Nightmare
   - PTE Disaster:** Adding one report field took 4 weeks due to:
     - Wrong field (duplicates across record types; hidden dataset issue).
     - Stuck pull request added MEM dependency, forcing redo.
    

5. Sandbox and Tenant Chaos
   - Team of 5 in Berlin juggled shared sandboxes for reports, imports, ISVs—disrupted by upgrades/MEM installs.
   - Solution: Host assigned 9 personal demo tenants (some from 2019); new free demo creation method (custom domain/email, kept low-key).
   - Issue: Browser profile overload (9+ tenants, manual setup across devices).

6. Technical Deep Dives
   - OData Deprecation: Marcel Schab’s blog warns of 2027 Wave 1 (v30) removal; urges Web API v2.0 migration (despite flaws). Simple Object Designer as alternative.
   - AL Upgrade: Fixed v26 issues (duplicates, old number series); v27 deprecations loom (200+ objects). Deferral possible to March 2026, but Nov 2025 urged.
   - Import Design: Staging tables for file imports (Excel/CSV/JSON) enable set-based ops (validation, history). BC list pages add UI polish. Exploring generic fields for multi-customer flexibility.

7. Cybersecurity Highlights
   - NPM Attack: Phished dev added malicious code to 15 packages (2B weekly downloads); caught in <1hr but exposes open-source risks (no audits, obfuscated code).
   - AI Coding Risks: Adds fictional deps, secrets, misconfigs (XKCD 2347 Jenga tower). Useful for explaining complex code.
   - M365 Breaches: Weekly partner compromises—enable Defender, conditional access, geo-locks.

8. Integrations and Events
   - Bill.com + BC/MEM App: Complex, over-budget, nearing go-live (next Friday).
   - Corporate ACH Debits: B2B auto-withdrawals (e.g., fuel suppliers) unsupported in BC NA; scoping paid design (CCD format).
   - Events:
     - Summit NA (Oct, Orlando): BC Bash party (700 cap last year).
     - Directions MIA (Nov 4–6, Poland): Christian Lais session.
     - Dynamics User Group: Dallas (Sep 17, 200+), other regions.
     - Summit Roadshows: Houston (Dec 9), Fort Lauderdale (Dec 11).
   - Webinar: Aropay (Sep 15): AL code’s SQL performance impact.

9. Team Updates
   - Joselyn: PowerBI, RDLC; speedrunning check layouts (<2hr goal).
   - David: Report layouts; paused data migration.
   - Ronald: McCroma Payment Hub (super checks).
   - Franklin: Excel imports, staging tables.
   - Fatima: PMP course; shadowing AL/PM tasks.