Changing Transactions Date

jadelhitti

hello:

I need to change the date of some existing sales transactions to a future date, I need to know which tables should I modify.

I am using SQL server 2008

Thank You.

jannestig

It is probably Easier to reverse the entries, invoices etc and invoice them again at the correct date.

not to mention legally required

jadelhitti

jannestig wrote:

It is probably Easier to reverse the entries, invoices etc and invoice them again at the correct date.

not to mention legally required

Thanks for your reply, but I am dealing with thousands of records you know..so it's a nightmare..

jannestig

We did the same thing but had to roll back about 2 months worth of data and repost again,

I assume you are dealing with a retail enviroment??

You will most likely have to write your own code to do this.

You will have to reverse all the posted documents and the related GL and VAT entries. Best off asking your partner to work out the solution.