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

Description:
Looking at the "Payments Received Report" (p_cash_03), we find that in version 18 the cash receipts are skipping numbers. We have had 5 missing numbers in the past couple of weeks.

For instance, receipt number 3461 is missing.

I thought the cash receipts numbers were generated in sequence and automatically by Aleph.

Resolution:
As can be seen in the SQL below, no cash receipt has been produced with the number '3461':

abc50@ALEPH1> select z31_rec_key from z31 where Z31_PAYMENT_RECEIPT_NUMBER = '3460';
**** Hit return to continue ****

Z31_REC_KEY
---------------------------
ABC000002359200504300437296

1 row selected.

abc50@ALEPH1> select z31_rec_key from z31 where Z31_PAYMENT_RECEIPT_NUMBER = '3461';

no rows selected

abc50@ALEPH1> select z31_rec_key from z31 where Z31_PAYMENT_RECEIPT_NUMBER = '3462';
**** Hit return to continue ****

Z31_REC_KEY
---------------------------
ABC5156 200810161371419

I'm uncertain just why '3461' was skipped. (You might want to look for patterns, such as the number after a "Lost material - Replacement - System issue" -- which is what Receipt no. 3460 is -- always being skipped.)

In any case, it is not a problem. If you are concerned about the possibility that receipts are failing to print in a case where a payment has been made, then you can do the SQL for the number, as shown above, to confirm that there is no cash transaction with this Z31_PAYMENT_RECEIPT_NUMBER.

[Later:] v18 rep_change 1958 (v19 rep_change 545) addresses one possible cause of gaps in receipt numbers:

Description: The counter for the last receipt number was being increased by 1 when a lost loan was being returned, even if no receipt was being generated. It caused a lack of consecutiveness in the receipt numbers. This has been corrected.

• Article last edited: 10/8/2013