> For the complete documentation index, see [llms.txt](https://kb.logicerp.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/faqs/reports/generate-sale-order-history-report.md).

# Generate Sale Order History Report

**YouTube:** [How to generate Sale Order History Report?](https://youtu.be/9VR2F6bSdQI)

## How to Generate Sale Order History Report?

In this tutorial, we’ll guide you through the process of configuring the **Sale Order History Report** in Logic ERP.

***

### **Access the Sale Order History Report**

* Navigate to the **Reports/Queries** section.
* Under **Order Reports**, open the **Sale Order History Report**.
* Click on **Configuration** to create a new report setup.
* Assign a **suitable configuration name**.

<figure><img src="/files/nzcC020VTqgI9hh5WV8j" alt=""><figcaption></figcaption></figure>

***

### **Configure Report**

* Under **Print Options**, tick to enable **Party-wise Totals** and **Grand Totals**.

<figure><img src="/files/oe6sSpivoutJtfE8oLMl" alt=""><figcaption></figcaption></figure>

* Navigate to Report Options and define the **Report Order** based on your preference.

<figure><img src="/files/jsU7rBjAtrr1pVFmSN78" alt=""><figcaption></figcaption></figure>

* Enable the option **Show Pending Sale Orders** if you want to include both **pending** and **retrieved** orders in the report.

<figure><img src="/files/lLxDQOt682ixmuhQ2TVI" alt=""><figcaption></figcaption></figure>

***

### **Save and Generate the Report**

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

<figure><img src="/files/tE6mnO4KDeSqgi1r63Ky" alt=""><figcaption></figcaption></figure>

* The report will initially appear blank.

***

### **Add and Customize Columns**

* Click on **Setup Column Attributes** to define which columns you want to display.
* Select columns such as:
  * **Sale Bill Number**
  * **Order Number and Date**
  * **Customer Name**
  * **Challan Quantity**
  * **Billed Quantity**
  * **Bill or Challan Amount**
* Use the **arrow keys** to rearrange column order as needed.

<figure><img src="/files/FywHtt6XCz92pkn74ShA" alt=""><figcaption></figcaption></figure>

* Save the configuration and press **F2** to refresh the report.

***

### **View Report Output**

* The report now displays a detailed **history of sale orders** within the selected date range.
* It shows which sale orders have been retrieved in which bills and also lists pending orders because the **Show Pending Sale Orders** option is enabled.

<figure><img src="/files/jLpaEQKbswOpeqYI8C0J" alt=""><figcaption></figcaption></figure>

***

### **Filter Retrieved Orders Only**

* To view **only retrieved sale orders**, open the **Configuration Settings** by pressing "**F5"**.
* Disable the **Show Pending Sale Orders** option and save.

<figure><img src="/files/4epvDIOQNQKpap2zmfRu" alt=""><figcaption></figcaption></figure>

* The report will now display only those sale orders that have already been retrieved in bills.

<figure><img src="/files/nk1HdSomiqQXnmE4MWiW" alt=""><figcaption></figcaption></figure>

***

Y**ou have successfully configured and customized the Sale Order History Report in Logic ERP.**


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/faqs/reports/generate-sale-order-history-report.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
