Hi folks,
X-posting this from Ticketing where it didn't get any responses:
* * *
We just printed our subscription renewal notices, and did so based on a list so these could be restricted only to those constituents who did not renew on their own.
We also used this list to run an output set to merge to mailing envelopes. The output set (and envelopes) are ordered by constituent ID, but the Subscription Renewal Notice utility ran with nine (out of 160) invoices out of order at the end. (All of the preceding invoices were in order by constituent ID).
Does anyone know what caused that result? Is this ordering caused by InfoMaker or the Impresario stored proc?
Are you using a custom subscription form and procedure? I'd double check the stored procedure first. There might be a weird Sort By criteria tacked in there that you aren't expecting. That tripped me up last year anyway.
On a related note, when I run our subscription forms I also save the report data to excel after it generates. It outputs the data in the same order that the forms are printed. I then have our envelopes printed using that data, in that order. Then it doesn't matter if forms are out of order for some reason. Haven't had any problems since we started doing it that way!