Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Duplicate cash transactions

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Problem: 
    In certain cases duplicate cash transactions appear on the patron's card. 

     

    Cause: 
    Uncertain, but seems to be connected to the Renew All function, that is, cases where the patron or operator clicks "Renew All" a second time before a first click has been completely processed.

     

    Resolution/workaround: 

    See "Additional Information" below for SQL to locate such transactions.
    The following is a workaround to avoid the problem of double cash transactions from OPAC renewals.

    Add the following change to html page $alephe_root/www_f_lng/bor-include-4 in order to prevent double click on the 'Renew All' link: 

    <td class="bar" align="center" nowrap> 
    <a href="javascript:replacePage('&server_f?func=bor-renew-all&adm_library=$5000&token_id=$9900');" 
    id='renewall'  
    onlick='document.getElementById(this.id).removeAttribute("href");' 
    title="Renew All" class="blue"> 
    Renew All </a> 
    </td> 

    This  bor-include-4.txt  file shows the specific location of the above part within the file. 

     

     

    Additional Information

    The following SQL can be used to locate such cases (-- excluding the cases of partial payments and partial waives, indicated by a non-null Z31_RELATED_Z31_KEY_TYPE value-- ): 
    SQL> select z31_key from z31 where Z31_RELATED_Z31_KEY_TYPE is null and z31_type = '03' group by z31_key having count(*) > 1 order by substr (z31_key,52,8);
    {-- there should be no cases of z31 type '03' fields with exactly the same z31_key (that is, the same item, same loan number, and same returned time) -- with the exception of partial payments or partial waives.  The article Structure of Z31-KEY field [*byte by byte*] shows the elements of this field.}

     


    • Article last edited: 8-Aug-2016