Hi everyone
Can anyone help me that how to make database for debit and credit records
I have customer table and supplier table
......
Purchase items from supplier
Return purchased items
Payment to supplier
......
Sale items on customers
Sale return
Payment by customer
......
Now how to make database for it to find suppliers balance and customers balance
And ledger transaction when a customer ask for it's ledger which will include all transactions from one date to another date