Update RMR User Description Using Item Description (Ineternal)

Sedona sometimes have issues with the user description on an RMR line. Since the Item Descriptions for those lines has more requirements to be saved, using the script below can be an easy way to “Clean Up” all recurring lines

 

Update R

Set User_Description = I.Description

--select *

from AR_Customer_Recurring R

join AR_Item I on R.Item_Id = I.Item_Id

Was this article helpful?
Thank you for your feedback!
User Icon

Thank you! Your comment has been submitted for approval.