Knowledge Base : Glossary : Suggest a Question
Search The Knowledge Base
Browse The Knowledge Base
Knowledge Base : EasyPrint Tool : TRAC5

Balance sheet is not tally.

Here the check list :

1) Closing stock should be same in profit and loss account and Balance sheet.

2) Profit/loss amount also should be same in profit and loss account and balance sheet.
(While open the profit and loss account need to give entire financial year )

3) To Found the problematic transaction. Below query will show the problematic voucher number and vouchertype. So you can check that transaction.

select a.voucherslno as voucherno ,b.vouchertype from accvoucher a join accvouchertype b
on a.vouchercode = b.vouchercode where VoucherNo in (select VoucherNo from accvoucher where VoucherNo <> 0 group by VoucherNo having SUM(Amount) <> 0 )group by a.voucherslno,b.vouchertype

4) If any ledger or group is deleted by query or any other reason. Below query will listed that problematic ledgers.

select * from ACCLEDGERMASTER where GroupCode not in (select GroupCode from accgroupmaster) and ledgercode not in (15,21)

select * from accvoucher where LedgerCode not in (select LedgerCode from ACCLEDGERMASTER)


Related Articles
There are no related articles

Viewer Comments Add Comment
No viewers have posted comments

Powered By AutoKB