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. (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