---
title: How to automate downpayment process in your offers
description: 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
---
[Skip to content](https://support.bmileisure.com/support-center/how-to-automate-downpayment-process-in-your-offers#main-content)
English
Show submenu for translations
[Customer portal](https://support.bmileisure.com/tickets-view?hsLang=en)
![logo\_big\_darkBG@2x.png\]](https://support.bmileisure.com/hs-fs/hubfs/logo_big_darkBG@2x.png?height=50&name=logo_big_darkBG@2x.png)
Open main navigation
Close main navigation
- English
Show submenu for translations
- [Customer portal](https://support.bmileisure.com/tickets-view)
- [Main website](https://www.bmileisure.com/en/)
[Main website](https://www.bmileisure.com/en/)
Welcome to the BMI Support Portal. How can we help you?
- There are no suggestions because the search field is empty.
1. [Support Center](https://support.bmileisure.com/support-center?hsLang=en)
2. [Guest Activation](https://support.bmileisure.com/support-center/guest-activation?hsLang=en)
3. [Offers and reservations](https://support.bmileisure.com/support-center/guest-activation?hsLang=en#offers-and-reservations)
# How to automate downpayment process in your offers
### Introduction
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.
1. Online payment facilitator ID.
2. Online booking setup.
3. Main email template for the offer.
4. Project state ID when you want to send the link.
#### Configure the parameter
1. Navigate to “Menu”-\>”Post Office”-\>”Template parameter”
2. Create a new entry named “paymentlink”.
3. The record type is “reservation”
4. In the SQL field, you can paste the following statement.
”
select coalesce((select first 1 ‘\To ensure your spot in this exciting activity we require a downpayment which can be done by following \this\ link.\
‘
from T\_BILL\_PAYMENT BLP
where BLP.F\_BLP\_STATE = **1** and
BLP.F\_PM\_ID = **24965** and
exists(select null
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
“
5. Adjust the bold text to some descriptive text of how you want the link to look like
6. Adjust the red text to the right ID’s
7. 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.
How the Offer will show in case 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](https://support.bmileisure.com/support-center/how-to-create-an-online-downpayment-request?hsLang=en) KB entry.
- [Guest Activation](https://support.bmileisure.com/support-center/guest-activation?hsLang=en#main-content)
- [Online Booking](https://support.bmileisure.com/support-center/guest-activation?hsLang=en#online-booking)
- [Registration kiosk](https://support.bmileisure.com/support-center/guest-activation?hsLang=en#registration-kiosk)
- [Group booking](https://support.bmileisure.com/support-center/guest-activation?hsLang=en#group-booking)
- [Event booking (B2B)](https://support.bmileisure.com/support-center/guest-activation?hsLang=en#event-booking-b2b)
- [Offers and reservations](https://support.bmileisure.com/support-center/guest-activation?hsLang=en#offers-and-reservations)
- [Combo deals](https://support.bmileisure.com/support-center/guest-activation?hsLang=en#combo-deals)
- [Guest Engagement & Retention](https://support.bmileisure.com/support-center/guest-engagement-retention?hsLang=en#main-content)
- [CRM](https://support.bmileisure.com/support-center/guest-engagement-retention?hsLang=en#crm)
- [Email marketing](https://support.bmileisure.com/support-center/guest-engagement-retention?hsLang=en#email-marketing)
- [Mobile app](https://support.bmileisure.com/support-center/guest-engagement-retention?hsLang=en#mobile-app)
- [Mobile push notification](https://support.bmileisure.com/support-center/guest-engagement-retention?hsLang=en#mobile-push-notification)
- [Memberships & subscriptions](https://support.bmileisure.com/support-center/guest-engagement-retention?hsLang=en#memberships-subscriptions)
- [Loyalty system](https://support.bmileisure.com/support-center/guest-engagement-retention?hsLang=en#loyalty-system)
- [Promotions & discounts](https://support.bmileisure.com/support-center/guest-engagement-retention?hsLang=en#promotions-discounts)
- [Cross and upsell](https://support.bmileisure.com/support-center/guest-engagement-retention?hsLang=en#cross-and-upsell)
- [Video marketing (TV) & digital signage](https://support.bmileisure.com/support-center/guest-engagement-retention?hsLang=en#video-marketing-tv-digital-signage)
- [Streamlined Operations](https://support.bmileisure.com/support-center/streamlined-operations?hsLang=en#main-content)
- [Point of Sales](https://support.bmileisure.com/support-center/streamlined-operations?hsLang=en#point-of-sales)
- [Ticketing](https://support.bmileisure.com/support-center/streamlined-operations?hsLang=en#ticketing)
- [Offers & invoices](https://support.bmileisure.com/support-center/streamlined-operations?hsLang=en#offers-invoices)
- [Smart scheduling](https://support.bmileisure.com/support-center/streamlined-operations?hsLang=en#smart-scheduling)
- [Staff management](https://support.bmileisure.com/support-center/streamlined-operations?hsLang=en#staff-management)
- [Food & beverage management](https://support.bmileisure.com/support-center/streamlined-operations?hsLang=en#food-beverage-management)
- [Maintenance & spare parts](https://support.bmileisure.com/support-center/streamlined-operations?hsLang=en#maintenance-spare-parts)
- [Timing](https://support.bmileisure.com/support-center/streamlined-operations?hsLang=en#timing)
- [TV Video marketing & digital signage](https://support.bmileisure.com/support-center/streamlined-operations?hsLang=en#tv-video-marketing-digital-signage)
- [Integrations](https://support.bmileisure.com/support-center/integrations?hsLang=en#main-content)
- [Payment processors](https://support.bmileisure.com/support-center/integrations?hsLang=en#payment-processors)
- [Integrated hardware](https://support.bmileisure.com/support-center/integrations?hsLang=en#integrated-hardware)
- [Fiscal integrations](https://support.bmileisure.com/support-center/integrations?hsLang=en#fiscal-integrations)
- [Kitchen Display Systems](https://support.bmileisure.com/support-center/integrations?hsLang=en#kitchen-display-systems)
- [Insights & Reporting](https://support.bmileisure.com/support-center/insights-reporting?hsLang=en#main-content)
- [Easy data access and analysis](https://support.bmileisure.com/support-center/insights-reporting?hsLang=en#easy-data-access-and-analysis)
- [Quick data export](https://support.bmileisure.com/support-center/insights-reporting?hsLang=en#quick-data-export)
- [Microsoft Power Bi](https://support.bmileisure.com/support-center/insights-reporting?hsLang=en#microsoft-power-bi)
- [Troubleshooting](https://support.bmileisure.com/support-center/troubleshooting?hsLang=en#main-content)
- [Hardware](https://support.bmileisure.com/support-center/troubleshooting?hsLang=en#hardware)
- [Timing](https://support.bmileisure.com/support-center/troubleshooting?hsLang=en#timing)
- [Windows OS](https://support.bmileisure.com/support-center/troubleshooting?hsLang=en#windows-os)
- [Manuals](https://support.bmileisure.com/support-center/manuals?hsLang=en)
- [Can’t find the answer to your question?](https://support.bmileisure.com/support-center/cant-find-the-answer-to-your-question?hsLang=en)
- [Product Updates](https://support.bmileisure.com/support-center/product-updates?hsLang=en#main-content)
- [October 2023](https://support.bmileisure.com/support-center/product-updates?hsLang=en#october-2023)
[-1.png?width=37&height=37&name=2-%20Alternative%20logo%20(Black)-1.png "Chill listening crop-3")](https://www.bmileisure.com/en/)
Copyright © 2026, BMI Leisure