Script to Approve Credit Request

If a customer is struggling with approving a credit request due to a glitch in the system where the credit was already created, you can use this script to reflect that it has already been approved

update cr

set

credit_id = [creditid], --ID of the credit that was already created

Approved_Amount = Request_Amount,

Signoff1 = [usercode],--This will be the user code of the contact on the Salesforce ticket

Signoff1_Date = GETUTCDATE(),

Closed = 'Y'

from AR_Credit_Request cr