Can anyone tell me if it is possible to purge orders, yet leave the customer info intact?
We deleted a year or two of orders, but then discovered that it wiped the data from the Person table too.
This is a bit annoying as we would like to keep customer info on hand for when we do repeat manual orders, yet we would like to do housekeeping on the Order and OrderDetail tables.
It would also be nice if Actinic could recognise that the address1 & postcode have been used before and only add a new record if those fields are unique.
any suggestions?
We deleted a year or two of orders, but then discovered that it wiped the data from the Person table too.
This is a bit annoying as we would like to keep customer info on hand for when we do repeat manual orders, yet we would like to do housekeeping on the Order and OrderDetail tables.
It would also be nice if Actinic could recognise that the address1 & postcode have been used before and only add a new record if those fields are unique.
any suggestions?
Comment