Wrong Posting /Document Date on Invoices and receipts

kamranshehzad

Hi

I transferred a bulk of documents about 2000+ documents including PI's, PR's , SI's , SC's and sales receipts today. I can't restore from backup obviously live transactions were in place during the day.
Issue is the documents went with wrong Data formats lets say for 12/feb/2011 it went like 02/dec/2011. Now i can't just create corresponding credit documents etc for sure. the only thing is update the related tables and do a databaes update in them to fix the dates.

what i planned is to add additional fields on the tables and copy the current date in them and then update the fields with correct dates and check the balances etc.

can any one please guide me here on what I am going to do or tell me any better solution to fix it.

Kind regards,
Kamran
Running Nav2009 sp1 on sql server 2008.