# Print Customer’s Current Ledger Balance in Printing

**YouTube:** [How to Print Customer’s Current Ledger Balance in Sale Bill Printing?](https://www.youtube.com/watch?v=jU2HOTTQXzo)

## How to Print Customer’s Current Ledger Balance in Sale Bill Printing?

In this tutorial, we will demonstrate how to display the **party’s current balance** in the sales bill print format.

***

### Add Current Balance **u**sing Sale Multiple Printing Configuration

* Go to the menu and open **Sale Multiple Printing Configuration**.
* Select the required series and under **Print Options**, open the **Header Section**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2F0obdN31PNmXqcPDrZKdA%2FVB%20-%20Header.png?alt=media&#x26;token=dcb5eb97-36ce-4c17-af24-9db118a5c730" alt=""><figcaption></figcaption></figure>

* Click on **Insert Shapes**&#x20;

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FJupVwpmvCYDW3obCBTse%2FVB%20-%20Insert%20Shape.png?alt=media&#x26;token=3be0017f-600a-424d-950f-4abbf19bd1e7" alt=""><figcaption></figcaption></figure>

* Click on the rectangle and insert it in the appropriate place.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fu8yTzePZi5dMZ6l2WBbv%2FVB%20-%20Insert%20Rectangle.png?alt=media&#x26;token=84f87702-97fa-45ff-83df-ffae61c60c16" alt=""><figcaption></figcaption></figure>

* Right-click to **remove the outline**.
* Right-click again and select **Insert Field/Text**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fb8LaPeTRDvRs8kfEnOHk%2FVB%20-%20Add%20CMD.png?alt=media&#x26;token=18fa650c-1098-436d-a3dc-742d70f3058a" alt=""><figcaption></figcaption></figure>

* Enter the label name as **Current Balance**.
* From the list of fields, search for **Current Balance** and **double-click** to insert it.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FppBjoGJBCAIQaAcXQJFv%2FVB%20-%20Cr%20Balance%20cmd.png?alt=media&#x26;token=419871b6-0863-4ab0-aa9f-7da0f896ad73" alt=""><figcaption></figcaption></figure>

* Save the layout and configuration.
* Now return to the **Sale Bill Window** and click on **Preview**.

The customer’s **current balance** will now be displayed in the bill header.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FnISxkxEXXJkOhX2YzeJL%2FVB%20-%20Preview.png?alt=media&#x26;token=9637c8d5-9181-48c7-912f-6c45ed441f1e" alt=""><figcaption></figcaption></figure>

***

### Add Current Balance using Designer Printing Format

* From the menu bar, go to **Continuous Printing → Sales Bill Print Designer and Printing**.
* Choose the required configuration and sales bill, then press **Refresh**.
* Open the **Design Window**

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2F6nsLp1Y0t4syBBm1SaLg%2FDP%20-%20Design.png?alt=media&#x26;token=672450b8-60e4-4241-9d97-8abe7c76dac4" alt=""><figcaption></figcaption></figure>

* Inside the **Header Section** ensure space is available.
* Enter the label name.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2F3LHI7XsL41wOgbnvo6gu%2FDP%20-%20Heading.png?alt=media&#x26;token=f67e5688-4106-4025-84d2-b56e8d2113d7" alt=""><figcaption></figcaption></figure>

* At the bottom-left **Properties Menu**, open the **Expression Designer**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FvEyVaqT3qFn6VydQV3sc%2FDP%20-%20Expression%20Process.png?alt=media&#x26;token=b4d4a428-789f-45bd-b431-1fc8910cc02a" alt=""><figcaption></figcaption></figure>

* From the field list, select **Ledger Balance** and subtract the **Net Bill Amount**.
  * Use the **Equals (=) symbol** to check the result.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FReLkcENqP7C9IQ6rfvMQ%2FDP%20-%20Designer%20Formula.png?alt=media&#x26;token=64ac332f-d0b8-4292-a984-fe07e17d5904" alt=""><figcaption></figcaption></figure>

* Save the expression with a proper name and press **OK**.
* The saved expression will now appear under the **Expression Table**.
  * Right-click to **insert it into the header**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FiFe62wBh1BlqonIOLdhI%2FDP%20-%20Insert%20DP%20Printing.png?alt=media&#x26;token=70491173-dcd7-4dca-b509-5ba23ccbd4fe" alt=""><figcaption></figcaption></figure>

* Once inserted, right-click the field and open **Field Properties**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FWhQfmTQoG0l0NVNlLs94%2FDP%20-%20Field%20Properties.png?alt=media&#x26;token=211b8e59-f290-4bc1-ba4f-91ae6fb6cfcd" alt=""><figcaption></figcaption></figure>

* Set the **Category** to *Number*.
* Define the required **decimal places**.
* Click **Format** to apply changes.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FTcZkZ2473FI8Z8NmUKR9%2FDP%20-%20Format.png?alt=media&#x26;token=73bb8b72-e095-4e15-98c8-04f8db27c524" alt=""><figcaption></figcaption></figure>

* Save the settings and preview the bill.

The **party’s current balance** is now displayed correctly in the print format.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fco3yJTgfIOeA8yK8O6qF%2FDP%20-%20Preview.png?alt=media&#x26;token=8cda626a-ca4d-4adb-a09e-e0c276eb5d1b" alt=""><figcaption></figcaption></figure>
