How to automate the down payment process in your offers.
As many of you know we are able to accept the down payment for an event through our web portal. In this tutorial, we will show you how to integrate this in your offer so your customer can use the link in the offer to confirm his event.
Gather the required information
In order to set this up, we will need to have the following information and prepare your environment.
- Online payment facilitator ID.
- Online booking setup.
- Main email template for the offer.
- Project state ID when you want to send the link.
Configure the parameter
- Navigate to “Menu”->”Post Office”->”Template parameter”
- Create a new entry named “paymentlink”.
- The record type is “reservation”
- In the SQL field, you can paste the following statement.
select coalesce((select first 1 ‘<p>To ensure your spot in this exciting activity we require a downpayment which can be done by following <a href=”https://booking.sms-timing.com/yourvenuename/downpayments/’ || BLP.F_BLP_ID || ‘”>this</a> link.</p>
from T_BILL_PAYMENT BLP
where BLP.F_BLP_STATE = 1 and
BLP.F_PM_ID = 24965 and
from T_BILL_2_BILL_PAYMENT B2B
inner join T_BILL BL on BL.F_BL_ID = B2B.F_BL_ID
where B2B.F_BLP_ID = BLP.F_BLP_ID and
BL.F_PRJ_ID = @RECORDID)), ”) from rdb$database
- Adjust the green text to some descriptive text of how you want the link to look like
- Adjust the red text to the right ID’s
- Save your work.
Implement the parameter
Now that we have our work in this parameter you can add this in any part of any “offer/proposal” template. We implemented the whole text, including the HTML tags in the parameter to make sure the client does not see anything related to the downpayment whenever there is no payment required.
Practical usage notes
The setup is made so it takes the link of the first pending online payment. Meaning that if you want to ask for a second or any following payment the previous payment’s state has to change. This state can change by paying the requested amount or by manually changing it to another state.
Like this, you could also implement this link in the invoice and make a payment request for the outstanding amount.
To get information about how to create a payment request you can read this KB entry.