• Go to Daily Reports > Business Analysis.

• A 'Sale Purchase Analysis' window will appear. In 'Analysis' option, the user will select 'Bill'.

• Then select 'All' beside the 'V/S' option.

• The user will select 'Sale Return Analysis' &'Detail'.

• Then feed date range as per the requirement.

Now the user will click on 'Other Filters'.

An 'Other Filters' window will appear.

The user will select 'Items'.

A 'Select items' window will appear.

The user will place check mark against 'Select All' to select All Items.

Click on 'Done'.

Then again click on 'Done'.

The user will now click on 'Show'.

Now All Item Sale Return Details will show.

The user will click on 'Column Filter.

A 'Select Column Filter' window will appear.

The user will select 'Expiry Date'.

Select Other Filters as per the requirement.

Click on 'Done'.

• Then user will click on 'View/ Excel/ CSV/ Print' etc. as per the requirement.

• Suppose, click on 'Excel'.

• An alert of 'Do you want to print Grid view in excel' will appear. Click on 'Yes' to generate the report in excel format.

• Click on 'Ok'.

After following the above steps, the item bill wise purchase report will get generated in excel.