Add GST Tax Columns in item Grid in Printing

YouTube: How to Add GST Tax Columns in Item Details in Sale Bill Printing?

How to Add GST Tax Columns in Item Details in Sale Bill Printing?

In this tutorial, we’ll demonstrate how to add tax columns such as SGST, CGST, and IGST, including both percentage and amount, in the sales bill print format.

Add Tax Columns in Sale Multiple Printing Configuration

• Go to the menu and under Configuration, open Sale Multiple Printing Configuration.

• Select the required Series.

• Click on Print Columns.

  • The list of available columns will appear.

  • Columns already included in the print format will be ticked.

• Use the search bar to find GST-related columns:

  • Search SGST → Tick Percentage and Amount.

  • Search CGST → Tick Percentage and Amount.

  • Search IGST → Tick Percentage and Amount.

• Rearrange the columns if needed and edit the label names.

• Save the configuration.

Now return to the Sale Bill window, modify a bill, and click on Print Preview. You’ll notice that the bill now displays bifurcated GST details.

Add Tax Columns in Designer Printing Format

• From the menu, go to Continuous Printing → Sales Bill Print Designer and Printing window.

• Select the required Configuration and Sales Bill from the search list.

• Press Refresh and open the Design Window.

• Open the Edit Bound Table

• Click on Settings.

• Use Add Column to insert GST fields:

  • Under Bound Columns, search for CGST → insert both Percentage and Amount.

  • Repeat the process for SGST and IGST.

• Define Header Text for each column (e.g., “CGST %”, “CGST Amt”).

• Set the Column Type as Measure.

• Under Other Settings, customize:

  • Cell background color

  • Border style

  • Text alignment

• Click OK and close the bound table.

• Save the configuration and click on Preview.

The GST tax columns are now successfully added, showing both percentage (%) and amount (₹) in the print format.