purging of database

nostran

hi guys,

how would you proceed to purge the navision database? cause i haven't seen any purging facility in Navision.

thanks

Savatage

Need to delete all the postings in a database?

http://www.go-live.us/Downloads/Go-Live ... ntries.zip

Create a clean database.

WARNING this will delete everything

Dean_Axon

how exactley do you want to "Purge" your database ??

Do you want to remove ALL data or just certain pieces of information.

Have you looked at the "Date Compression" routines in "periodic Activities" ??

Savatage

for Date Compression see G/L and Inventory Periodic Activities

In Purchases & Payables and Sales & Receivables if you go to periodic activities - it has other delete options.

nostran

hi dean,

what i mean by purging, is that let's say my database is getting really heavy and i want to get rid of all transactions that relate to two years back or more.

however the transactions involved must not be still relevant, e.g customer invoices that have been fully paid would be deleted but not outstanding invoices.

i don't want to create a fresh database but just get rid of "obsolete" that's just making the database big and heavy...

cheers

Savatage

Savatage wrote:

for Date Compression see G/L and Inventory Periodic Activities

In Purchases & Payables and Sales & Receivables if you go to periodic activities - it has other delete options.

Bagheera

Savatage wrote:

Need to delete all the postings in a database?

http://www.go-live.us/Downloads/Go-Live ... ntries.zip

Create a clean database.

WARNING this will delete everything

There are some tables listed in your report that do not exist in version 3.7A. Are these custom tables?

Even if I delete these tables I get this message: "The Property Exceeds the Buffer Size" when I try to run it. Any clues?

Savatage

First it's not my report it's from David Singleton's

http://www.go-live.us/prod01.htm

info@go-live.us

Now this post is from over a year ago. what are you trying to do?

delete the contents of everytable but leave the setups? that kind of thing?