• Go to Sale > Product Wise Sales Analysis.

• A 'Product Wise Sales Analysis' window will appear.

• In 'Branch' field, the user will select the branch from dropdown whose report needs to be view.

• Suppose select 'Ignexto Biotex Private Limited'

• In 'Amount' field, the user will select the Calculation for amount .

• Suppose select 'Amount-Discount'.

In 'Challan' field, the user will select option as following:

With Challan: To view report with challan transaction details.

Without Challan: To view report without challan transaction details.

Suppose select 'With Challan'.

• In 'Period' field, the user will select the period whose report needs to be view i.e. last financial year, current month etc.

• Suppose select 'Last Financial Year'.

• In 'From Date-To Date' field, the user will mention from which date till which date report needs to be view.

• Now the user will click on 'Sync' tab.

• A 'Product Wise Sales Analysis' report will get displayed.

• In order to generate 'Excel' of the report, the user needs to click on 'Export to Excel' tab (as showing in below fig).

After following the above steps, the user can view that the Product Wise Sales Analysis report will get generated in Excel.