in account part match debit and credit

Question

hi,

i am working on account part related project. Here stuck in while managing the balance.

i am doing single entry for every transction.

if any product purchased with full payment or partially then it showing in 'Debit Column' and otherwise 'Credit Column'. For more details please find attachment

Thanks in advance