• acyc
  • Member
  • Offline
  • Registered: 05/20/2009
  • Posts: 17

Topic: Truncate General Ledger Transactions

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.

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Truncate General Ledger Transactions

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

  • Registered: 12/25/2007
  • Posts: 2,448

Re: Truncate General Ledger Transactions

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