I saw a post similar to this on the forums from 2009 but it had no answers:
Before I set about writing something custom, i was wondering if anyone had a script that pulled the subscription renewal info by line item (i.e. combining the seats) rather than by sub line item (one column for every seat).
Thanks!
RJ
Richard - I haven't done this for our renewals (mostly because we have many people who have seats with different prices in one order) but I have for our local subscription history - and I believe the canned sub history procedures do as well. This might be a good place to look to 'borrow' the code you need.
HTH,
Heather
Thanks! I ended up just writing the entire thing from scratch - it pulls a max of three superpackages and the seats for each associated sub package underneath it along with the total cost, suggested contribution amount and whatnot.
On to the LP_UPDATE_SUBS_HIST procedure!