Update CRM deals from failed subscription payment records

Your subscription table logs failed payments that aren't reflected on deals, leaving reps without payment context for collections. Keep deal payment status current so reps and billing can act same day.