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. Library encumbers but doesn't invoice serials resulting in huge encumbrance

    Library encumbers but doesn't invoice serials resulting in huge encumbrance

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 17.01

    Description:
    Over the past two years the ABC50 library has been creating orders and encumbering their serials. However, they do not link the invoice to the encumbered titles. Thus, when getting ready to create their serials fund for the new accounting year, they have encumbrances of $400,000. Is there any way to get rid of these encumbrances other than creating an invoice and linking all of the orders?

    An example is fund PERPRINT-2005.

    Resolution:
    If all of the encumbrances for this budget PERPRINT-2005 should be deleted, the following SQL will do that:

    SQL> delete from z601 where z601_rec_key like 'PERPRINT-2005%' and z601_type = 'ENC';

    Be sure to run p_file_03 to back up the z601 table before performing any such SQL.

    Additional Information

    faq


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Library batch queue shut down after job failed. Is this normal?
      • Library for profile should be an administrative library
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 17.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    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