How to change the sales date

jadelhitti

hello:

I need to change the date of some existing sales transactions to a future date, I need to know which tables & fields should I modify & how?

I am using SQL server 2008

Thank You.

Belias

This weird, boring, (and not always legal :-$ ) work should be done by a senior functional/developer.
If you're not so experienced, and no one else can do this work, i suggest you to post credit memos (if the original transaction was an invoice) or void the transaction with standard functionality.
After that, repost the transaction with the right date

jannestig

He's asked this before

viewtopic.php?f=23&t=38575

He's dealing with huge bulk apparently, and like i said hes better off seeking a solution from his partner. We used SQL scripts to undo it all 2 months worth due to time constraints of a weekend.

IF its purely the GL side he wants to see dates for he may be better off posting a write off to a dummy account then posting monthly or weekly balances back in as correction.

It took us a month to plan and prove our soultion using around 8 people