How do we correct transactions or ticket date


I have a situation with a client whos computer’s cimos battery had failed and the person who logged into sambapos did not realize that the date was wrong and the transacted half of that workperiod with wrong 2010 date. And now this is messing the reports when that day is included. Is there a way one can correct dates for the affected transactions? Or what’s the best way of handling this! And if one was to mess with the SQL db, which fields would need editing?



From memory there is defiantly dates in tickets table and most likely orders and payments too.
Be very carefull, there is obviously risks in editing the sql directly - be sure to make a backup.

There would be other potential issues, what is the start and end date of the workperiod from that day? when did the battery fail?