Hi, I thought this might be useful to post. The question came up whether or not we can have order payment schedule information in the order email acknowledgements generated by tessitura. Even though this information is not part of the dataset for the order email acknowledgement, it is possible to bring this information in.
How this is done is by creating a stored procedure that returns the payment schedule information for the order. Add an entry to the tr_local_procedure table so that it can be executed through the web api's executelocalprocedure method.
Then in the order email acknowledgement template make a call to the web api method and process the data. Below is an example of what the code in the template could look like.
Jon,
Do you know how we can implement payment plans online to include donations? I feel like it's been done but I can't find documentation on how to do it on our website that Lynch2 built for us. I'm trying to do renewals with donations on a three month payment plan.
Any ideas?
Thanks in advance.