[ianlo]

Hi,

Currently, OTM supports SHIPMENTS, ITEMS, ORDER RELEASE and ORDER BASE data purging - which will then move the purged data from the GLOGOWNER schema to the ARCHIVE schema.

I am currently creating invoices and vouchers and found out that these objects are not housekept.

Does anyone know the recommended process for housekeeping invoices and vouchers? What is everyone else doing to housekeep this?

Thanks!
Ian

[patu2829]

You have to pretty much write your own archive purge process for invoice and vouchers related tables . OTM does not have seeded one.

[ianlo]

Thanks patu for the reply!

Has anyone done any customised archiving on OTM? Any recommended design considerations or implementation models to follow?

Thanks!

[medhas]

Hello Ian,

Have you been able to purge the invoices? We have a requirement too along the same lines..

Regards

Medhas

[ianlo]

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