Announcement

Collapse
No announcement yet.

OTM Archiving For Invoices

Collapse
X
 
  • Time
  • Show
Clear All
new posts

  • OTM Archiving For Invoices

    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

  • #2
    Re: OTM Archiving For Invoices

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

    Comment


    • #3
      Re: OTM Archiving For Invoices

      Thanks patu for the reply!

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

      Thanks!

      Comment


      • #4
        Re: OTM Archiving For Invoices

        Hello Ian,

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

        Regards

        Medhas

        Comment


        • #5
          Re: OTM Archiving For Invoices

          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

          Comment


          • #6
            Re: OTM Archiving For Invoices

            HI,

            I was wondering if there are any ideas to purge/archive invoices and vouchers yet?

            Thanks,
            Tony

            Comment

            Working...
            X
            😀
            🥰
            🤢
            😎
            😡
            👍
            👎