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. Change in Fines Policy

    Change in Fines Policy

    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:
    We have had a change in fines ceiling from $20 to $1. We have changed tab31 to reflect this, however, only when the record in updated in the GUI is the new fine applied. Is there a way to apply this change globally?

    Resolution:
    You can update the z305 records in SQL:

    1. Make a backup of the z305 file using p_file_03 (Circulation - Services - Manage Database Tables), so that you can restore the table if there's a problem with your SQL
    2. Run a command in sql like the following:

    update z305
    set Z305_CASH_LIMIT='0000000100';
    Follwed by this command:
    commit;

    This will change the limit for ALL your local patron records. If you need to limit it to specific patron statuses you should add the following line after the 1st line:

    where Z305_BOR_STATUS=nn

    (nn is the patron status number concerned)

    I would also recommend doing this on the test server before you do it on the production server.

    Additional Information

    faq


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Change in due dates automatically taking effect immediately in v20?
      • Change Item Status for a Set of Items
    • 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