------- * Zero Account Vouchers * ---------
Select VMID, VDID, EntryType, TrnID, EntryDate, EntryNo, VMNarration as Narration, Debit, Credit FROM dv_accPostTran Where DAcID=0;


------- * Invalid Posted Vouchers * ---------
Select VMID, EntryType, EntryDate, EntryNo, Sum(Debit) as Dr, Sum(Credit) as Cr, Sum(Debit-Credit) as Diff FROM dv_accPostTran Group By VMID, EntryType, EntryDate, EntryNo Having Sum(Debit)<>Sum(Credit);


------- * Disabled Accounts Having Balance * ---------
Select DAcID, Sum(Debit-Credit) as Bal from dv_AccPostTran as LD Inner JOIN VAAccountInfo as Ac ON LD.DAcID=Ac.AcLedgerID Where AcIsEnable=0 Group By DAcID Having Sum(Debit-Credit)<>0


------- * Disabled Accounts Having Opening * ---------
Select ID, AcLedgerID, AcName, AcOpBal from VAAccountInfo Where AcOpBal>0 And AcIsEnable=0

------- * Deleted Account Vouchers * ---------
Select ID, VDVMID as VMID, VDAcID, VDDrAmt as DrAmt, VDCrAmt as CrAmt, VDNarration From VAVoucherDetail Where VDAcID not in(Select AcLedgerID From VAAccountInfo)