in account part match debit and credit

Hi,

I think you should maintain a flag in sql table indicating what type of payment is done. Like if full payment is done then flag set as 1, if payment is done against credit, then flag as 2.

Now you can calculate amount only for rows without flag=1

I have not much idea about how this credit / debit things work. But still you can give it a try.