-----

SELECT companyid, journalid, sum(amount_dr) as Debit , sum(amount_cr) as Credit FROM `comp_journal_detail` WHERE status = 1 and is_delete = 0 and year =2015 and period = 8 group by companyid,journalid having sum(amount_dr)<> sum(amount_cr)