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. Duplicate billing for lost books

    Duplicate billing for lost books

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    Why are bills duplicating?

    From ABC50:
    Ryan Jones (patron id ID47000) is one I am just looking at. His fees have multiplied! Should be $360 not $640.

    In other cases the Replacement and Processing fees are zero -- which is incorrect.

    Resolution:
    Below is SQL showing patron ID47000's fines. Please find cases where you feel that the fine is duplicated. I don't see any cases of the same z31_type for the same item, which is what I would consider duplication....

    abc50@ALEPH1> select z31_date_x, z31_sum, z31_type, substr (z31_key,1,15) from z31 where z31_rec_key like 'ID47000%' and z31_status = 'O';
    **** Hit return to continue ****

    Z31_DATE Z31_SUM Z31_TYPE SUBSTR(Z31_KEY,1,15)
    -------- -------------- ---------- ---------------------------------------------
    20090204 00000000003500 41 000015632000010
    20090204 00000000000500 40 000015632000010
    20090204 00000000003500 41 000034895000010
    20090204 00000000000500 40 000034895000010
    20090205 00000000003500 41 000035747000010
    20090205 00000000000500 40 000035747000010
    20090205 00000000003500 41 000038079000010
    20090205 00000000000500 40 000038079000010
    20090206 00000000003500 41 000051886000010
    20090206 00000000000500 40 000051886000010
    20090206 00000000003500 41 000056614000010
    20090206 00000000000500 40 000056614000010
    20090206 00000000003500 41 005478529000010
    20090206 00000000000500 40 005478529000010
    20090303 00000000003500 41 000190998000010
    20090303 00000000003500 41 000148837000030
    20090303 00000000003500 41 000034895000010
    20090303 00000000003500 41 000015632000010
    20090303 00000000003500 41 000035747000010
    20090303 00000000003500 41 000038079000010
    20090303 00000000003500 41 000056614000010
    20090303 00000000003500 41 000051886000010
    20090303 00000000003500 41 005478529000010
    20090303 00000000000500 40 000190998000010
    20090303 00000000000500 40 000148837000030
    20090303 00000000000500 40 000034895000010
    20090303 00000000000500 40 000015632000010
    20090303 00000000000500 40 000035747000010
    20090303 00000000000500 40 000038079000010
    20090303 00000000000500 40 000056614000010
    20090303 00000000000500 40 000051886000010
    20090303 00000000000500 40 005478529000010

    The case of the Replacement and Processing fees being zero was like KB 16384-3304. See KB 16384-3304.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Duplicate AVA / item info generated in Course Reserves Publishing
      • Duplicate cash transactions
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.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