> 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-item-wise-commission-report.md).

# Generate Agent / Salesman / Item wise Commission Report

**YouTube:** [How to Generate Agent / Salesman / Item wise Commission Report?](https://www.youtube.com/watch?v=bFDwtzOUw8w)

## How to Generate Agent / Salesman / Item wise Commission Report?

In this tutorial, we will learn how to **configure the Agent + Product-Wise Commission Report** in **Logic ERP**, which helps analyze commission details for each agent and product.

***

### **Create a New Report Configuration**

* From the **Main Menu**, go to the **Reports/Queries** section.
* Open **Agent Wise Reports**.
* Select **Agent + Product Wise Commission Report**.
* Click on **Configuration** to create a new report setup.
* Assign a **suitable configuration name** for easy identification.

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

***

### **Define Print Columns**

* Click on **Print Columns** to select the columns you want to display in the report.
* For this report, include the following key fields:
  * Agent Name
  * Item Name
  * Sale Quantity
  * Sale Value
  * Commission Percent
  * Commission Value

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

* You can also use the **Arrow Keys** to rearrange the column order as required.
* Once done, **Save** the configuration.

***

### **Configure Totals**

* Under the **Total** section:
  * Enable the options for **Agent Totals** and **Grand Totals**, if needed.
  * This helps display subtotal and overall commission summaries in the report.

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

***

### **Set Report Options**

* Navigate to the **Report Options** section.
* Configure the following settings:
  * **Filter On Field:** All Bills
  * **Report Sorting:** As per preference (recommended: Item + Size)
  * **Report View:** Item + Size

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

* Apply the **Agent Filter** based on how agents are assigned:
  * Select **Bill Wise** if the agent is defined in the **Bill Header**.
  * Select **Item Wise** if different agents are defined for individual **items within the bill**.

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

***

### **Generate the Report**

* After configuring all settings, **Save** the changes.
* From the **Configuration List**, select the setup you just created.
* Click on **Create Report** to generate the output.

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

***

### **Final Outcome**

The generated report will display detailed **Agent-Wise Commission Information** for each product, including:

* Agent and Item Names
* Sale Quantities and Values
* Commission Percentage
* Total Commission Value

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

This report provides a clear breakdown of agent earnings and product-wise commission performance, ensuring accurate analysis and reporting.


---

# 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-item-wise-commission-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.