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.
Last updated