Calculate total quantity from sales invoice item table (Bonus item for customer)

[Faisal_Pasha]

Hi everyone!
This is my first post here. In our pharmaceutical business we give bonus item to customer if they purchase a certain number of items as shown in the screenshot below.

I’ve added the bonus column in sales invoice item table. What I want is that below the table total quantity will be calculated including the bonus quantity and the calculated total will be deducted from the stock. For example, in the screenshot it is showing 10. I want it to be 11 and 11 items should be deducted from stock. How can I achieve this?
Thanks in advance.

[winter_wolf]

You have to write custom script for Doctype Sales Invoice to add the Bonus quantity in Total Quantity.

[Faisal_Pasha]

Thanks. But how can I find necessary variables?

[winter_wolf]

So it was adding before, what you need to do is to add the the bonus qty variable to total qty.
Hope this will help.

[avaiskhatri]

@Faisal_Pasha Did you figured out the way to handle bonus?

[Faisal_Pasha]

No. I didn’t do it after that.

[aman_syed]

@Faisal_Pasha is required this type of module in the software.