Topic: Deleting Fiscal Year - III
After deleting all fiscal years except the current one, we see all opening balances pertaining to only the current fiscal year appended to the gl_trans table. Attempting to query thus:
SELECT * FROM `gl_trans` WHERE ABS(amount) < .001 AND amount <> 0;
we find that there is one (chart_class.cid=2 => Liabilities) entry that has a very tiny amount balance, ie., 2.27373675443232e-13. There are over 100 entries whose absolute gl_trans.amount value is under 0.01. How do we eliminate these opening balance entries - where does the contra go if we delete these GL entries?