<![CDATA[FrontAccounting forum — Help fixing entries into wrong fiscal year]]> 2015-11-12T10:50:54Z PunBB https://frontaccounting.com/punbb/viewtopic.php?id=6019 <![CDATA[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.

]]> https://frontaccounting.com/punbb/profile.php?id=364 2015-11-12T10:50:54Z https://frontaccounting.com/punbb/viewtopic.php?pid=24696#p24696 <![CDATA[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

]]> https://frontaccounting.com/punbb/profile.php?id=17399 2015-11-12T00:00:34Z https://frontaccounting.com/punbb/viewtopic.php?pid=24694#p24694