• Replies 2 replies
  • Subscribers 340 subscribers
  • Views 58 views
  • Users 0 members are here
Related

Email Order Acknowledgements with Payment Schedule Info

Jon Ballinger
$organization

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.

 

Parents
  • $organization
    Hi Jon - This solution looks like it would be very useful for us. However, I'm having difficulty executing a local procedure. Below is the top of our test email template which results in a compilation error when trying to send a confirmation. It's calling a very simple test proc that returns the customer number of an order. I put it in just to test. It just takes the parameter of @order_no. I can execute this proc from the API and if I remove the call to the local proc I can return the sessionkey in the email so I must be hitting the API. I also granted execute to impusers for the proc. Do you have any tips on what we could try to get this working?


    [edited by: Todd Lantry at 1:57 PM (GMT -6) on 8 Feb 2013] removing code to see if it fixes the issue with the forums.
Reply
  • $organization
    Hi Jon - This solution looks like it would be very useful for us. However, I'm having difficulty executing a local procedure. Below is the top of our test email template which results in a compilation error when trying to send a confirmation. It's calling a very simple test proc that returns the customer number of an order. I put it in just to test. It just takes the parameter of @order_no. I can execute this proc from the API and if I remove the call to the local proc I can return the sessionkey in the email so I must be hitting the API. I also granted execute to impusers for the proc. Do you have any tips on what we could try to get this working?


    [edited by: Todd Lantry at 1:57 PM (GMT -6) on 8 Feb 2013] removing code to see if it fixes the issue with the forums.
Children
No Data