• Go to Purchase > Product Wise Purchase Analysis.

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

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

• In 'Amount' field, the user will select 'Gross Amount or Amount - Discount' to define amount calculation in report.

• 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 for which 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 Purchase 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 Purchase Analysis report will get generated in Excel.