# Generate Sale Challan History Report

**YouTube:** [How to Generate Sale Challan History Report?](https://youtu.be/Tipf8apE8vo)

## How to Generate Sale Challan History Report?

In this tutorial, we’ll learn how to **configure the Sale Challan History Report** in Logic ERP.

***

### **Access the Sale Challan Reports**

* Navigate to the **Reports and Queries** section.
* Open the **Sale Challan Reports** menu.
* Select **Sale Challan History Report**.
* Click on **Configuration** to create a new report.
* Enter a suitable **Configuration Name** for identification.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FlREgKX9QCGp97mJlQODo%2FConfiguration%20Name.png?alt=media&#x26;token=6ac43db7-0db0-40f7-9899-029a990dda20" alt=""><figcaption></figcaption></figure>

***

### Define Print Columns

* Under the **Print Column** section, select the required fields such as:
  * Sale Bill Date and Number
  * Challan Number and Date
  * Customer Name
  * Challan Quantity, Billed Quantity, and Amount
* Use the **arrow keys** on the right to arrange the columns in your preferred order.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FNnxzaHxekuiTu8tPuTAX%2FSetup%20Column%20Attribute.png?alt=media&#x26;token=0df99cfe-fc80-4fa0-869b-74af5d6d5faf" alt=""><figcaption></figcaption></figure>

* Once finalized, **save the changes**.

***

### **Configure Totals and Filters**

* Go to the **Total Section** and select the parameters for which you want totals to appear.
* Enable the **Grand Total** option for overall totals.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FQHuGFt0YT12gE9Q0iaUB%2FGrand%20Total.png?alt=media&#x26;token=828f439d-e459-4e3f-9ad1-f2f7472e2e6c" alt=""><figcaption></figcaption></figure>

### **Configure Report Options**

* In the **Report Options**, define the **Challan/Return Filter** and select the desired **Report Consolidation** option from the dropdown.
* Define the **Report Order** based on how you want the report to be grouped or displayed.
* If required, enable **Item Consolidation** to group data item-wise.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2F2aP1ebelsOt2FI18R724%2FReport%20Options.png?alt=media&#x26;token=88aa662c-fdf4-4d2f-8493-1e60dd30c34f" alt=""><figcaption></figcaption></figure>

***

### **Generate the Report**

* Save the configuration and select it from the **Available Configurations** list.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FkUngYQQjhk5ZhPznD189%2FCreated%20Report.png?alt=media&#x26;token=2babbc0b-381f-423e-9cce-146ec86addd0" alt=""><figcaption></figcaption></figure>

* The system will now display a **complete Sale Challan History** within the specified date range.\
  It includes detailed information showing **which challans have been retrieved** in which sale bills.\
  If there are **partial retrievals**, the **pending quantities** will appear under the **Balance Quantity** column.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FszLjoVuchSrnBfXg0JEZ%2FReport%20View.png?alt=media&#x26;token=0b80b9a2-3fbb-4e64-acf9-8f5956b2fde6" alt=""><figcaption></figcaption></figure>

***

**You have successfully configured the Sale Challan History Report in Logic ERP.**
