<![CDATA[FrontAccounting forum — Help fixing entries into wrong fiscal year]]> https://frontaccounting.com/punbb/viewtopic.php?id=6019 Thu, 12 Nov 2015 10:50:54 +0000 PunBB <![CDATA[Re: Help fixing entries into wrong fiscal year]]> https://frontaccounting.com/punbb/viewtopic.php?pid=24696#p24696 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.

]]> Thu, 12 Nov 2015 10:50:54 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=24696#p24696 <![CDATA[Help fixing entries into wrong fiscal year]]> https://frontaccounting.com/punbb/viewtopic.php?pid=24694#p24694 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

]]> Thu, 12 Nov 2015 00:00:34 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=24694#p24694