Skip to main content

Apply 30-day Protection on Customer Accounts

Sanket Ghia
  • Updated

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:

  1. Login to the Jump server 10.185.40.141.
  2. Open Microsoft SSMS and connect to aes.cons.com.
  3. Select New Query in the top bar.
  4. Find the CustID of the accounts that the client has mentioned:
use <Client specific Database>;
Select CustID from Customer where CustNo IN ('Customer #1', 'Customer #2', ...);
  1. Update the PromiseToPayFlag flag 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>