# Generate HSN- wise Sale Report

**YouTube:** [How to Generate HSN- wise Sale Report?](https://www.youtube.com/watch?v=lxnOBdUorc4)

## How to Generate HSN- wise Sale Report?

In this tutorial, we will learn how to configure an **HSN-Wise Sales Report** in Logic ERP.

***

### **Access the Sales Register Report**

* Navigate to the **Reports and Queries** section.
* Under **Sales Registers**, open the **Sales Register Cross Tab Report**.
* Click on **Configuration** to create a new report and assign a suitable configuration name.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fw4kucej7XtLJGlOnLhHA%2FHSN%20Wise%20sale%20report.png?alt=media&#x26;token=465a9ce1-a528-4ac9-9abc-abc0d33f03a7" alt=""><figcaption></figcaption></figure>

***

### **Configure Report Option**

* Navigate to **Report Options**.
* Under **Report Consolidation**, enable the **HSN Code** option.
* In the **Report Totals** section, enable the **Grand Total** option to display overall totals.
* Adjust the **Report Order** by moving the **HSN Code** option to the top using the arrow keys.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fbp2Cy2zz6NVes1EtxQEN%2FReport%20Options.png?alt=media&#x26;token=0893cdc4-5bec-457c-bf85-173d98fd12ad" alt=""><figcaption></figcaption></figure>

***

### **Configure Transaction Options**

* Under **Transaction Options**, enable the **Net Sale Value** option.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FlQdIMDNW2B6AwEKT19hf%2FNet%20Sale%20Value.png?alt=media&#x26;token=12e81df3-defc-49d6-b363-fe2016c7b765" alt=""><figcaption></figcaption></figure>

***

### **Save Configuration and Customize Columns**

* Once all selections are made, **save** the configuration.
* From the list of available configurations, select the one you just created and click **Create**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2F2SllaKICFMJFYF8ZL3bJ%2FCreated%20Report.png?alt=media&#x26;token=ab9af371-adc0-4a83-9642-e7d8968b2c32" alt=""><figcaption></figcaption></figure>

* By default, all columns will be displayed.
* Open **Setup Column Attributes**, then unselect all columns.
* Use the search bar to locate and enable the **HSN Code** and **HSN Code Description** columns.
* You can also enable additional columns as per your reporting needs.
* Rearrange the column order using the arrow keys.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FPVa9HmdK7cmcI6AVKUUl%2FSet%20Col%20Att.png?alt=media&#x26;token=deaa7e2c-480d-4b28-a492-8c7650a6b90f" alt=""><figcaption></figcaption></figure>

* After finalizing, **save** the settings.

***

### **Generate and View the Report**

* Press **F2** to refresh the report.
* The system will now display an **HSN Code-Wise Consolidated Sales Report** for the defined date range.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FDPs3YJo0wW2NjH08vODN%2FFinal%20Report%20View.png?alt=media&#x26;token=35a2c7c9-7b1c-44bb-adb9-508294bd0fca" alt=""><figcaption></figcaption></figure>

***

**You have successfully configured the HSN-Wise Sales Report in Logic ERP.**