Overview

You want to update the utility account numbers because they were changed by mistake (eg: the leading "0" was removed). Only after this update, the usage for these accounts can be processed, which is currently stuck.

Solution

Open a support ticket with the current utility/premise account numbers and for each of them, also mention to what value should they be updated to.

<supportagent>

1. Login to the Jump server 10.185.40.141.
2. Open Microsoft SSMS and connect to aes.cons.com.
3. Click New Query in the top bar.
4. Select all the premises that the client has mentioned:

use <Client specific Database>;
SELECT PremID, PremNo FROM premise WHERE PremNo IN ('<old prem no 1>', '<old prem no 2', ...)

1. Using the above PremID values run the query from QAT using query ID 42 to update the required values.

</supportagent>