inventory MIS ERD

Question

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