Changing Transactions Date

jadelhitti
jadelhitti Member Posts: 5
edited 2009-11-26 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 should I modify.

I am using SQL server 2008

Thank You.

Comments

  • jannestig
    jannestig Member Posts: 1,000
    It is probably Easier to reverse the entries, invoices etc and invoice them again at the correct date.

    not to mention legally required
  • jadelhitti
    jadelhitti Member Posts: 5
    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
    jannestig Member Posts: 1,000
    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.

Categories