1. Get all the data of CustomerTEST.customer_code first, and name it as list of all customer.
2. input the information into interval od date & register in SalesLedgerTEST, and filter out the list of customers who have consumption.
3. Use “list of all customer” to remove the list of customers who have consumption. Then get the list of customer who have not consumption.
4. Total amount of Consumption during interval of date in other register: Use total amount of consumption in interval of date which we input minus total amount of consumption in register which we select （get the SalesLedgerTEST.LineType==”Sale” of [login to view URL] as total amount of consumption）