[fix] Get average selling rate based on group by
diff --git a/erpnext/accounts/report/gross_profit/gross_profit.py b/erpnext/accounts/report/gross_profit/gross_profit.py
index ba87cf1..4ae0e67 100644
--- a/erpnext/accounts/report/gross_profit/gross_profit.py
+++ b/erpnext/accounts/report/gross_profit/gross_profit.py
@@ -145,11 +145,11 @@
self.data.append(row)
if self.grouped:
- self.collapse_group()
+ self.get_average_rate_based_on_group_by()
else:
self.grouped_data = []
- def collapse_group(self):
+ def get_average_rate_based_on_group_by(self):
# sum buying / selling totals for group
self.grouped_data = []
for key in self.grouped.keys():
@@ -166,6 +166,8 @@
if new_row.base_amount else 0
new_row.buying_rate = (new_row.buying_amount / new_row.qty) \
if new_row.qty else 0
+ new_row.base_rate = (new_row.base_amount / new_row.qty) \
+ if new_row.qty else 0
self.grouped_data.append(new_row)