Any way to change the transaction date?

Question

I had a wierd issue recently when the server was restarted it went back to

1/1/2003 I replaced board battery to fix the pblm but for reporting porposes is there any way to move the sales data for what the system thinks is 1/1/2003 to
1/28/2007?

Akber Alwani · Accepted Answer

you can do so by using following query: take the backup before performing the operation:

update [Transaction] set Time='2007-1-28' where year(time) 03 and month(time)=1 and day(time)=1

update Journal set Time='2007-1-28' where year(time) 03 and month(time)=1 and day(time)=1

update TransactionHold set TransactionTime='2007-1-28' where year(TransactionTime) 03 and month(TransactionTime)=1 and day(TransactionTime)=1

update VoucherEntry set [Date]='2007-1-28' where year([Date]) 03 and month([Date])=1 and day([Date])=1

with above query you will loss the time data, however if you really want I will work out on them there are couple of way to do so I just given one option to you.

"robmultil> I had a wierd issue recently when the server was restarted it went back to > 1/1/2003

robmultilink · Answer

I really appreciate the help, when you say lose the time data do you mean the transaction times for that date or all time data?  If it is just for that date I'm not concerned about that at all.Thanks againRob Wilkie"Akber Alwani" wrote:

Akber Alwani · Answer

Yes I mean just time HH:MM:SS for the your specific day. Also include the following table: update DailySales set [Date]='2007-1-28' where year([Date]) 03 and month([Date])=1 and day([Date])=1

Regards Akber

"robmultil>

Any way to change the transaction date?

Join the Discussion

Didn't find your answer?