• 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.  (As noted below, partial payments or partial waives create duplicate transactions but the system accounts for these properly in the amounts.)

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