Overview

You want to enable or disable (remove) a customer from consolidated billing.

Solution

Open a Support ticket with the customer number for which this update needs to happen and clearly specify whether the setting should be enabled or disabled.

<supportagent>

This is a configuration for invoice delivery. To turn consolidated billing on or off the following steps should be followed. 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. Get the correspondence preference by running the following query (replace [customerNumber] with the number informed by the client:

   use <Client specific Database>;
   SELECT cd.* , c.deliveryTypeID  FROM Customer c
   JOIN CorrespondenceDeliveryTypePref cd ON cd.custid = c.custid 
   WHERE c.custno = '[customerNumber]' AND cd.CorrespondencePrefType='Invoice'

5. Take note of the CorrespondenceDeliveryTypePrefID from the results of this query. Note: If you get multiple rows, then ask the client which row needs to be updated.
6. Run the following query to update the correspondence preference. Replace [status] with 1 to turn consolidated billing on or 0 to turn it off. Replace [ID] with the CorrespondenceDeliveryTypePrefID from step 5.

   use <Client specific Database>;
   UPDATE CorrespondenceDeliveryTypePref
   SET BankConsolidated = [status]
   WHERE CorrespondenceDeliveryTypePrefID = [ID]

</supportagent>