Page 1 of 1

Deleting Old Customer Records

Posted: 04 Nov 2008, 15:37
by minskintin
Hello,

because of our type of business we have a massive amount of customers in our database which makes it reeeeeally sloooooow to find a customer and it's driving us mad.

Is there a way we can filter out old customers that we've had no dealings with before a certain date? We just can't seem to find a way to do it.

Thanks!

Minskintin :D

Posted: 10 Nov 2008, 17:31
by brucedenney
Search

Where - Last invoice Date - Is greater than - xx/xx/200x

You could also delete the really old accounts do the opposite search

Where - Last invoice Date - Is less than - xx/xx/200x

Swap
Delete

It will not delete anything with transactions on, clearing transactions at year end with clear audit trail will enable this.

Also worth running reindex and compression.

Posted: 11 Nov 2008, 18:30
by minskintin
Hi Bruce,

thanks for the reply. Tried that, worked a treat!

So easy when you know how :D

Many thanks, Minskintin