12 Checking Balances
From TrueERP wiki
Checking Balances
Why do you need to check your balances?
On very rare occassions your MySQL tables can get data corruption. These can be caused by any number of reasons from power surges to simple account set-up issues.
It is always a good idea, that on a Monthly basis to confirm that all of your data is sound and has posted correctly without corruption.
A quick and easy way of confirming this is to simply open your Balance Sheet and confirm that your Assets total, matches your Liabilities total. Your Balance Sheet forms the basis of every report, so if this balances, then every thing else will balance correctly.
Should this Not Balance, then move the date backwards until you get to the date on the Balance Sheet, that it Does Balance. ie open the date drop down on the report, change the month, backwards by a month and re-check the assets total to your liabilities total. Once you have the faultly month, then alter the days until it again balances.
Once you know the date, open the "Transaction Journal' report, on that date and filter on the transaction types until you find which type of transaction is causing the in-balance. ie filter on all invoices and confirm that the totals at the bottom of the report match.
Once you know the types, filter on these by transaction number until you find the out of balance transaction, then simply Delete the Transaction and Re-Enter it.
