Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Order purge

    Order purge

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 20, 21, 22, 23

    Description:
    We used to do order purge once a year to clean up some old orders.

    1. Is this still necessary?  What impact would it have if we don't do it?

    2. If we decide to do it using a SQL statement as we did before, is there any job that'll need to be run? According to our record, we used to run acq-04 after the purge.

    Resolution:
    The current versions of Aleph are no different than earlier versions in regard to its handling of order records: they don't purge old order records.

    Order records can be connected to invoice and budget records via the z601 (encumbrance/invoice transaction) records. You need to make certain that any invoice and budget records these orders are linked to are obsolete.

    You will definitely need to run the acq-04 ("Rebuild Acquisitions Order Index") after any such SQL delete.

    Note: you should, of course, back up the z68 table with file-03 first.


    • Article last edited: 23-Mar-2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Order of Z07A processing
      • Order record without ADM?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. order
      2. purge
      3. z601
      4. z68
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved