Overview

You want us to provide all eligible GA SONP for a given date range for a given list of accounts. You want to know which accounts are paid/current from your list.

 

Solution

Please raise a support ticket sharing the date range and the list of accounts whose 'paid/current' status you want to know. You can also opt to share a previous SONP report and specify that the accounts (customer account numbers) from that list/report should be used.

We will share the SONP report for the given date range and you can refer to the value for SONP Status in that report to know the Paid/Clear status for an account.

<supportagent>

Prerequisites:

• Access to the Client database

Steps:

1. Run the following select query for a given date range to get the accounts ( and related information) eligible for SONP.
   Replace the parameter custno with the given account numbers and the date range for LetterDate.
   
   

 

use paes_stream;

Select Distinct
Custno [Customer Account Number],
CustName[Customer Name],
cd.CustomerDisconnectID,
CD.LetterDate[Letter Date],
CD.DisconnectionAmount [SONP Balance],
CDS.Description[SONP Status],
Sum(ca.Amount) as [SONP Payment Amount],
c.CustID
From Customer C
join Address ad1 on ad1.AddrId = c.MailAddrID 
Join CustomerDisconnect Cd on cd.custid=c.custid
Join CustomerDisconnectStatus Cds 
on cds.CustomerDisconnectstatusid=cd.statusid
Join AccountsReceivable ar on ar.AcctsRecID = c.AcctsRecID
left JOIN CustomerDisconnectARDetail  ca on  
ca.CustomerDisconnectID = cd.CustomerDisconnectID
and source='Payment'
where 1=1
and (Cast(cd.LetterDate as Date)>='2020-03-14' 
and Cast(cd.LetterDate as Date)<='2020-06-30')
and ad1.state='GA'
and custno in ('3001476557', '3001479821' )
group by Custno,
CustName,
cd.CustomerDisconnectID,
CD.LetterDate,
CD.DisconnectionAmount ,
CDS.Description,c.custid
Order by CD.LetterDate

 

2. Share the query result with the client.
The value for SONP Status indicates Paid/Clear status for given accounts.

</supportagent>