[SQL] How to make accounting balance report?

I'm new to Oracle apex and SQL. I am developing an Oracle app for accounting. My table ga_voucher contains the following columns with values like:

VNO | DBIT CODE | AMOUNT | CREDIT CODE | VDATE | NARRATION
01 121005 40000 331001 09/07/2021 ABCD
02 331002 50000 121005 09/07/2021


I want to generate report with unique account code balance (debit total of a code - credit total) like:

Account CODE | DEBIT TOTAL|CREDIT TOTAL | BALANCE
331002 50000 | 40000 | 10000


What is the SQL query for the report? Please help me.

Continue reading...