How to change the sales date

jadelhitti
jadelhitti Member Posts: 5
edited 2009-11-30 in NAV/Navision Classic Client
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.

Comments

  • Belias
    Belias Member Posts: 2,998
    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
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • jannestig
    jannestig Member Posts: 1,000
    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

Categories