Overview
You want to apply 30-day protection on a customer account or a list of customer accounts.
Solution
Open a support ticket with the customer account numbers on which the 30-day protection should be placed.
<supportagent>
Note: This is the same as updating the PromiseToPayFlag.
You should have access to the Jump server for performing the below steps:
- Login to the Jump server 10.185.40.141.
- Open Microsoft SSMS and connect to
aes.cons.com. - Select
New Queryin the top bar. - Find the
CustIDof the accounts that the client has mentioned:
use <Client specific Database>;
Select CustID from Customer where CustNo IN ('Customer #1', 'Customer #2', ...);
- Update the
PromiseToPayFlagflag for the custIds found in the above query:
use <Client specific Database>;
Update CustomerAdditionalInfo set PromiseToPayFlag=1 where CustID IN ('ID1', 'ID2',...)
Inform the client that the 30-day protection has been applied to the customer accounts.
</supportagent>
Priyanka Bhotika
Comments