> 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-agent-salesman-wise-sales-report.md).
# Generate Agent/ Salesman wise Sales Report
**YouTube:** [How to Generate Agent/ Salesman wise Sales Report?](https://www.youtube.com/watch?v=wtCgQgoKONU)
## How to Generate Agent/ Salesman wise Sales Report?
In this tutorial, we’ll learn how to **configure the Agent-Wise Sales Report** in **Logic ERP** using two different methods — through the *Agent + Customer Wise Sales* report and the *Sales Register Cross Tab* report.
***
### **Method 1 - Using Agent + Customer Wise Sales Report**
**Open and Create a New Configuration Report**
* Navigate to the **Reports/Queries** section.
* Under the **Agent Reports** category, open **Agent + Customer Wise Sales**.
* Click on **Configuration** to create a new report setup.
* Provide a **suitable configuration name**.
***
**Define Print Columns**
* Under **Print Options**, open **Print Columns** to view available fields.
* Select the checkboxes for the columns you wish to include in the report.
* Use the **arrow keys** to rearrange the column order as required.
* Once done, **save the changes**.
***
**Configure Totals**
* In the **Total** section, define how totals should appear.
* Since this is an **Agent-Wise Sales Report**, enable both **Agent Total** and **Grand Total** options for summary display.
***
**Set Report Options**
* Go to the **Report Options** tab and configure the following:
* **Report On:** Agent + Bill
* **Report Type:** Bill Wise
* **Report View:** Lot Wise
* **Report Sorting:** Item + Size Wise
* **Agent Filter:** Bill Wise
* Save the configuration.
***
**Generate the Report**
* From the configuration list, select the one you just created and click **Create**.
* The generated report displays detailed **Agent-Wise Sales Data** along with bill details for the selected date range, showing each agent’s name and corresponding billing history.
***
### **Method 2 - Using Sales Register Cross Tab Report**
**Open and Create Configuration**
* Go to **Reports/Queries → Sales Register Cross - Tab Report**.
* Open **Configuration** and define a **new configuration name**.
***
**Configure Report Options**
* Under **Report Consolidation:** Enable **Bill Number**, **Agent**, **Item Details** and **Lot Number.**
* Under **Item Consolidation** section: Once **Item Details** is enabled, select the **Item Name**, **Pack/Size**, and **Shade** columns for item-level insights.
* In the **Report Total** section: Enable **Grand Total** for overall summary.
* Under **Report Order:** Move **Agent**, **Bill Number**, and **Item Details** to the top using the **arrow keys**.
***
**Set Transaction Options**
* Navigate to the **Transaction Options** tab.
* Enable **Display Transaction Details**.
* Choose whether to display transactions by **Value** or **Quantity**.
***
**Customize Columns**
* From the configuration list, select your setup and click **Create**.
* By default, all columns will appear.
* To customize:
* Open **Setup Column Attributes**.
* **Unselect all** columns, then enable only the required ones:
* Bill
* Agent Name
* Bill Number and Date
* Bill Amount
* Total Quantity
* Item Name, Batch, Size, Shade
* Gross Amount and Net Sale Amount
* Rearrange column order using **arrow keys**.
* Save the configuration and press **F2** to refresh.
***
#### **Final Output**
The report now provides a **comprehensive agent-wise sales summary** with detailed bill and item-level information for the selected date range.\
You can use either method based on your preferred report format and level of detail.
---
# 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-agent-salesman-wise-sales-report.md?ask=
```
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.