Quote Originally Posted by leinad31
Because you used LIKE to specify the customer ... so what happens is debits and credits from customers with similar names are also included in the running balance.
Hi, It shows the exact CODE (Customer Code) as it is in the last post which determines that it retrieved the data for the same customer not other customers whose name is similar.

Regards,

Margaret