• Registered: 02/17/2013
  • Posts: 4

Topic: Help fixing entries into wrong fiscal year

Hi All

Is there a way to change a batch of entries that went into the wrong fiscal year (hopefully not cancelling and rentering them all)?????

Damn newbie mistake.

Chris

2 Reply by apmuthu (edited by apmuthu 11/12/2015 10:52:03 am)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Help fixing entries into wrong fiscal year

Yes, but directly in SQL:
1. Taking a backup of the db
2. Delete all entries of the batch in the tables using a MySQL client like phpMyAdmin/SQLyog.
3. Take fresh backup of db
4a. Now import the batch with the correct data after resetting the Voucher numbers.
or
4b. Compare the backups and extract the difference entries, correct the dates with search and replace and then import the data as INSERT statements.

Lesson to be learned from this experience in hindsight:
1. Take a backup regularly and comment them appropriately.
2. Atleast take a backup before and after bulk imports.

apmuthu's Website