Generate Agent / Salesman / Item wise Commission Report

YouTube: How to Generate Agent / Salesman / Item wise Commission Report?

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.