Quote:
Originally Posted by medhas  Hello Ian,
Have you been able to purge the invoices? We have a requirement too along the same lines..
Regards
Medhas |
Hi Medhas,
Unfortunately, I have been busy with implementation and project work that I did not put any thought into this.
What I can say is that we would need to build custom tables to store the archived invoice data and run a script to move them from production to archive.
The FK relationships will be a huge pain because of the implicit relationship between invoices and shipments - i.e. what criteria should the invoice be archived, what happens when a shipment is archived but the invoice is not and what about credit / debit notes?
I have not wrapped my mind around this unfortunately... sorry.
Ian