# 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.
***
### **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
* 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.
***
### **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
* 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**.
***
### **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.
***
### **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
This report provides a clear breakdown of agent earnings and product-wise commission performance, ensuring accurate analysis and reporting.
