Deleting Fiscal Year - III

null@example.com (apmuthu) — Fri, 29 Jul 2016 10:52:53 +0000

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?

FrontAccounting forum — Deleting Fiscal Year - III

Deleting Fiscal Year - III