fix: only carry-forward balances till today's period
Showing data in future doesn't make sense. Only carry-forward till last
bucket that contains today's day.
diff --git a/erpnext/stock/report/stock_analytics/stock_analytics.py b/erpnext/stock/report/stock_analytics/stock_analytics.py
index 761b193..89ca9d9 100644
--- a/erpnext/stock/report/stock_analytics/stock_analytics.py
+++ b/erpnext/stock/report/stock_analytics/stock_analytics.py
@@ -233,6 +233,8 @@
periodic_data = get_periodic_data(sle, filters)
ranges = get_period_date_ranges(filters)
+ today = getdate()
+
for dummy, item_data in item_details.items():
row = {
"name": item_data.name,
@@ -242,13 +244,13 @@
"brand": item_data.brand,
}
previous_period_value = 0.0
- for _start_date, end_date in ranges:
+ for start_date, end_date in ranges:
period = get_period(end_date, filters)
period_data = periodic_data.get(item_data.name, {}).get(period)
if period_data:
row[scrub(period)] = previous_period_value = sum(period_data.values())
else:
- row[scrub(period)] = previous_period_value
+ row[scrub(period)] = previous_period_value if today >= start_date else None
data.append(row)