my requirement is 1. Takes the sum of credit and debit values of each account from journal item table.
2. Find the account balance from the formula balance = sum of debit – sum of credit.
3. If the balance is positive, then it must be debit.
4. If the balance is negative, then it must be credit.
i want to get the out put as
i have 3 tables accounts,journa l_accountitem,j ournal table
2. Find the account balance from the formula balance = sum of debit – sum of credit.
3. If the balance is positive, then it must be debit.
4. If the balance is negative, then it must be credit.
i want to get the out put as
i have 3 tables accounts,journa l_accountitem,j ournal table