YouTube: 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.
Go to the menu and open Sale Multiple Printing Configuration.
Select the required series and under Print Options, open the Header Section.
Click on Insert Shapes
Click on the rectangle and insert it in the appropriate place.
Right-click to remove the outline.
Right-click again and select Insert Field/Text.
Enter the label name as Current Balance.
From the list of fields, search for Current Balance and double-click to insert it.
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.
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
Inside the Header Section ensure space is available.
Enter the label name.
At the bottom-left Properties Menu, open the Expression Designer.
From the field list, select Ledger Balance and subtract the Net Bill Amount.
Use the Equals (=) symbol to check the result.
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.
Once inserted, right-click the field and open Field Properties.
Set the Category to Number.
Define the required decimal places.
Click Format to apply changes.
Save the settings and preview the bill.
The party’s current balance is now displayed correctly in the print format.
Last updated
