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

Description:
We are setting up overdue notices for the first time (using p_cir_51) and want to test this without waiting for the multi-day intervals specified in tab32.

Resolution:
There are two possibilities:

1. (temporarily) set the interval for each notice in tab32 to "01". This means that you should have to wait for no more than one day for the next notice to be produced. OR ...

2. Use SQL to update z36 records in the Test database:

a. to get the first notice: change the z36_due_date to yesterday's date and run p_cir_51 with Update database="Y"; the z36_letter_number should change to '01';

b. then, to get a second notice: update the z36_letter_date to yyyymmdd {where yyyymmdd = today - nnn (where nnn is the value in tab32, col. 5, of the "01" notice)} and run p_cir_51 with Update database="Y"; the z36_letter_number should change to '02';

c. then, to get a third notice: update the z36_letter_date to yyyymmdd {where yyyymmdd = today - mmm (where mmm is the value in tab32, col. 5, of the "02" notice)} and run p_cir_51 with Update database="Y"; the z36_letter_number should change to '03';

d. etc.

• Article last edited: 10/8/2013