Overview

You want the late fees applied for a particular time period (Eg: the month of April) for a customer.

Solution

Open a Support ticket with the below information for which the late fees data is required:

1. Customer name/s or account numbers.
2. The time period/dates for which the information is required.

<supportagent>

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. Run either of the below queries:
   1. If the customer name is provided by the client, then run the below query:
      

      Select * from Invoice where CustID IN (
      Select CustID From Customer where CustName LIKE '%<customer name provided by the client>%')
      and InvDate BETWEEN '<start date>' AND '<end date>'
      and Type='Late'
      order by 1 desc

   2. If the account number is provided by the client, then run the below query:
      

      Select * from Invoice where CustID IN (
      Select CustID From Customer where CustNo IN ('<customer number 1>, <customer number 2>, ...')
      and InvDate BETWEEN '<start date>' AND '<end date>'
      and Type='Late'
      order by 1 desc

In both the above queries, the start, and date format is YYYY-MM-DD 00:00:00.000.

Copy the data into an appropriate tool (Excel/Google Sheets) and send it to the client.

</supportagent>