# Print Balance Loyalty Points

**YouTube:** [How to Print Balance Loyalty Points in Sale Bill Printing?](https://www.youtube.com/watch?v=G8EPEUOlXFA)

## How to Print Balance Loyalty Points in Sale Bill Printing?

In this tutorial, we’ll demonstrate how to **add retail customer balance and loyalty points** to your sales bill print format in Logic ERP.

***

### Add Loyalty Points using Sale Multiple Printing Configuration

* Go to the **Configuration** menu and open **Sale Multiple Printing Configuration**.
* Select the **required bill series** under *Print Options*.
* Open the **Footer Section**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FSS62h2aA2MTp0EkBO6e3%2FVB%20-%20Retail%20Th%20Footer.png?alt=media&#x26;token=01e6aaae-ba95-4be0-93be-091eb9cb2296" alt=""><figcaption></figcaption></figure>

* Set the **font** using the *Font* function.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FIjOfVK3tCzRxEonXxZTW%2FVB%20-%20Retail%20Tm%20Font%20size.png?alt=media&#x26;token=6f0505ea-0e11-4ae8-8f69-4543575f13d6" alt=""><figcaption></figcaption></figure>

* Define the **label name** (e.g., *Balance Points*).
* From the field list, search for **Retail Customer Points**.
  * Either double-click to add it OR select it and click **Add Field**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FLR7991NimGQAf0N91PK4%2FVB%20-%20Retail%20Th%20point%20CMD.png?alt=media&#x26;token=b53de2aa-e57a-4247-88aa-a080674cae30" alt=""><figcaption></figcaption></figure>

* Define the **array number as 7**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fur7jmnxKJdfiYvsAybQG%2FVB%20-%20Retail%20Th%20Array.png?alt=media&#x26;token=8aacf4b8-0ec0-4112-a98a-9bc525d0dcae" alt=""><figcaption></figcaption></figure>

* Save the configuration.

Now go to the **Sale Bill Window → Print Preview**.\
Here, you’ll see:

* **Balance Points: 167**

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FLM2PwasTTiePOLzLeJ9R%2FVB%20-%20Preview.png?alt=media&#x26;token=516eea97-7f62-4312-a862-b7f04a1f1303" alt=""><figcaption></figcaption></figure>

***

### Enable Loyalty Points in Designer Printing Configuration

* From the menu bar, go to **Continuous Printing → Sales Bill Print Designer and Printing**.
* Choose the required **printing configuration**.
* Open **Configuration Menu → Add/Edit Configuration**.
* In **Configuration Settings 2**, tick **Enable Retrieve Retail Customer Points**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FAVDdvghpeRMcP7U81D7k%2FDP%20-%20Configuration.png?alt=media&#x26;token=f074d9f1-c7e5-44d0-87d0-3af99afc287c" alt=""><figcaption></figcaption></figure>

* Save the changes, select the configuration, and refresh the Sales Bill.

***

### Add Loyalty Points using Designer Printing Format

* Open the **Design Window**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FaBjfGbPZMz8OAVMqSxMP%2FDP%20-%20Design.png?alt=media&#x26;token=ac120b50-83c0-40b1-a559-e5a2e535bd0a" alt=""><figcaption></figcaption></figure>

* Go to the **Footer Section**.
* Ensure there is enough space, then from the menu bar:
  * Click **Table → Insert Row**.
  * Define the label (e.g., *Balance Points*).

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FKshFrpQLWzi0JWY02paX%2FDP%20-%20Balance%20Point.png?alt=media&#x26;token=00cd3aaa-9d87-4fed-83ac-a630fd082b1c" alt=""><figcaption></figcaption></figure>

* In the **Properties Panel** (bottom left):
  * Expand **Sale Bill Details → Retail Customer Details**.
  * Locate **Total Points Earned**.
  * Add it to the **Expression Window**.
  * Press **F5** to test the query result (balance points will display).

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FKsCJHKJHqHNMMRSs5UXj%2FDP%20-%20Expression.png?alt=media&#x26;token=00cbbd3f-ee54-4d24-8b02-adbc1eca0c53" alt=""><figcaption></figcaption></figure>

* Right-click and select **Insert** to place the field into the table.
* Adjust the **font, size, and formatting** as needed.
* Save the layout and click on **Preview**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fc9nrvvcNGHYpcRpRNcLp%2FDP%20-%20Preview.png?alt=media&#x26;token=5513a669-b04d-4a45-89d7-728bec344e09" alt=""><figcaption></figcaption></figure>

The **Retail Customer Loyalty Points (earned, redeemed, and balance)** are now displayed in the bill print format.
