• Article Type: General
• Product: Aleph
• Product Version: 20

Description:
Sometimes the "wrong" barcode is provided by the Cash Details screen (user-cash XML) in the lower right pane of the Circulation Cash node.

Resolution:
The barcode displayed in the user-cash XML is taken from the Item information as it was on the relevant loan date. For this purpose Z30H is read.
So, if the relevant Loan History (Z36H) record has REC-KEY = 000006802000010 and loan date = 20100414, the system checks in Item History (Z30H) to find out the item information from 14 April 2010:

xxx50@ALEPH20>
select Z36h_REC_KEY, Z30H_REC_KEY, Z30H_H_DATE, Z36H_LOAN_DATE, Z30H_BARCODE
from Z36H, Z30H
where Z36H_REC_KEY=substr(Z30H_REC_KEY,1,15)
and Z36h_REC_KEY = '000006802000010'
and Z36H_LOAN_DATE < Z30H_H_DATE;

Z36H_REC_KEY Z30H_REC_KEY Z30H_H_DATE Z36H_LOAN_DATE Z30H_BARCODE
--------------- --------------------- ----------- -------------- ------------------------------
000006802000010 000006802000010000001 20100421 20100414 A4078128
000006802000010 000006802000010000002 20100728 20100414 A4073398
2 rows selected.

So the first Z30H record above is relevant. This Z30H record has barcode = A4078128 and it is correctly displayed in the GUI. The Item History record can also be viewed in the GUI CAT by calling up barcode A4119623 and going to "All Items History".

This is different from the barcode that is displayed in the following locations:
* the Print button to the right of the user-cash data display
* displaying the log entry for this record by clicking the Log button in the upper right part of the cash screen
In these locations, the CURRENT barcode is displayed.

• Article last edited: 10/8/2013