Hi,
The standard Subs Renewal Notice does not include the Price Reserve. This is apparently because the Base Seat Map is used to hold the package seat locations for rollovers and is not associated with any performance. As the customer would like to know what Reserve they are sitting in, there must be some way to get this data out as part of the Renewal Notice?
Can anyone assist?
Thanks
Hi Dale
You can certainly get the Reserve and other information, because once you've done the rollover, you've got an Order you can use as a source for the rest of the info.
We don't use the standard renewal notice, of course. We pull a variety of information into a series of spreadsheeten,and send that off to a mailing house to produce the actual renewals, after a lot of proofing.
That uses a mildly complex script developed by Martin, and fairly localised. It's based on the assumption that all of your rollover orders are in a particular season, and there aren't any other active package orders in there, which seems reasonable.
I'm happy to share it if you'd like to look at it, to see if you'd like to go that way. Usual caveats - it's written to be run manually and modified if necessary each time, it's not tidied up or well documented, and it is localised, with magic numbers and so on.
Ken