FrontAccounting forum — Truncate General Ledger Transactions

Re: Truncate General Ledger Transactions

null@example.com (itronics) — Wed, 25 Nov 2009 09:04:01 +0000

attachments, audit_trail, bank_trans, budget_trans, comments, cust_allocations,
debtor_trans, debtor_trans_details, grn_batch, supp_trans, sales_orders, sales_order_details, gl_trans ... and some other.

Alternative simplier way if you want to start really from scratch would be :
. make backup,
. extract chart_class and chart_mater to separate file, also eventually some basic tables like items, item_codes, if you want reuse them
. restore database from e.g. en_Us-new.sql,
. restore file with the extracted tables

Janusz

Re: Truncate General Ledger Transactions

null@example.com (joe) — Wed, 25 Nov 2009 08:49:30 +0000

I think the en_US-new.sql is the most truncated COA that exists for now. Of course it is possible to truncate it more, but then you will have to do that yourself, before using the accounts.

/Joe

Truncate General Ledger Transactions

null@example.com (acyc) — Wed, 25 Nov 2009 01:04:16 +0000

I operate a small restaurant which opened in August, 2009. The accountant has really mess up the numbers and I am getting rid of her. A new accountant should start next week, and I figured it would be easier to start from scratch, except for the chart of accounts. Which tables should I truncate to be able to post transactions as if I was starting from zero? Thank you for your assistance.