Question

Is there an Aleph report which lists all the overdue letters that have been sent out but have not yet been invoiced? (The cash transaction is created manually.)

Answer

Presuming that the overdues which have been invoiced have a loan status of Lost, the cir-04 Loan Report can be run with:

1. Loan status "Active Loan" (this excludes statuses "Lost" and "Claimed Returned")

and

2. a "Due Date To" of the date by which an overdue letter would have been sent out.

Additional Information

If more than one overdue notice is sent and only overdues which have received the final overdue notice are desired, the preceding would not work; SQL would need to be used, checking for cases where z36_letter_number = '0n' (where "n" is number of the final overdue notice) and z36_status = 'A'.

• Article last edited: 11/20/2013