Does anyone have an example of a customized Subs Renewal Notice they could share? I'd like to bring in extra fields like Base Price, extra phone numbers, etc.
I'm debating if I should create a whole new process or to call the existing SPs (tp_gen_all_ren_notices & tp_get_ren_notices) and then try to add the extra fields after they run, but I don't know how to link Base Price to the summarized output from tp_get_ren_notices.
Thanks,
John Stephenson
Cincinnati Symphony Orchestra
Hi John,
I attached copies of our custom reports. These reports get printed on pre-printed stock. Our process is to first run the canned report. Then use the set number to generate our custom renewal notices.
Jon
Thanks. I can definitely see some advantages of doing it that way, since you're still basing it on the standard renewals, and the renewal sql code would still get upgraded in newer versions.
I'm most interested in the sql code/stored procedures to add custom info to the renewals, especially base price (if anyone has done it.) Sorry, my question wasn't very clear.