--- title: How to add the downpayment link to your offer or invoice. description: In this article, we will enable you to automatically add the downpayment link to your offers or invoice. --- [Skip to content](https://support.bmileisure.com/support-center/how-to-add-the-downpayment-link-to-your-offer-or-invoice#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. [Streamlined Operations](https://support.bmileisure.com/support-center/streamlined-operations?hsLang=en) 3. [Point of Sales](https://support.bmileisure.com/support-center/streamlined-operations?hsLang=en#point-of-sales) # How to add the downpayment link to your offer or invoice. ## In this article, we will enable you to automatically add the downpayment link to your offers or invoice. Our event management tool allows you to create a downpayment link so guests can pay for their event through the Online portal. This link can be created manually or be part of your downpayment policy.  The end result of this setup should be that each reservation with an unpaid downpayment will show a link for the guest to follow and pay this amount. As a result, your reservation will change from the "Option" state to the "Confirmed" To achieve this you need to do the following steps.  1. Get the Pay method ID. 2. Create the parameter. 3. Adapt the template. ### Get The Pay Method ID First, you need to make sure you get the right information. To get this info, follow these steps. 1. Open the menu 2. Then navigate to "Products" \> "Configuration" \> "Pay Methods" 3. Click on the payment method you want to use to accept the downpayment. (Default "Online") 4. Press "CTRL"+"F10" 5. This should show you the ID of the payment methods. 6. Take note of the one needed. (101003 in the example) ![](https://support.bmileisure.com/hubfs/image-png-1.png) ### Create the parameter Now that we have the ID, we will create the parameter. To do this, follow these steps.  1. Open the menu. 2. Navigate to "Communication" \> "Post Office" \> "Parameters" 3. Create a new parameter with the following information 1. Name: "paymentlink" 2. Description: "Selects the online downpayment link." 3. Record type: "reservation, invoice, order" 4. Data Type: "StringKind" 4. adapt the SQL statement to your needs by changing the the bold parts 1. select coalesce((select first 1 'Please, click \This link\ to pay your deposit via credit card.' from T\_BILL\_PAYMENT BLP where BLP.F\_BLP\_STATE = 1 and BLP.F\_PM\_ID = ***PAYMETHOD ID*** 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 2. you can add other text or even make it into a button if preferred. 5. Insert the adapted SQL statement into the SQL field of the parameter. ### Adapt the template Now that we made the parameter, we can use ti in all of our templates. This is easy, just navigate to the template and add the parameter anywhere you want.  You can find your new parameter on the left side. Just drag it into your template. ![](https://support.bmileisure.com/hubfs/image-png-2.png)     - [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) [![Chill listening crop-3](https://support.bmileisure.com/hs-fs/hubfs/2-%20Alternative%20logo%20(Black)-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