If a customer wants to update all of their recurring user descriptions to match the item code or item descriptions, you can use the script below. This is especially useful to mass update any recurring line that does not have a recurring user description.
update r
set User_Description = i.Description
--select *
from AR_Customer_Recurring r
join AR_Item i on r.Item_Id = i.Item_Id
where r.User_Description = ''
