Update failed payment log and flag for retry

Invoice payment failures arrive without retry status, so billing can't prioritize collections or reconcile. It flags records with retry state and attempt count so teams act before the next billing run.