How to get report on free items

how can i get a report of how many of each item i have given away for free.
As with each invoice we provide a certain percentage of stock for free.

Thank you

Hi ,

When you enter the Item that is free, is it listed on the Sales Invoice separately with a price of 0?

Yes, its price is listed as zero on the invoice.
i want to see how many percentage wise i give for free on each invoice or during a specific period

Take a look at Custom Reports. I think you would have to query the invoice table for items matching the item name and a sales price of zero and calculate the percentage with a script:

https://docs.erpnext.com/docs/v13/user/manual/en/customize-erpnext/articles/making-custom-reports

1 Like